søge og opdatere mit datagridview

Fandt selv en løsning

Hejsa, må jeg spørge hvad din løsning var, for jeg har snart prøvet alt?

Private dbConProvider As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\_data\Projects.NET\MusikJukebox\MusikJukebox\Database.mdb"
  Private DbConn As Data.OleDb.OleDbConnection

Private Sub bind_datagrid(ByVal sQuery As String, ByVal datagrid As System.Windows.Forms.DataGridView)
      Try
        Dim mycon As New System.Data.OleDb.OleDbConnection()
        Dim myadpt As New System.Data.OleDb.OleDbDataAdapter()
        Dim myset As New DataSet()
        Dim mycmd As New System.Data.OleDb.OleDbCommand()
        mycon.ConnectionString = dbConProvider
        mycon.Open()
        mycmd.CommandText = sQuery
        mycmd.Connection = mycon
        myadpt.SelectCommand = (mycmd)
        myadpt.Fill(myset, "datasetname")
        datagrid.DataSource = myset
        datagrid.DataMember = "datasetname"
        mycon.Close()

      Catch err As Exception
        MsgBox(err.Message)
      End Try
  End Sub