how to update database using datagridview?

Posted by Sikret Miseon on Stack Overflow See other posts from Stack Overflow or by Sikret Miseon
Published on 2012-06-26T03:12:38Z Indexed on 2012/06/26 3:15 UTC
Read the original article Hit count: 205

Filed under:
|
|

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

© Stack Overflow or respective owner

Related posts about update

Related posts about datagridview