vb.net and access

[adamdavies]

hi im new to vb.net

trying to enter data in a datagrid with access

created oledbdataconnection and dataset

set datagrid member and source to dataset

using jet 4.0

it reads the headers from the db but not the fields.

tried hardcoding the connection, but not worked.

does anyone know where i am going wrong, or any tips

can provide more info if needed

thanks
adam

[Pirate]

I don't know about your code but you can adapt this code to meet your needs .

'setup the connection
        Dim MyConnection As New OleDbConnection(CnnStr)
        'setup the adapter
        Dim da As New OleDbDataAdapter("SELECT * FROM MyTab", MyConnection)
        'make a dataset to read into
        Dim ds As New DataSet()
        'open the connection
        MyConnection.Open()
        'now do the reading
        da.Fill(ds, "MyTab")
        'close and clean up
        MyConnection.Close()
        MyConnection.Dispose()
        da.Dispose()
        'bind to grid
        dgBinding.DataSource = ds.Tables("MyTab")