关于gridview更新 急!!!

来源:百度知道 编辑:UC知道 时间:2024/05/26 23:10:09
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
ConnectionStringSettings settings;
settings = ConfigurationManager.ConnectionStrings["ADVENTUREWORKS"];
strConn = settings.ConnectionString;

string sqlstr = "update Product set Name='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',ProductNumber='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "',Color='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim() + "',Size='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim() + "',Weight='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim() + "',Price='"

SQL语句有错,写进去的列并不是你数据库表里有的列

sql语句有错.

语句可真够长的
你输出下
GridView1.Rows[e.RowIndex].Cells[2].Controls[0]
的值
看是不是数组下标溢出了什么的

什么意思