Dim sql As String = "select contactname from customers ' Create connection Dim conn As SqlConnection = New SqlConnection(connString) Try ' Open connection conn.Open() ' Create command Dim cmd As SqlCommand = New SqlCommand(sql, conn) ' Create data reader Dim rdr As SqlDataReader = cmd.ExecuteReader() ' Loop through result set While rdr.Read Console.WriteLine("" & rdr(0)) End While ' Close data reader rdr.Close()>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 >>