how to make gridview editable in asp.net

Question

User193295959 posted

hi friends

I am showing data in gridview. and want user to modify it and click save button. then i will update database by sqldataadapter.update(dt.getchanges)... something like win application.

code like this..

dataTable dt = ds.Table[0]; //ds = dataset

dt = ds.GetChanges();

sqlda.update(dt.GetChanges();

how to make gridview editable??

Thanks for any help... 

Answer 1

User-1718920064 posted
set autogenerateeditbutton = true, write ur code in the appropriate event.

Answer 2

User-644392667 posted

Take a looksee here -> http://www.asp.net/learn/data-access/

:)

Answer 3

User-1635004338 posted

Hi raj_pushkar,

Have a look at this complete example about doing update, delete, insert and select in GridView with code behind (with DataTable):

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

Thanks,

Answer 4

User-1034726716 posted

how to make gridview editable??

GridView Insert, Edit, Update and Delete – The Ado.Net way - If using BoundField Columns

Adding Rows in GridView with Edit, Update and Delete Functionality - If using TemplateField Columns

Answer 5

User-1199946673 posted

 Although the others showed ou many examples on how to make the gridciew editable, they only show you the default behavior of the gridview, meaning you can only update 1 record at a time. I'm not sure if that's what you want? If you want to update all records of a gridview and save all changes at once, you should tak a look at:

Real World GridView: Bulk Editing