gridview控件的deleting事件怎么写
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string sqlstr = "delete from student where ID='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
strconn = ConfigurationSettings.AppSettings["dsn"];
con = new SqlConnection(strconn);
con.Open();
cmd = new SqlCommand(sqlstr , con);
cmd.ExecuteNonQuery();
con.Close();
bind();
}
public void bind()
{
string sqlstr = "select ID,name,sfz,sex,class,grade,department from student";
strconn = ConfigurationSettings.AppSettings["dsn"];
con = new SqlConnection(strconn);
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, con);
DataSet myds = new DataSet();
con.Open();
myda.Fill(myds, "student");
GridView1.DataSource = myds;
GridView1.DataKeyNames = new string[] { "ID" };//主键
GridView1.DataBind();
con.Close();
}
索引超出范围。必须为非负值并小于集合大小。
参数名: index
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.ArgumentOutOfRangeException: 索引超出范围。必须为非负值并小于集合大小。
参数名: index
源错误:
行 126: {
行 127:
行 128: string sqlstr = "delete from student where ID='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
行 129: strconn = ConfigurationSettings.AppSettings["dsn"];
行 130: con = new SqlConnection(strconn);