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