Hi
The way i do it is adding a datagrid to the form, then connect to the database using a oleDBconnection connection and get the dataset. Then create a dataview and set its source as the table you want to display from the dataset.
then set the dataview as the datasource of the datagrid, and that should do it.
When you close the form, make sure to check if the dataset has changes and update if necessary.
Here is the code:
Private con As OleDbConnection = New OleDbConnection
Private comd As OleDbCommand = New OleDbCommand("SELECT * FROM Table", con)
Private dst As DataSet = New DataSet
Private dvw As DataView = New DataView
sub populate_datagrid()
con.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & database_file & ";Mode=Read|Write"
comd.CommandTimeout = 30 ' oledbcommand
dap.SelectCommand = comd ' data adapter
dst.Clear() ' clear the data set
dap.TableMappings.Clear() 'clear the data_adapter before using it
dap.TableMappings.Add("Table", "Table_name")
dap.Fill(dst, "Table_name")
dvw.Table = dst.Tables(0)
dvw.RowFilter = Nothing
Me.datagrid1.DataSource = dvw
End sub
regards
