Using two Datareader

[Randall]

Hi all,
I have to use two separate queries in an .aspx file.
What is the way to use two Datareaders for that.

Or is there any other solution?

Any kind of help or coding or documentation is
appreciated.

Thanks,
Randall

 

[Steve C. Orr [MVP, MCSD]]

You could use a query that returns 2 resultsets.
When you're done with the first one, call NextResult.
Here's more info:
http://msdn.microsoft.com/library/d...qlclientsqldatareaderclassnextresulttopic.asp

Or you could use one or two DataSets instead of DataReaders.
Here's more info:
http://msdn.microsoft.com/library/d...ref/html/frlrfsystemdatadatasetclasstopic.asp

 

[Guest]

You can use

dim comm as sqlcommand = new sqlcommand("select * from
query1","select * from query2")

dim dataset1 as dataset= new dataset(comm,connectionstring)

dim da as new dataadapter

da.fill(comm)

da.table(0) for first query table
da.table(1) for second query table

Thanks
Ninan J

 

[Randall]

Thanks Ninan.
What if I have to use same table in both the queries?
Any suggestion?

Regards,
Randall.