Bind 2 tables in an editable asp.net gridview & bulk update

Anand Deva

Scenarios:

I have two tables table A and Table B. table A has 5 columns and table B has 3 columns. Column A1 and B1 are a foreign key/reference column

Column A1 from table A to be bound as editable text field , Column B2 is a check box , B3 to be bound as editable text field

lets assume we have 10 rows bounded to a gridview. On clicking of edit we should update each row respectively. I had updated Row 1,5 and 7. So we should send only these 3 rows to a database through a datatable on clicking of save button which is placed under the gridview

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Tripathi8y ago
protected void YourGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
// do it here
}
Anand Deva8y ago
Update is not based on check box. Check box will have a flag vaue Y or N. This is also a field in grid
Manas Tripathi8y ago
1. foreach (GridViewRow row in grid.Rows)
2. {
3. if (((CheckBox)row.FindControl("chkboxid")).Checked)
4. {
5. //update data
6. }
7. }