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

Question

    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();
        }

Answer 1

可以参考
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();
        }}

Answer 2

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