[RESOLVED] Extract data from SQLDataSource
I have created a SQLDataSource web server control, and i made a repeater and bound the source to the repeater. It works great.
I was wondering how you would go about extracting data from the SQLDataSource control using VB code. Without binding it to an object.
Example... say the DataSource control is getting all rows from a table. How would you access the data without binding it to a control?
Is there a control specifically for this purpose?
Cheers
Re: Extract data from SQLDataSource
I don't think you can extract it directly from the DataSource object itself.
The usual ways are filling DataSets or DataReaders.
Here's the msdn description of the Sql DataSource class: http://msdn2.microsoft.com/en-us/lib...atasource.aspx
HoraShadow
Re: Extract data from SQLDataSource
yea didn't think so, I've done it using an SQLClient.
Cheers
Re: [RESOLVED] Extract data from SQLDataSource
SqlClient is the namespace. Namespaces don't actually do anything.
What class did you use within it?
Re: [RESOLVED] Extract data from SQLDataSource
so how is it resolved ? =/