Looping through a ResultSet with ADO.NET

[cpluspluser]

Hi,

Simply trying to get a ResultSet and loop through it in ADO.NET. This is what I've got and it ain't working.

       Dim dr As System.Data.OleDb.OleDbDataReader()
        Dim comm As New OleDb.OleDbCommand()
        comm.CommandText = "Select * from data2"
        comm.CommandType = CommandType.Text
        dr = comm.ExecuteReader(CommandBehavior.CloseConnection)

        Dim s As String
        s = ""
        While dr.read()
            MessageBox.Show(dr("id2").ToString())
        End While
        dr.close()

I get an error with ExecuteReader saying:

Value of type System.Data.OleDb.OleDbDataReader cannot be converted to a 1-dimensional array of type System.Data.OleDb.OleDbDataReader.


Any idea what this problem is????

Thanks!!

[Edneeis]

You declared dr as an array, probably removed a New statement in there. Remove the () at the end of the declaration.

Dim dr As System.Data.OleDb.OleDbDataReader'no parathesis