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