Retrieve row count from an OLE DB data source

[kapilrakh]

Hello ,
I am trying to get no of rows from a table with a where clause.
I am having difficulty in writing the code as I am not able to find objects like "OleDbDataReader" or "OleDBCommand".

I have addded all the references I could but I don't know what I am missing.
I have the connection string ready as I obtained from a UDL file.

Progress so far

Please Login or Register  to view this content.

Please help. I could connect to OLEDB data source using Excel .

[Firefly2012]

You would need to create a new instance of the Class ie:

Please Login or Register  to view this content.

before you assign values to it.

[kapilrakh]

I get the error "Invalid use of New keyword"

[Firefly2012]

Can I ask what source of data you are targeting? Is it a database? In which case I would think you want to use ADO?

[kapilrakh]

Yes using ADO was the solution.

Please Login or Register  to view this content.