SqlDataSource Data, Can not get to it

  • Thread starter Thread starter LVP
  • Start date Start date
L

LVP

Hi,

I have a sqldatasource01 configured properly and can databind it to a
CheckBoxList and see data with no problem.

How can I get the data programmatically from the sqldatasource01
I need to loop through it. and get the extra columns passed in the
sqldatasource01
I don't want to loop through the CheckBoxList because it does not have all
the extra columns.

Can I do this with one sqldatasource and not two.

help

thanks

LVP
 
Hi,

I have a sqldatasource01 configured properly and can databind it to a
CheckBoxList and see data with no problem.

How can I get the data programmatically from the sqldatasource01
I need to loop through it. and get the extra columns passed in the
sqldatasource01
I don't want to loop through the CheckBoxList because it does not have all
the extra columns.

Can I do this with one sqldatasource and not two.

help

thanks

LVP
Click to expand...

Hi

The SqlDataSource component is really for binding directly to web
server controls at design time to save coding. I think you'll find
that the internal data structures of those components aren't really
accessible in code.

If you require programmatic access to SQL data tables (and you don't
want to write reams of code using the traditional components in the
System.Data.SqlClient name space) then try adding a DataSet to the
project. A wizard will take you through the process of setting up a
TableAdapter (a new version of the old SqlDataAdapter) and DataTable
defined in an XSD file (which by default will go in the App_Code
folder).

New namespaces will be added to your project containing objects for
the TableAdapter and DataTable which can be created and used as
required (DataViews then can be created and used in the normal
manner). Whatever columns you require can be exposed in the Select
statement (the wizard can bring up QueryBuilder if you wish to
construct it visually). The DataTable can also be used as the
datasource for the CheckBoxList if you like so that only one
datasource is used, but the binding process will require some
programmatic intervention. Try it and see.
 
Phil,

I will follow your recommendations and see where I get stuck next.

I appreciate you taking the time to explain this.

much thanks,

LVP
 
Back
Top