How to make Loading while insert data in database?

Amrul NigthBlue

Please help me i want to proccesing execute data reader while insert to database with progress bar

Private Sub Refresh_Click(sender As Object, e As EventArgs) Handles Refresh.Click
Dim i As Integer
Dim Koneksi As New MySqlConnection("Server=localhost;UID=root;Database=pt_laksana;PWD=;port=3306")
Dim adapter As New MySqlDataAdapter("SELECT no as No,nama_barang as 'Nama Barang',jumlah as Jumlah, date as 'Tgl/Bln/Th', saldo as Saldo, keterangan as Keterangan, mengetahui as Mengetahui, diketahui as Diketahui, action as Action From data_barang;", Koneksi)
Dim READER As MySqlDataReader
Dim COMMAND As MySqlCommand
Dim dt As New DataTable
'Menyimpan hasil query
adapter.Fill(dt)
'data masuk ke datagrid
Riwayat_TransaksiDashboard.DataSource = dt
Try
Koneksi.Open()
Dim Query As String
Query = "select * From pt_laksana.data_barang"
COMMAND = New MySqlCommand(Query, Koneksi)
READER = COMMAND.ExecuteReader
MsgBox("Refresh Data")
While READER.Read
Chart1.Series("Series1").Points.AddY(READER.GetInt32("jumlah"))
Chart1.Series("Series2").Points.AddY(READER.GetInt32("saldo"))
For i = 1 To 10
Riwayat_TransaksiDashboard.Refresh()
Next
End While
Finally
Koneksi.Close()
End Try
End Sub

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
HI, for long process you can use background worker process to mange I have written an article using Background worker process you can refer that. here I am showing an .gif image for user interaction when it starts , and when it finish I am visibiling

http://www.c-sharpcorner.com/article/import-excel-data-into-sql-table-using-sqlbulkcopy-in-c-sharp/
Gnanavel Sekar9y ago
use Progress bar and you can see it in below link

http://stackoverflow.com/questions/20028989/display-progress-of-execution-through-progress-bar
http://www.c-sharpcorner.com/UploadFile/deepak.sharma00/how-to-show-progress-of-fetching-database-records-using-a-pr/
Ramesh Palanivel9y ago
Hi Amrul,

Try to add Progress bar and set timer control for that ..

Kindly read about thread and sleep method,

Make the progress bar to load upto insert the record...
Amrul NigthBlue9y ago
windows application
Ramesh Palanivel9y ago
Hi Amrul,

Is it windows application or Wen application?