title: how to make a simple SQL query from VB.net (access db)
body: <p>I have a working dataset and datagrid already in my project, but I want to make my own quicksearch button. The following code gives error for connectionstring PROVIDER KEYWORD NOT SUPPORTED</p>
  
  <pre><code>connetionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\prod.mdb"
  
  sql = "Select (*) from table1 where prodid=" + searchfield.Text
  
  cnn = New SqlConnection(connetionString)
  Try
      cnn.Open()
      cmd = New SqlCommand(sql, cnn)
      Dim ret = (cmd.ExecuteScalar())
      cmd.Dispose()
      cnn.Close()
      Text = ret
  </code></pre>