how to update database using datagridview?
- by Sikret Miseon
how do we update tables using datagridview? assuming the datagridview is editable at runtime? any kind of help is appreciated.
Dim con As New OleDb.OleDbConnection
Dim dbProvider As String
Dim dbSource As String
Dim ds As New DataSet
Dim da As OleDb.OleDbDataAdapter
Dim sql As String
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
dbProvider = "PROVIDER=Microsoft.ACE.OLEDB.12.0;"
dbSource = "Data Source = C:\record.accdb"
con.ConnectionString = dbProvider & dbSource
con.Open()
sql = "SELECT * FROM StudentRecords"
da = New OleDb.OleDbDataAdapter(sql, con)
da.Fill(ds, "AddressBook")
MsgBox("Database is now open")
con.Close()
MsgBox("Database is now Closed")
DataGridView1.DataSource = ds
DataGridView1.DataMember = "AddressBook"
End Sub
