Passing parameter to query for Access database

by

I would first create an OleDbCommand object and use this object to create a OleDbDataAdapter

Imports Data.OleDb

dim cmd as new OleDbCommand
cmd.Connection = con
cmd.CommandType = CommandType.Text
cmd.CommandText = "SELECT * FROM tblContacts where Name=? and City=?"

' Here we add the parameters in the same order they appear in the
' CommandText. The Name of the paramters can be anything when using
' a Jet database, only the order is important.
cmd.Parameters.Add("@Name", OleDbType.VarChar).value = "SLaks"
cmd.Parameters.Add("@City", OleDbType.VarChar).value = "New-York"

Dim da as new OleDbDataAdapter(cmd)

' Here you can use the Data Adapter as you would normally do.

I hope this helps.

More Related Contents:

  1. no value given for one or more required parameters
  2. When clicking “btnLogin”, my forms decrease in size.
  3. Trying to write the code to fill a field with smaller number
  4. Is there a conditional ternary operator in VB.NET?
  5. Classes vs. Modules in VB.NET
  6. Hidden Features of VB.NET?
  7. AndAlso/OrElse in VBA
  8. Count specific character occurrences in a string
  9. Add an event to all Forms in a Project
  10. Disable Image blending on a PictureBox
  11. VB.NET – IIF(,,) – Both “sides” are evaluated. What situations should I watch out for?
  12. How to listen keyboard in background and fire keystrokes on demand?
  13. How to order list of files by file name with number?
  14. The VB.NET ‘With’ Statement – embrace or avoid?
  15. Convert a string to a datetime
  16. VB.NET What is the purpose of a class or module?
  17. Parse a string to an Enum value in VB.NET
  18. A first chance exception
  19. API for Determining if App is Running on Citrix or Terminal Services [closed]
  20. VB.NET Checking if a File is Open before proceeding with a Read/Write?
  21. How to read a specific line from a text file in VB
  22. loop over all textboxes in a form, including those inside a groupbox
  23. Automatically adjusting winform and controls to screen size
  24. VB.Net Passing values to another form
  25. Transparency of picture box
  26. VB.NET null coalescing operator? [duplicate]
  27. Collection initialization syntax in Visual Basic 2008?
  28. Listen to key press when the program is in the background
  29. Executable directory where application is running from?
  30. Convert String to Double – VB

Leave a Comment