This week, I needed to bind a gridview to and SQLDataSource. The only problem is that I need to include extra rows. How to do this? First I removed the binding code to bind the grid directly from HTML (in gridview remove the DataSourceID attribute).
Then I wanted to get the data from the SQL Data source and convert to a data table to insert and update the table as needed. Next is the code to get the data…
DataView dv = new DataView(); DataTable dt = new DataTable(); dv = mySQLDataSource.Select(DataSourceSelectArguments.Empty); dt = dv.ToTable();
To insert new rows in the data table
DataRow row = dt.NewRow(); dt["FieldName1"] = "Field 1"; dt["FieldName2"] = 9; dt.Rows.Add(row);
Finally, to bind the datatable to a gridview, use the next code:
gridView1.DataSource = dt; gridView1.DataBind();
Hope this helps 😉 Happy Binding