ถ้าหากว่าอยากจะให้ ProcessBar แสดงตอนที่กำลังดึงข้อมูลจากฐานข้อมูลมาใส่ใน data table

Private Sub btnImport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnImport.Click

            objConn = New System.Data.OleDb.OleDbConnection("Provider=VFPOLEDB.1;Data Source=" & txtPathFile.Text & "")
            objConn.Open()
            strSQL =" select * from ..."
            dtAdapter = New OleDbDataAdapter(strSQL, objConn)
            dtAdapter.Fill(dt)
            MyDataGrid.DataSource = dt
            dtAdapter = Nothing
            objConn.Close()
            objConn = Nothing
 Dim connetionString As String
 Dim connection As MySqlConnection
 Dim adapter As New MySqlDataAdapter
 Dim i As Integer
Dim sql As String
Dim myCom As MySqlCommand
Dim Tran As MySqlTransaction

        connetionString = "server=localhost;User Id=root;password=1234;database=datacenter"
        connection = New MySqlConnection(connetionString)
        connection.Open()
        myCom = New MySqlCommand
       Tran = connection.BeginTransaction
        myCom.Transaction = Tran

        For i = 0 To dt.Rows.Count - 1
           sql = "insert into...."
            myCom.Connection = connection
           myCom.CommandText = sql
            myCom.Parameters.Clear()
            myCom.Parameters.AddWithValue("@Rcode", dt.Rows(i)(0))
            myCom.ExecuteNonQuery()
        Next
       connection.Close()
end sub