How to save Datatable

[ch46guy]

I'm trying to save the entire datatable. The datatable is named DataTableGrid1. Any suggestions why this isnt working.

Thanks

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim sql As String
        sql = String.Format("insert * from notes")
        Dim con = db.GetConnection
        Dim cmd As New OleDbCommand(sql, con)
        Dim ds As New DataSet
        Dim da As New OleDbDataAdapter(cmd)


        'lookup dataset changes


        da.Update(DataGridView1) 'Fill Dataset with Table data


    End Sub

[jmcilhinney]

It's not working for a number of reasons. I suggest that you follow the CodeBank link in my signature below and check out my thread on Retrieving & Saving Data to see how to use a data adapter and a DataTable. After populating the DataTable, you can bind it to a BindingSource and then bind that to the grid, e.g.

Me.BindingSource1.DataSource = myDataTable
Me.DataGridView1.DataSource = Me.BindingSource1

When you're ready to save, call EndEdit on the BindingSource before calling Update on the data adapter.