ADO and access Prepared query

[amit_m04]

Hi

i have created a table in access and also have created a query using query wizzard which takes a parameter.
is it possible to use that query in ADO, so that i dont have to write the SQL statement again..

please help me in this..

 

[jmcilhinney]

First up, you'd use ADO.NET in VB.NET, not ADO.

To answer your question, yes you can. When you create an OleDbCommand, by default its CommandType property is Text and its CommandText property is expected to contain SQL code. You can set the CommandType to StoredProcedure and then assign the name of your query to the CommandText.

 

[amit_m04]

could you please give me an example of this..
i have just started with .net past 2 days... is there any book that you would reffer..

 

[jmcilhinney]

If you want to get a book then I know that this one is good, but I can't speak for the myriad of others out there.

Visual Basic 2008 How to Program

There are plenty of online resources available too, which are cheaper than books, e.g.

Microsoft Visual Basic .NET tutorials for Beginners