我想在GridView更新使用程序。
代码(CS): - public void update(object sender, GridViewUpdateEventArgs e)
{
SqlConnection conn = new SqlConnection(str_con);
conn.Open();
SqlCommand cmd1 = new SqlCommand("UpdateInfo", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.Add("@s_name", SqlDbType.VarChar).Value = (gv1.Rows[e.RowIndex].Cells[1].Text);
cmd1.Parameters.Add("@s_phone", SqlDbType.Int).Value = Convert.ToInt32(gv1.Rows[e.RowIndex].Cells[2].Text);//<-----error shows here
cmd1.Parameters.Add("@s_degree", SqlDbType.VarChar).Value = (gv1.Rows[e.RowIndex].Cells[3].Text);
cmd1.Parameters.Add("@s_id", SqlDbType.Int).Value = Convert.ToInt32(gv1.Rows[e.RowIndex].Cells[4].Text);
cmd1.ExecuteNonQuery();
gv1.EditIndex = -1;
BindData();
conn.Close();
}
存储过程: -
{C}