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

Question

how to write code "how to call one command two tables data in ado.net"? plz help me

Jitendra Kumar · Answer

Hello Chinna, Strored proc like this :- create proc sp_GetTablesRcd As Select * from table1 Select * from table2 Select * from table3 Select * from table4 See attached file :-

Chinna Netha · Answer

thanks you sir,

Jitendra Kumar · Answer

hello Chinna, Kindly Share code.

Chinna Netha · Answer

only first table read :(

Jitendra Kumar · Answer

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) { }

Chinna Netha · Answer

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

Jitendra Kumar · Answer

Hello, Please explain more or share code for better understanding.

Chinna Netha · Answer

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? ....

Jitendra Kumar · Answer

Hello, Use join.

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

Answers (9)