DataBoundGrid add row

[Francis Ouellet]

I have DataBoundGrid with a dataset as Datasource.
How to insert an added row in my grid in my
SQLServer database?

[Administrator]

You can add a row by calling grid.Binder.AddNew().

But inserting a row is problematic. Even if you insert a row outside the grid using dataTable1.Rows.Insert, it is added at the end of the DataTable.DefaultView until DataTable.AcceptChanges is called. So, if you want to insert a row, I think you will have to use DataTable.Rows.Insert, followed by dataTable.AcceptChanges.