[exiled]

I use a DataGridView to Add/Edit/Delete records from an Access database. Doing those 3 things is working just fine. When I try to update the database with the new Table data, nothing happens. I need to basically overwrite the table in the database with the data that was added, edited or deleted in the DataGridView. I opened the connection and got the table data like this:

	Dim con As OleDbConnection = New OleDbConnection(source)
		PartsAdapter.SelectCommand = New OleDbCommand("SELECT " & PtsSql & " FROM Parts", con)
		comBuilder = New OleDbCommandBuilder(PartsAdapter)
		con.Open()
		PartsAdapter.Fill(PartsTable)
		D1.DataSource = PartsTable

and have tried for several days to get the data from DataGridView to save. The last code I used (and it failed) was this:

		Dim myDt = New DataTable("PartsTable")
		Dim myDataSet = New DataSet()
		myDataSet.AcceptChanges()
		PartsInventory.Update()

Surely there must be a way to save the edited data from a DataGridView back to the table in the database!?! Any help would be appreciated! Thanks!

This post has been edited by exiled: 03 February 2009 - 10:57 AM

[exiled]

***** RESOLVED IT MYSELF *****

[almcnicoll]

exiled, on 3 Feb, 2009 - 09:13 PM, said:

***** RESOLVED IT MYSELF *****

I have run into exactly the same issue. I tried using Andrew Timberlake-Newell's code (http://www.codeproje...ingBoundDB.aspx) which uses a boolean to store when data is dirty and then runs

myTableAdapter.Update(myDataSet.myTable)

on the datagrid's OnRowValidated event.

No joy. Would you mind sharing how you resolved the issue?

(By the way, I'm using an Access 2003 DB, coding with VS.NET 2008)

Al

[zbora23]

hi guys i finally have resolved that problem this is code for that

Me.myTableAdapter.Update(Me.myDataSet.myTable)

That is code for that i don't know if it is necessary to use '' Me. '' instead of nothing.
All you have to do is finish editing row, so enter all data trough all columns and on the last column after filling it out press ' TAB ' key and then save it
Data will save it then.Otherwise if you don't finish editing entire row it wont save.
if you don't know how to do it send me email on zbora23@yahoo.com , I'll send you movie with instructions.