update dataadapter
How do you update a database (access 2003) with values that have been changed in a datagridview?
I use this code to fill a datagridview with data:
Private Sub frmdeliveryreport_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim spDataConnection As New OleDb.OleDbConnection
spDataConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="test.mdb"
mysql = "SELECT * FROM tblMain"
Dim spDataAdapter = New OleDb.OleDbDataAdapter(mysql, spDataConnection)
Dim deliveryds As New DataSet
spDataAdapter.Fill(deliveryds, "tblDelivery")
Me.DataGridView.DataSource = deliveryds.Tables("tblDelivery")
End Sub
I want to use a "Save Data" button to update the database with new data. Any ideas what code I'll need?
|