Using Extra Columns in SQLDataSource

  • Thread starter Thread starter Don Miller
  • Start date Start date
D

Don Miller

I have controls (dropdown list, radiobutton list) that are bound to an
SQLDataSource. In the SELECT statement in the DataSource configuration I
have tried to include other columns that would be useful to do something
with (e.g. store in an object, textbox, etc.) besides just populating the
databound control.

Is there way to access these extra columns in a SQLDataSource or do I have
to forget the DataSource control, query the database and populate the
controls and other desired items "manually"?

Thanks for any tips.
 
No need to populate the controls manually. When your task grows over the
typical and trivial, abandon the declarative databinding and go for the old
good DataSource property (as opposed to DataSourceID). Create a dataset,
populate the datatable and databind to it.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
 
Thanks. It took me awhile to find the available properties for a control
(like DataSource) since most don't show up in the Design view but they are
all there in Source view.

Eliyahu Goldin said:
No need to populate the controls manually. When your task grows over the
typical and trivial, abandon the declarative databinding and go for the
old good DataSource property (as opposed to DataSourceID). Create a
dataset, populate the datatable and databind to it.

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


Don Miller said:
I have controls (dropdown list, radiobutton list) that are bound to an
SQLDataSource. In the SELECT statement in the DataSource configuration I
have tried to include other columns that would be useful to do something
with (e.g. store in an object, textbox, etc.) besides just populating the
databound control.

Is there way to access these extra columns in a SQLDataSource or do I
have to forget the DataSource control, query the database and populate
the controls and other desired items "manually"?

Thanks for any tips.
Click to expand...
Click to expand...
 
Back
Top