Bind a DataTable to a gridview and add Edit Capability to the grid

Question

Hello , I want to know the best way about when we want to bind a dataTable generated based on a searchResult to a gridview ( Just for now we want to show one record ) ,

now how can we add edit-delete capability for this record shown in the gridview ? How many ways do we have for this ,

I know some but I want to reshape my knowledge , and find better ways

( the information will be bound after user clicked a button . )

Answer 1

Instead of using a datatable you could use the SQLDataSource control which will allow you to set the different SQL commands you want to perform. By binding your gridview to this datasource you could then modify the gridview using the Edit/Update command button, modify the gridview edit templates, etc. This would provide you a fairly easy way of going about it.

If you are looking for something which gives you more control over the whole process, here is a tutorial for setting up insert/update/delete functionality to a gridview:

http://www.aspdotnetcodes.com/GridView_Insert_Edit_Update_Delete.aspx