using sqldatasource with few queries

  • Thread starter Thread starter ruthiefy
  • Start date Start date
R

ruthiefy

Hi,

Is it possible to use the sqldatasource when I need a few
Select Commands on the same page?
I notice that I can put only one Select Command?
What is the recommanded approach in my case?

Thanks.
Ruthie.
 
Better use separate sqldatasources. The whole idea of sqldatasource is to
make your data access as simple as possible. It is not good for anything
above primitive and trivial.

In many cases all you need is just to read some data with a single select
statement to populate a control. For this situation you will want to use a
light read-only access that is provided by datareader controls. You can use
a sqldatasource and set its DataSourceMode property to datareader. If you
want to be a bit more in control, use just an SqlCommand object and run
queries with the ExecuteReader method. The method returns a datareader that
you can databind to a control via the DataSource property.


--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
 
Better use separate sqldatasources. The whole idea of sqldatasource is to
make your data access as simple as possible. It is not good for anything
above primitive and trivial.

In many cases all you need is just to read some data with a single select
statement to populate a control. For this situation you will want to use a
light read-only access that is provided by datareader controls. You can use
a sqldatasource and set its DataSourceMode property to datareader. If you
want to be a bit more in control, use just an SqlCommand object and run
queries with the ExecuteReader method. The method returns a datareader that
you can databind to a control via the DataSource property.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]http://msmvps.com/blogs/egoldinhttp://usableasp.net




Hi,
Click to expand...
Is it possible to use the sqldatasource when I need a few
Select Commands on the same page?
I notice that I can put only one Select Command?
What is the recommanded approach in my case?
Click to expand...
Thanks.
Ruthie.- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Thanks Eliyahu.

Your answer really helps!!!
 
Back
Top