silentkiller
21.09.2007, 22:08
Imports System.Data.OleDb
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim a As String
a = MsgBox("Are Sure Want To Quit", MsgBoxStyle.OkCancel, "System Exit")
If a = vbOK Then
Me.Close()
Else
End If
End Sub
Public Sub Doldur()
Dim baglanti As New OleDb.OleDbConnection
baglanti.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db.mdb"
baglanti.Open()
Dim kaynak As New OleDb.OleDbCommand
kaynak.Connection = baglanti
kaynak.CommandType = CommandType.Text
kaynak.CommandText = "select * from users"
Dim ad As New OleDb.OleDbDataAdapter
Dim ds As New DataSet
ad.SelectCommand = kaynak
ad.Fill(ds, "users")
DataGridView1.DataSource = ds.Tables("users")
baglanti.Close()
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
BackgroundWorker1.RunWorkerAsync()
End Sub
Private Sub BackgroundWorker1_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork
Doldur() 'call doldur procedure
BackgroundWorker1.ReportProgress(200)
Threading.Thread.Sleep(500)
BackgroundWorker1.ReportProgress(400)
Threading.Thread.Sleep(500)
BackgroundWorker1.ReportProgress(1000)
'Threading.Thread.Sleep(500)
'BackgroundWorker1.ReportProgress(800)
'Threading.Thread.Sleep(500)
'BackgroundWorker1.ReportProgress(1000)
End Sub
Private Sub BackgroundWorker1_ProgressChanged(ByVal sender As System.Object, ByVal e As System.ComponentModel.ProgressChangedEventArgs) Handles BackgroundWorker1.ProgressChanged
ProgressBar1.Value = e.ProgressPercentage
End Sub
Private Sub BackgroundWorker1_RunWorkerCompleted(ByVal sender As System.Object, ByVal e As System.ComponentModel.RunWorkerCompletedEventArgs) Handles BackgroundWorker1.RunWorkerCompleted
MessageBox.Show("Giriş Onaylandı")
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
ProgressBar1.Maximum = 1000
Control.CheckForIllegalCrossThreadCalls = False
BackgroundWorker1.WorkerReportsProgress = True
End Sub
End Class
Public Class Form1
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim a As String
a = MsgBox("Are Sure Want To Quit", MsgBoxStyle.OkCancel, "System Exit")
If a = vbOK Then
Me.Close()
Else
End If
End Sub
Public Sub Doldur()
Dim baglanti As New OleDb.OleDbConnection
baglanti.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\db.mdb"
baglanti.Open()
Dim kaynak As New OleDb.OleDbCommand
kaynak.Connection = baglanti
kaynak.CommandType = CommandType.Text
kaynak.CommandText = "select * from users"
Dim ad As New OleDb.OleDbDataAdapter
Dim ds As New DataSet
ad.SelectCommand = kaynak
ad.Fill(ds, "users")
DataGridView1.DataSource = ds.Tables("users")
baglanti.Close()
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
BackgroundWorker1.RunWorkerAsync()
End Sub
Private Sub BackgroundWorker1_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork
Doldur() 'call doldur procedure
BackgroundWorker1.ReportProgress(200)
Threading.Thread.Sleep(500)
BackgroundWorker1.ReportProgress(400)
Threading.Thread.Sleep(500)
BackgroundWorker1.ReportProgress(1000)
'Threading.Thread.Sleep(500)
'BackgroundWorker1.ReportProgress(800)
'Threading.Thread.Sleep(500)
'BackgroundWorker1.ReportProgress(1000)
End Sub
Private Sub BackgroundWorker1_ProgressChanged(ByVal sender As System.Object, ByVal e As System.ComponentModel.ProgressChangedEventArgs) Handles BackgroundWorker1.ProgressChanged
ProgressBar1.Value = e.ProgressPercentage
End Sub
Private Sub BackgroundWorker1_RunWorkerCompleted(ByVal sender As System.Object, ByVal e As System.ComponentModel.RunWorkerCompletedEventArgs) Handles BackgroundWorker1.RunWorkerCompleted
MessageBox.Show("Giriş Onaylandı")
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
ProgressBar1.Maximum = 1000
Control.CheckForIllegalCrossThreadCalls = False
BackgroundWorker1.WorkerReportsProgress = True
End Sub
End Class