Hi,
I have 10 labels each labels consists of different numeric values which gets updated every 2 ms.now i am trying to save these datas to my access database in a row by row format every 10 ms.So every 1 sec my access database should be updated with 100 rows of data.i am using the below code inside a timer ,but i can only manage to insert 20 rows.is there any possible ways to achieve this,or am i using a wrong approach.please help me out.
thanks
Dim datacomm As String
Private Sub GetUpdates()
Try
datacomm = "insert into datatable1 ([date_], [time_], [data1], [data2], [data3], [data4], [data1_av], [data2_av],[data3_av],[data4_av],[filename]) values ('" _
& DateString & "',0,'" & Label138.Text & "','" & Label140.Text & "','" & Label142.Text & "','" & Label144.Text & "','" & Label134.Text & "','" & Label137.Text & _
"','" & Label133.Text & "','" & Label93.Text & "','" & My.Settings.excelfilename & "')"
Dim cmd As New OleDbCommand(datacomm, myConn)
cmd.ExecuteNonQuery()
Catch ex As Exception
End Try
End Sub