Hello,
Can someone guide me or help me , because i cannot find any information on google about this.
I'm trying to find a way how to make this:
- Timer - that will reload progress bar after lets say 5min , name: Timer1
- Progress bar - that will count how much users have , name: ProgressBarShow
I use ms access as database
and my sql is like this :
Code:Public ServerStatus As String = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Path & File & ";") Public conn As New OleDbConnection(ServerStatus) Public cmd As New OleDbCommand Public Sub ConnectDB() 'Check for DB Status If conn IsNot Nothing Then conn.Close() End If Try conn.Open() MsgBox("Connected") Catch ex As Exception MsgBox("Database Error:[" & ex.Message & "]") End Try End Sub Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load Timer1.Start() End Sub Private Sub Timer1_Tick(sender As Object, e As EventArgs) Handles Timer1.Tick Try With cmd conn.Open() .Connection = conn .CommandText = "Select Count(*) From Accounts order by ID" 'How to create it after i cant find information ProgressBarShow.value += 1 ' I think this is correct fo increase number End With Catch ex As Exception MsgBox(ex.Message) Finally cmd.Dispose() If conn IsNot Nothing Then conn.Close() End If End Try End If End Sub




Reply With Quote
