Insert/Update/Delete Data from DataGrid !!!!

[rex028]

GUYS !! PLEASE HELP ME OUT !!

i'm having a situation below:

1) how to insert the data from Datagrid while i press "Save" Button ...
2) how to update the data from Datagrid while i press "Update" Button ...
3) how to Delete the data from Datagrid while i press "Update" Button ...
4) it is the most important issue is how can i add a new row with the data i entered in the text boxes into datagrid while i press "Add" !!!

pleaseeeee help me ... pleaseeeeeee

please check out the attachment of the interface ...

pleaseeeeeeeeeeeeeeeeeeee

 

[levyuk]

Could you simply add the data to a database then run the datagrid again, e.g. load the data into the datagrid again. I guess this is very resource intensive though but it could work

 

[kanak]

hey which dataadapter u r using .. u can use the dataadapter provided by .net..drag them in your form ..configure them .. and they will automatically generate the update , delete , insert , etc sql statements ... all what u have to do is ... update the changes in ur dataset ... by using
.remove
.delete

and then call ( suppose ur adapter name is 'adapter' and dataset name is ds)
adapter.update(ds)

thats all and ur work is done ... ;-)

 

[DotNotzz]

this site answers every question that exists for datagrids - it is phonominal !

http://aspnet.4guysfromrolla.com/articles/040502-1.aspx

might bend your brain at first mind !

rgrds-j