Looping through records in an ODBC recordset in .NET 2.0 1

[dashen]

.
.
.
            idRS = idCmd.ExecuteReader()

            If idRS.HasRows Then
                idRS.Read()

                Dim myStreamWriter As StreamWriter

                Dim rptPath As String
                rptPath = Environ("TEMP") & "\idReport.html"

                myStreamWriter = File.CreateText(rptPath)

                Do Until idRS.HasRows = False

                    myStreamWriter.WriteLine(idRS.Item(1).ToString & " " & _
                                             idRS.Item(2).ToString & " " & _
                                             idRS.Item(3).ToString)

                    idRS.NextResult()
                Loop

                myStreamWriter.Close() 'commit stream to file

                System.Diagnostics.Process.Start("iexplore", rptPath)

            Else
                MsgBox("Bye")
            End If

Any ideas on how to loop through a ODBC RecordSet in VB.NET 2.0? It doesn't seem to have a complete method library for me to use. Please, any help would be great.

 

[dashen]

Anybody?

 

[Dashley]

dashen

use the datareader if you just want to plow through the records. It looks like your on the right track.

Dim DR1 as odbcdatareader
Dim myCmd As New ODBCCommand
mycmd.connection= you connection goes here
mycmd.commandtext=("sql goes here)

dr1=mycmd.executereader

while dr1.read

do somthing here.

end while