How to use parameterized queries in vb.net? Because I always wanted to make a program that could read an ms access database and display results based on your query.
A:
Create the desired query using question marks in the place of your parameters
Dim sql = "SELECT * FROM Students WHERE Name = ?"
Then create a OleDbCommand object and set the appropriate values (CommandText and so on). Then add Parameters to the command object. Finally, execute it how you need. Eg as ExecuteReader.
rob_g
2009-12-05 05:05:43