borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB Home | News Home | Forum Home | Downloads | Register | Search | PM | Profile

Previous Topic (Appln looks left aligned in bigger monitors)Next Topic (Making multiple folders) New Topic Post Reply
AndreaVB OnLine : VB General : data logger which stores from textboxes every half an hour
Poster Resource
vivek_g27
Level: Sage

Registered: 06-04-2005
Posts: 57
icon data logger which stores from textboxes every half an hour

i want to make a data logger which stores the information in 3 textboxes to be stored every half an hour in any data base.

how to make such a function.

i dont have any idea about databases. so any thing on this front would be great

VIVEK

29-05-2006 at 10:12 AM
View Profile Send Email to User Show All Posts | Add Comment
xtramac
Level: Professor


Registered: 28-08-2005
Posts: 89
icon Re: data logger which stores from textboxes every half an hour

hello there...

1. add a timer to your form and set its property properly that it will only raise the event every 30 mins..
2. read anything about ADO...  

ex.. (note) i dont have a vb system right now so bare with it.. sorry..

'call this procedure inside the timer procedure .

sub SaveData(Text1 as string, text2 as string, text3 as string)
dim rs as new AdoDb.recordset

rs.open TableName / Query,DbConnection... ect.

rs!fld1 = text1
rs!fld2 = text2
rs!fld3 = text3
rs.update

rs.close
set rs = nothing

end sub

hope this helps....

  
andrew

30-05-2006 at 10:41 PM
View Profile Send Email to User Show All Posts | Add Comment
yronium
Level: Moderator


Registered: 14-04-2002
Posts: 907
icon Re: data logger which stores from textboxes every half an hour

Hello. Just my two cents: remember that with the Timer control you can't easily reach an half an hour time, as the largest allowed setting for the Interval property is 65536 milliseconds. A trick is to set a global counter variable, and increase it every minute (60000 ms): when it reaches 30, reset it to zero and do your operations.
Hope it helps.

[Edited by yronium on 31-05-2006 at 07:07 AM GMT]

____________________________
Real Programmer can count up to 1024 on his fingers

31-05-2006 at 06:07 AM
View Profile Send Email to User Show All Posts | Add Comment
vivek_g27
Level: Sage

Registered: 06-04-2005
Posts: 57
icon Re: data logger which stores from textboxes every half an hour

thanx.

that was great.

27-06-2006 at 09:43 AM
View Profile Send Email to User Show All Posts | Add Comment
AndreaVB OnLine : VB General : data logger which stores from textboxes every half an hour
Previous Topic (Appln looks left aligned in bigger monitors)Next Topic (Making multiple folders)New Topic Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder