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/de...esulttopic.asp

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

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
Hire top-notch developers at http://www.able-consulting.com


"Randall" <an*******@discussions.microsoft.com> wrote in message
news:04****************************@phx.gbl...

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

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

-----Original Message-----
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
.

[Randall]

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

Regards,
Randall.

-----Original Message-----
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

-----Original Message-----
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
.

.