Jet and .NET

[gollnick]

I have this code:

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim cmd As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\temp\Export.mdb;"
Dim dc As New OleDb.OleDbConnection(cmd)
Dim da As New OleDb.OleDbDataAdapter("SELECT * FROM MdseFile", cmd)
Dim ds As New DataSet()
dc.Open()
da.Fill(ds, "MdseFile")
dc.Close()
dc.Dispose()
da.Dispose()
'bind to grid
DataGrid1.DataSource = ds.Tables("ItemMast")
End Sub

and have a datagrid on my form.
This runs (at least no running error) but does not fill out the datagrid and display any data. There is data in the file MDSEFILE.

What am I doing wrong?

[Pirate]

There is data in the file MDSEFILE.

Is this file or table in the database??
I hope it's typing mistake

[hellswraith]

You never call the DataBind method of the grid.

After this line:
DataGrid1.DataSource = ds.Tables("ItemMast")

insert:
DataGrid1.DataBind()

[Pirate]

I can bind it without that line though !

[Lunatic3]

You never call the DataBind method of the grid.

After this line:
DataGrid1.DataSource = ds.Tables("ItemMast")

insert:
DataGrid1.DataBind()

There is not such a method as DataBind for datagird. At least I am not aware of.

The problem is he is setting the datasource as DataGrid1.DataSource = ds.Tables("ItemMast")

but "ItemMast" is not a table in ds.

[Pirate]

exactly , it confused me . It might be another table in the same database .

[hellswraith]

Sorry, I was thinking of the Web Data Grid.

[gollnick]

Issue resolved .. the line DataGrid1.Databind() was not valid and did not work. It was a matter of dumb typing...