OLEDB Commands

[dvannoy]

What references should be set to use OLEDB and ADO.NET using ASP.NET?

all the code I've seen goes as follows..

Dim cn AS OleDbConnection

cn = New OleDbConnection etc..

when I start typing this all I can do is...

cn = New OleDb.OleDbConnection

everything I type wants the OleDb first...

also when trying to use the following:

DataReader = Command.ExecuteReader..

my only option under Command. is GetType..

can someone point me in the right direction??


Thanks

 

[Zarcom]

If you put Imports System.OleDb at the very top of your code-behind page you can use any of the classes objects under the OleDb namespace.

As for the command thing. How did you declare it? That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540

 

[dvannoy]

OK, thanks I'll try that...sorry it was my fault with the command thing..it would help if I declared it hu??

ONe other thing..whats the equal of rs.Movefirst in asp.net... I can connect and pull data into a textbox..just how do you navigate through the recordset(or reader)

Thanks alot..

 

[Zarcom]

yes it does help

You can't navagate through a reader. A reader is a foward only pipe of data.

To navagate around the data you need a dataset. It's very powerful. Check this location in the VS.NET help
ms-help://MS.VSCC/MS.MSDNVS/cpguide/html/cpconaccessingdatawithadonet.htm That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540