求助 ： 为什么报 索引超出范围。必须为非负值并小于集合大小。\r\n参数名: index

[kevinhu520]

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string PROD_ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
string sql = "delete from JXC_WARE_INFO where PROD_ID=" + PROD_ID;
try
{
SqlCommand cmd = new SqlCommand(sql,conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
bind();
}
catch(SqlException ex)
{
throw new Exception(ex.Message,ex);
}
finally
{
conn.Close();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string PROD_ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
try
{
string sql = "update JXC_WARE_INFO set WARE_NAME='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',WARE_TYPE='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "',WARE_UNIT='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim() + "',WARE_SPECIFICATION='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim() + "',WARE_STOCK='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim() + "',WARE_PRICE_JJ='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[7].Controls[0])).Text.ToString().Trim() + "',WARE_PRICE_SJ='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[8].Controls[0])).Text.ToString().Trim() + "',WARE_MANUFACTURER='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[8].Controls[0])).Text.ToString().Trim() + "',WARE_NOTE='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[10].Controls[0])).Text.ToString().Trim() + " where PROD_ID=" + PROD_ID;

SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
GridView1.EditIndex = -1;
bind();
}

[wdgphc]

走到哪一句时报的错?

[namhyuk]

为什么好好的数据源控件不用，非要用这种代码方式来更新/删除呢？
难道2.0的数据源控件只是摆设吗？

[downmoon]

可以参考
http://www.cnblogs.com/downmoon/archive/2007/12/30/1021151.html

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string PROD_ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
try
{
string sql = "update JXC_WARE_INFO set WARE_NAME='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "',WARE_TYPE='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "',WARE_UNIT='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim() + "',WARE_SPECIFICATION='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim() + "',WARE_STOCK='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim() + "',WARE_PRICE_JJ='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[7].Controls[0])).Text.ToString().Trim() + "',WARE_PRICE_SJ='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[8].Controls[0])).Text.ToString().Trim() + "',WARE_MANUFACTURER='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[8].Controls[0])).Text.ToString().Trim() + "',WARE_NOTE='"
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[10].Controls[0])).Text.ToString().Trim() + " where PROD_ID=" + PROD_ID;

SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
GridView1.EditIndex = -1;
bind();
}

}

[downmoon]

另外注意设置datakeys

[lonelygames]

还是自己学会跟踪高度吧！这样这种问题就不需要求人了！

[YiCaoYiMu08]

if (e.Row.RowType == DataControlRowType.DataRow)

[Krismeng]

[Quote=引用 5 楼 lonelygames 的回复:]
还是自己学会跟踪高度吧！这样这种问题就不需要求人了！
[/Quote]