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.
I get an error with ExecuteReader saying:Code: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()
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!!![]()


Reply With Quote