Hi

I use this sub to fill a datagridview, it works fine. But how do add edit/add and delete functions to it?

Sub BindGrid()
Dim sqlStr As String = "SELECT * FROM tbl_Work"
Dim conn As OleDbConnection = New OleDbConnection(MyProviderString)
Dim da As OleDbDataAdapter = New OleDbDataAdapter(sqlStr, conn)
Dim ds As DataSet = New DataSet
da.Fill(ds, "tbl_Work")
Dim dv As DataView = ds.Tables("tbl_Work").DefaultView
DataGridView1.DataSource = ds.Tables("tbl_Work").DefaultView
End Sub

Regards

Hi

Did you mean writing data back into the database? If so, there are two ways to achieve this.

First, if the tbl_Work table has a primary key or a unique column, you can use a CommanderBuilder object to auto-generate the InsertCommand, UpdateCommand, and DeleteCommand for the DataAdapter. Check this page for a sample.

Second, you can create your own InsertCommand, UpdateCommand, and DeleteCommand for the DataAdapter. Try something like the following:

You need to call Update method for the DataAdapter when you want to write back to the database.

Hope this helps.
Best regards.
Rong-Chun Zhang

Hi

Did you mean writing data back into the database? If so, there are two ways to achieve this.

First, if the tbl_Work table has a primary key or a unique column, you can use a CommanderBuilder object to auto-generate the InsertCommand, UpdateCommand, and DeleteCommand for the DataAdapter. Check this page for a sample.

Second, you can create your own InsertCommand, UpdateCommand, and DeleteCommand for the DataAdapter. Try something like the following:

You need to call Update method for the DataAdapter when you want to write back to the database.

Hope this helps.
Best regards.
Rong-Chun Zhang