Member Avatar for jerviejeb

**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?**

  • 3 Contributors
  • 2 Replies
  • 115 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by kRod
Member Avatar for M.Waqas Aslam

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

Member Avatar for kRod

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.

Edited by kRod because: Formatting
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.