通过简单的Google搜索，您可以找到许多关于数据库使用的文章。另请参阅使用MS Excel（xls / xlsx） ）使用MDAC和Oledb [ ^ ]和使用ADO .NET for beginners [ ^ ]。

I have connected to my database the code that i used is not working plus i don't understand it as i am still a starter

What I have tried:

Imports System.Data.OleDb

Public Class Form1

    Dim myDA As OleDbDataAdapter
    Dim myDataSet As DataSet

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim con As OleDbConnection = New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=|DataDirectory|\myDB.mdb")
        Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM Table1", con)
        con.Open()
        myDA = New OleDbDataAdapter(cmd)
        'Automatically generates DeleteCommand,UpdateCommand and InsertCommand for DataAdapter object   
        Dim builder As OleDbCommandBuilder = New OleDbCommandBuilder(myDA)
        myDataSet = New DataSet()
        myDA.Fill(myDataSet, "MyTable")
        DataGridView1.DataSource = myDataSet.Tables("MyTable").DefaultView
        con.Close()
        con = Nothing
    End Sub

    ' Save data back into database   
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Me.Validate()

  Me.myDA.Update(Me.myDataSet.Tables("MyTable"))
        Me.myDataSet.AcceptChanges()
    End Sub

End Clas

There are many articles on database usage that you can find with a simple Google search. Also see Working with MS Excel(xls / xlsx) Using MDAC and Oledb[^] and Using ADO.NET for beginners[^].