**Hi all. Im new to visual basic. im using vb 2008 express edition
what im trying to do is take everything in my database and put it in my datagridview.
The datagridview can be edited. From there, i want to make the changes then save them later.
So my question is, how do i go about saving all of the changes i made, back to my .mdb database?**
Jump to Postjust loop your datagrid view and save values , you can do like this
for i = 0 to datagridview.rows.count -1 'your code here nextRegards
just loop your datagrid view and save values , you can do like this
for i = 0 to datagridview.rows.count -1
'your code here
next
Regards
I would use a dataadapter to fill a dataset. Set the table from the Dataset as the DataSource of a BindingSource then set the BindingSource as the DataGridViews DataSource. Then you just call DataAdapter's update method when you update, add or delete records in your DataGridView. This will reflect all changes back to your DataBase Table.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.