Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SqlDataSource and DataReaders
Message
From
23/05/2008 17:54:29
 
 
To
All
General information
Forum:
ASP.NET
Category:
Coding, syntax and commands
Title:
SqlDataSource and DataReaders
Miscellaneous
Thread ID:
01319299
Message ID:
01319299
Views:
52
I am trying to figure out how to review the records retrieved with a SqlDataSource in code without using a display control. My research thus far suggests this can be done via a DataReader but I am unable to figure it out. If the datasource is SqlDataSource1 and it is configured to return a DataReader, can someone show me how to get at the records with VB? Something like:
<<pseudo code>>
dim oReader as Data.SQLClient.SQLDataReader = SqlDataSource1.DataReader

 While oReader.Read()
    Console.WriteLine(String.Format("{0}, {1}", oReader(0), oReader(1)))
 End While
Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform