Can I access rows & cols with a data source

[Ant]

Hi,
I'm new to ASP & the new ADO data model so please excuse the ignorance.

I have created a data source by simply dragging a table onto the design view.
Can I now pragmatically access columns & rows of that table via the data
source or must I transfer the data into another object (table, view etc)?

Many thanks for any help here
Ant

 

[Mike]

Hi,
I'm new to ASP & the new ADO data model so please excuse the ignorance.

I have created a data source by simply dragging a table onto the design
view.
Can I now pragmatically access columns & rows of that table via the data
source or must I transfer the data into another object (table, view etc)?

Many thanks for any help here
Ant

This depends on the mode of the datasource control. Its default setting is
DataSet, which returns a DataView object. The alternative, DataReader,
returns a DataReader object. Both are accessible by calling the datasource
control's Delect method:
http://www.mikesdotnetting.com/Article.aspx?ArticleID=45

Mike

 

[Ant]

This depends on the mode of the datasource control. Its default setting is
DataSet, which returns a DataView object. The alternative, DataReader,
returns a DataReader object. Both are accessible by calling the datasource
control's Delect method:
http://www.mikesdotnetting.com/Article.aspx?ArticleID=45

Mike

Thank you.

So if I had a Dataasource object would it be:

Dataview dv = myDataSource;

Many thanks for your help

Ant

 

[Ant]

This depends on the mode of the datasource control. Its default setting is
DataSet, which returns a DataView object. The alternative, DataReader,
returns a DataReader object. Both are accessible by calling the datasource
control's Delect method:
http://www.mikesdotnetting.com/Article.aspx?ArticleID=45

Mike

Hi Mike,

Thank you, that worked. I used the Select method into a Dataview.

Thank you very much
Ant