DataReader Question 1

[dvannoy]

Can someone tell me whats wrong???


Dim dbcn As OleDb.OleDbConnection = New OleDb.OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("DB.mdb;&quot)

Dim DBComm = New OleDb.OleDbCommand("SELECT Field FROM Table", dbcn)

Dim MyReader As OleDb.OleDbDataReader

dbcn.Open()

This is where i have problems

MyReader = DBComm. the only choice is GetType..

I know it should be ExecuteReader..

What did i do wrong??

Forgive me I am still new to .Net

Thanks

 

[bradlkm]

Instead of this line:

Dim DBComm = New OleDb.OleDbCommand("SELECT Field FROM Table", dbcn)

Try this line:
Dim DBComm AS New OleDb.OleDbCommand("SELECT Field FROM Table", dbcn)

Without the "AS" in the declaration, it treats DBComm as a generic object, so the functions related with the OleDbCommand are not shown.

HTH!

 

[dvannoy]

Thanks