reuse SQLDataReader in multiple dropdownlists?

[Craig Buchanan]

I would like to reuse a SQLDataReader that is populated with information as
the datasource for multiple dropdownlists. Unfortunately, the first DDL
closes the SDR and my code fails on the second DDR. Is there a way to
copy/clone the SDR? Is there another solution?

Thanks,

Craig Buchanan

[Cowboy \(Gregory A. Beamer\)]

DataSet. Can bind to as many controls as you wish.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************
"Craig Buchanan" <so*****@somewhere.com> wrote in message
news:eK**************@TK2MSFTNGP09.phx.gbl...

I would like to reuse a SQLDataReader that is populated with information as the datasource for multiple dropdownlists. Unfortunately, the first DDL
closes the SDR and my code fails on the second DDR. Is there a way to
copy/clone the SDR? Is there another solution?

Thanks,

Craig Buchanan

[Mark Fitzpatrick]

Not to mention it's disconnected. DataReaders keep an open connection to the
database so re-using the same DataReader will waste a lot of bandwidth and
server time fetching the rows again and again. The DataSet (or DataTables
for that matter) fetch all the results and then close the connection. Much
more efficient if you are using the data repeatedly and much nicer on the
database.

Hope this helps
Mark Fitzpatrick
Microsoft MVP - FrontPage

"Cowboy (Gregory A. Beamer)" <No************@comcast.netNoSpamM> wrote in
message news:O7**************@TK2MSFTNGP11.phx.gbl...

DataSet. Can bind to as many controls as you wish.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************** ********************
Think Outside the Box!
************************************************** ********************
"Craig Buchanan" <so*****@somewhere.com> wrote in message
news:eK**************@TK2MSFTNGP09.phx.gbl...

I would like to reuse a SQLDataReader that is populated with information

as

the datasource for multiple dropdownlists. Unfortunately, the first DDL
closes the SDR and my code fails on the second DDR. Is there a way to
copy/clone the SDR? Is there another solution?

Thanks,

Craig Buchanan

[Steve C. Orr [MVP, MCSD]]

Another solution is that you can bind your second DDL to your first.

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

"Craig Buchanan" <so*****@somewhere.com> wrote in message
news:eK**************@TK2MSFTNGP09.phx.gbl...

I would like to reuse a SQLDataReader that is populated with information as the datasource for multiple dropdownlists. Unfortunately, the first DDL
closes the SDR and my code fails on the second DDR. Is there a way to
copy/clone the SDR? Is there another solution?

Thanks,

Craig Buchanan

[Craig Buchanan]

how is this done? the datasource is write only.

thanks,

craig

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:uA**************@TK2MSFTNGP10.phx.gbl...

Another solution is that you can bind your second DDL to your first.

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

"Craig Buchanan" <so*****@somewhere.com> wrote in message
news:eK**************@TK2MSFTNGP09.phx.gbl...

I would like to reuse a SQLDataReader that is populated with information

as

the datasource for multiple dropdownlists. Unfortunately, the first DDL
closes the SDR and my code fails on the second DDR. Is there a way to
copy/clone the SDR? Is there another solution?

Thanks,

Craig Buchanan