Error in Update function

Question

I created this datagrid in my .aspx file.

<asp:datagrid id="Computerchange" runat="server" AllowPaging="True" PageSize="2" AutoGenerateColumns="False" BorderColor="Gainsboro" Height="500px">
    <Columns>
        <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" HeaderText="Admin Functions" CancelText="Cancel" EditText="Edit"></asp:EditCommandColumn>
        <asp:ButtonColumn Text="Delete" HeaderText="Delete" CommandName="Delete"></asp:ButtonColumn>
        <asp:BoundColumn DataField="com_id" ReadOnly="True" HeaderText="Computer Number"></asp:BoundColumn>
        <asp:BoundColumn DataField="company" HeaderText="Company"></asp:BoundColumn>
        <asp:BoundColumn DataField="price" HeaderText="Price"></asp:BoundColumn>
        <asp:BoundColumn DataField="model" HeaderText="Model"></asp:BoundColumn>
        <asp:BoundColumn DataField="description" HeaderText="Description"></asp:BoundColumn>
        <asp:BoundColumn DataField="id" ReadOnly="True" HeaderText="Category"></asp:BoundColumn>
        <asp:BoundColumn DataField="quantity" ReadOnly="False" HeaderText="Quantity"></asp:BoundColumn>
        <asp:BoundColumn DataField="imgSrc" HeaderText="Image"></asp:BoundColumn>
    </Columns>
</asp:datagrid>

With this datagrid I want to edit-delete-update these columns in my database. When I have ReadOnly="False" in the quantity column then it works fine. I can Edit-Delete-Update everything. Sometimes I want to edit all the columns except QUANTITY. But when I convert it to True, then I have the following error when I click the Update button

Specified argument was out of the range of valid values. Parameter name: index

Stack Trace:

[ArgumentOutOfRangeException: Specified argument was out of the range of valid values. Parameter name: index]

System.Web.UI.ControlCollection.get_Item(Int32 index) +8750274 AdminMainPage.Computerchange_UpdateCommand(Object source, DataGridCommandEventArgs e) +626 System.Web.UI.WebControls.DataGrid.OnUpdateCommand(DataGridCommandEventArgs e) +115 System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +498 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +121 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +125 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +169

System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +9 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +176 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Do you know why I have this error and what can I do to fix it? I wrote this function for the update Command

private void Computerchange_UpdateCommand(object source, 
System.Web.UI.WebControls.DataGridCommandEventArgs e)   
{
    //Store updated column values in local variables:

    //string updateCOM_ID = e.Item.Cells["com_id"].Text;

    string updateCOM_ID = e.Item.Cells[2].Text;

    string updateCompany = ((TextBox)e.Item.Cells[3].Controls[0]).Text;

    double updatePrice = double.Parse(((TextBox)e.Item.Cells[4].Controls[0]).Text);

    string updateModel = ((TextBox)e.Item.Cells[5].Controls[0]).Text;

    string updateDescription = ((TextBox)e.Item.Cells[6].Controls[0]).Text;

    int updateCategoryId = int.Parse(e.Item.Cells[7].Text);

    string updateImage = ((TextBox)e.Item.Cells[9].Controls[0]).Text;

    string updateQuantity = ((TextBox)e.Item.Cells[8].Controls[0]).Text;

    newView.RowFilter = "com_id='" + updateCOM_ID + "'";

    if (newView.Count > 0)
    {
        //Delete the row that is being updated

        newView.Delete(0);
    }

    newView.RowFilter = "";

    //Create a new DataRow and populate it with the new data.

    DataRow Row = Table.NewRow();

    Row["com_id"] = updateCOM_ID;

    Row["company"] = updateCompany;

    Row["price"] = updatePrice;

    Row["model"] = updateModel;

    Row["description"] = updateDescription;

    Row["id"] = updateCategoryId;

    Row["imgSrc"] = updateImage;

    //Row["quantity"] = updateQuantity;

    //Insert the new DataRow:

    Table.Rows.Add(Row);

    Computerchange.EditItemIndex = -1;

    Computerchange.DataSource = newView;

    Computerchange.DataBind();

    // Now update the database with the new data

    adminCentral1.adminCentral newData = new adminCentral1.adminCentral();

    string results;

    results = newData.updateItem(updateCOM_ID, updateCompany, updatePrice, updateModel, updateDescription, updateImage, updateCategoryId, updateQuantity);

    if (results == "Success")
    {
        errorLabel.Text = "Computer Updated to database!";
    }
    else
    {
        errorLabel.Text = results;
    }

onof onof · Accepted Answer · 2011-07-26T14:38:35

Because when ReadOnly="True" it renders only text, not a control, so Controls[0] throws an exception. Use a TemplateColumn instead:

<asp:TemplateColumn HeaderText="Quantity">
<ItemTemplate>
  <%# Eval("quantity") %>
</ItemTemplate>
<EditItemTemplate>
  <asp:TextBox runat="server" ID="tbQuantity" Text='<%# Eval("quantity") %>' ReadOnly="False" />
</EditItemTemplate>
</asp:TemplateColumn>

You can set tbQuantity's ReadOnly property to true to disable editing.

Error in Update function

1 Answers