Is it possible to edit the contents present in DataGrid..?

[premMS143]

Hi everybody,
How to make changes/updates to the data present in the data grid..?

I've connected DataGrid to a mdb table.
Now I want it to be accept changes made to the existing data to be saved.
Just like adding, deleting, sorting, editing the datagrid.


Thanks in advance.

[jg007]

it is pretty easy to do this and there are plent of examples from google but the basic idea is ( IIRC :)

create a data adaptor
use the command builder on the data adaptor
call the data adaptor ' .update ' method passing it the datagrid with the updated data

[premMS143]

it is pretty easy to do this and there are plent of examples from google but the basic idea is ( IIRC :)

create a data adaptor
use the command builder on the data adaptor
call the data adaptor ' .update ' method passing it the datagrid with the updated data

Could you explain in detail please with Code..
Because I'm newer to VB.
Please don;'t mind..

[jg007]

sorry, I don't want to spoon feed you the answer but have a look at this link and see if you can work it out .

if you have problems please post the code and any error messages in full that you get with an explanation of how your database is layed out

http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter.update.aspx