protected void btn4_Click(object sender, EventArgs e)
{
SqlConnection connSelect = new SqlConnection(connStr);
SqlConnection connProc = new SqlConnection(connStr);
SqlConnection connView = new SqlConnection(connStr);
string sqlStrSelect = "select XM, XB,CONVERT(char(20),CSSJ,20) AS CSSJ,KCS from XS where XM ='"+xm.Text.Trim()+"'";
string sqlStrView = "select*from XMCJ_VIEW";
try
{
connSelect.Open();
SqlCommand myCommand = new SqlCommand(sqlStrSelect, connSelect);
SqlDataReader reader = myCommand.ExecuteReader();
if (reader.Read())
{
xm.Text = reader["XM"].ToString();
xb.SelectedValue = reader["XB"].ToString();
cssj.Text = reader["CSSJ"].ToString();
kcs.Text = reader["KCS"].ToString();
Image1.ImageUrl = "Pic.aspx?id=" + xm.Text.Trim();
Lbl_Msg.Text = "查找成功!";
}
connProc.Open();
SqlCommand proCommand = new SqlCommand();
proCommand.Connection = connProc;
proCommand.CommandType = CommandType.StoredProcedure;
proCommand.CommandText = "CJ_PROC";
SqlParameter SqlXm = proCommand.Parameters.Add("@xml", SqlDbType.Char, 8);
SqlXm.Direction = ParameterDirection.Input;
SqlXm.Value = xm.Text.Trim();
proCommand.ExecuteNonQuery();
connView.Open();
SqlDataAdapter mda = new SqlDataAdapter(sqlStrView, connView);
DataSet ds = new DataSet();
mda.Fill(ds, "XMCJ_VIEW");
GridView1.DataSource = ds;
GridView1.DataBind();
}
catch
{
Lbl_Msg.Text = "查找失败,请检查操作权限!";
}
finally
{
connSelect.Close();
connProc.Close();
connView.Close();
}
}
加断点执行后错误在于proCommand.ExecuteNonQuery();,提示错误原因为用户代码未识别sqlexception,列名“李明 ”无效。李明是数据库中的一个姓名。