Edit all rows for one column in GridView

Question

I would like to be able to mass edit all rows for a single column using the GridView control. What is the best way to do this?

Answer 1

If you want to update all rows with the same value, then display the correct control (text field / drop-down menu / checkbox / radio) in the column header, show the grid column in edit mode instead of label.

See the following:
http://www.codeproject.com/KB/webforms/BulkEditGridView.aspx

Answer 2

I think you know this: http://msdn.microsoft.com/en-us/library/ms972948.aspx

Answer 3

This is probably not the best, but the option is to set the primary key of your table as a DataKey GridView, then iterate over the grid and use the datakey value and the edited value to update the database. Here is an example.

<asp:GridView ID="GridView1" runat="server" DataKeyNames="ID"> <Columns>..... foreach (var item in GridView1.Items) { var id = (Guid)GridView1.DataKeys[item.DataItemIndex].Value; var txt= item.FindControl("AmountTextBox") as Textbox; if (cb != null && id.HasValue) UpdateRow(id.Value, txt.Text); }