CODEWITHSUNDEEP
vb.netms-access
user225269
user225269

Reputation: 10913

How to create parameterized queries in vb.net?

Using parameterized queries with ms access 2003 integration. To search any data according to different criteria.

Upvotes: 1

Views: 3862

Answers (2)

C. Ross
C. Ross

Reputation: 31848

You'll need to use the OleDbConnection class, as well as the OleDbCommand class, with the proper connection string for Access.

Dim sql as String = "SELECT * FROM TABLE_A WHERE COLUMN_A = @PARAM"
Dim connectionString as String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;"
Using connection As New OleDbConnection(connectionString)
   Dim command As New OleDbCommand(sql)
   command.Connection = connection
   command.Params.Add("@PARAM", yourVariable)
   connection.Open()
    Dim reader As OleDbDataReader = command.ExecuteReader()
    While reader.Read()
        Console.WriteLine(reader.GetString(1)
    End While
End Using

Upvotes: 3

Fionnuala
Fionnuala

Reputation: 91356

You may find this helpful: Howto? Parameters and LIKE statement SQL

Upvotes: 0

Related Questions