how to write code "how to call one command two tables data"?

thanks you sir,

hello Chinna,

Kindly Share code.

only first table read :(

Hello Chinna,

Why are you select 6 tables in one select command.
Use stored proc like this.

Create proc sp_SelTable
as
Select * from table 1
Select * from table 2
Select * from table 3
Select * from table 4
Select * from table 5
Select * from table 6

return six tables. hold the record in dataset on pageload event.
bind gridview acc to table record like this.

If(ds.table[1].rows.count > 0)
{

}
If(ds.table[2].rows.count > 0)
{

}

for example:web form:papers.aspx ...
In papers.aspx web form six gird view is there .... and 6 tables are there(back end)
i want how to call 6 tables in  page_load event ?

ex:string s="select * form table1,table2,table3,table3,table4,table5,table6";
tell me single command in ado.net
help me plz

Hello,


Please explain more or share code for better understanding.

hi sir,
6 tables are there..6 different gridview are there...

how to call 6 tables in ado.net?
how to write code in ado.net for page_load event?
....

Hello,


Use join.