指定参数超出范围,index
protectedvoidGridView1_RowUpdating(objectsender,GridViewUpdateEventArgse){stringsqlst...
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string sqlstr = "update mytest set Name='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString().Trim ()
+"',Sex='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString().Trim ()
+"',Address='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString().Trim ()
+"'where ID='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text.ToString().Trim ()
+ "'";
//string sqlstr = "update mytest set Name='123'";
con = new SqlConnection(sqlCon);
cmd = new SqlCommand(sqlstr, con);
con.Open();
cmd.ExecuteNonQuery();
//取消编辑
GridView1.EditIndex = -1;
//绑定
bind();
con.Close();
} 展开
{
string sqlstr = "update mytest set Name='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString().Trim ()
+"',Sex='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text.ToString().Trim ()
+"',Address='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString().Trim ()
+"'where ID='" + ((TextBox)GridView1.Rows[e.RowIndex].Cells[0].Controls[0]).Text.ToString().Trim ()
+ "'";
//string sqlstr = "update mytest set Name='123'";
con = new SqlConnection(sqlCon);
cmd = new SqlCommand(sqlstr, con);
con.Open();
cmd.ExecuteNonQuery();
//取消编辑
GridView1.EditIndex = -1;
//绑定
bind();
con.Close();
} 展开
展开全部
这个问题很常见,索引超出范围。打个比方:就是一个数组有10项,你要访问第十一项时(没有第11项),就会出现这个问题。
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询