dataset problem

[Hasan Afridi]

hi any body tell me that if i have multiple tables in dataset and i want to bind only one to datagrid ,how can i do that?

[dip_developer]

hi any body tell me that if i have multiple tables in dataset and i want to bind only one to datagrid ,how can i do that?

you just create a dataadapter.......fill the dataset table you want like following.....

 
myDataAdapter.Fill(myDataset,"myTableNameInDataset")
 

now bind your grid as usual....

myGrid.Datasource=myDataset.Tables("myTableNameInDataset")

next time you can fill another table with that same Adapter....

[ammoos]

you can use table index for select a particular table from the dataset
eg:
SqlDataAdapter da=new SqlDataAdapter("SELECT ClientName,IDClient FROM tbl_ClientDetails WHERE IDClient=140;SELECT IDClient,SiteName FROM tbl_SiteDetails WHERE IDClient=140",con );
DataSet ds=new DataSet();
da.Fill(ds);

if you want to select the first table, then you can use

DataGrid1.DataSource=ds.Table[0];
DataGrid1.DataBind();

else
if you want to select the second table then use
DataGrid1.DataSource=ds.Table[1];
DataGrid1.DataBind();