Question Using MS Access parameterized queries in ADO .Net

[pranav_vaidya]

Hi,

I am using VB 2008 (.Net 3.5) and MS Access 2003.

I have few queries in MS Access which accept one or more parameters and return rows matching the parameters. In VB 6 I would use ADO Command and ADO Parameter object to execute these queries.

How can I do the same in VB.Net or ADO.Net? The parameters I pass are mostly of type String, Date and Integer. And MS Access query may return more than 1 row matching the criteria.

Please note, this is my first database project in VB.Net, I never used ADO.Net before.

Any suggestions?
Thanks in advance.

Pranav
PN-MH, India

 

[cjard]

read the DW2 link in my signature, section Creating a Simple Data App, then Creating a Form to Search Data. Remember DW2 is for .NET 2.0, some content may have 3.5 specific sections and these are shown in the panel on the top right