I have placed a datagrid on VB.NET form. It displays data when I click on + sign and Table name.

However, I want to display data directly as soon as the form opens without navigation.

Can anybody tell how to do that?

hi anita

use DataGrid.DataSource = DataSet.Tables("TableName")

i hope it will help

HI,

When you assign a DataSet as DataSource propert of DataGrid, it actually attaches it with the DataTables Collection. DataGrid is confused, which Table you want exactly. So it displays to choose.

So you haveto tell it explicitly the table name a


 ObjDGrid.DataSource=ObjDataSet.Tables(0)

OR u can use this also

 ObjDGrid.DataSource=ObjDataSet.Tables("DataTableNa me")

Then use

 ObjDGrid.Expand (-1) ''This will expand all the rows if u have used datarelation inside dataset

Hope this helps