title: How to search data in all tables in database using select query in vb.net?
body: <p>How to search data in all tables in database using select query in vb.net? Here is my code:</p>
  
  <pre><code>Try
      mysqlconn.Open()
  
      Dim query As String
      query = "select * from  where (Item_Description LIKE '%" &amp; TextBox11.Text &amp; "%' or Vendor LIKE '%" &amp; TextBox11.Text &amp; "%' OR S_N LIKE '%" &amp; TextBox11.Text &amp; "%' or Tag_num LIKE '%" &amp; TextBox11.Text &amp; "%')"
      command = New MySqlCommand(query, mysqlconn)
      sda.SelectCommand = command
      sda.Fill(dbdataset)
      bsource.DataSource = dbdataset
      DataGridView1.DataSource = bsource
      sda.Update(dbdataset)
      mysqlconn.Close()
  
  Catch ex As Exception
  
  Finally
      mysqlconn.Dispose()
  End Try
  </code></pre>