hi there...
i need to catch data fro sql database every 1 minute to the vb form....i know i have to use timer but i really dunno do to do......do anyone have the source code.....help me......:(
Printable View
hi there...
i need to catch data fro sql database every 1 minute to the vb form....i know i have to use timer but i really dunno do to do......do anyone have the source code.....help me......:(
Which version of VB and SQL do you have?
Which controls on the form are you repopulating?
Need a bit more info! :thumb:
I’m using visual basic 6 and sql server 2000…need to catch data from sql every 1 minute to vb form and assign it to chart(charttype2dbar).. how do i do that.....i need to use timer but i dunno how to fetch the data every 1 minute........can anyone help me... do anyone have the source code
Here is how you do it.
Put a timer control on the Form. Set the Interval property of the timer control to 60000 (Approximately 1 minute). In the Timer Event write the code for retrieving data. For example, Open a recordset using the query and then populate it wehere ever you want.
The timer event will always file every 1 minute and will retrieve the data from the database.
one more question...
in my database table.... i have stored few data's....... and the data is yes and no....... now there are 4 data with yes... how do i count this data...using sql command statement....and assign it to the chart... i've tried but i couldnt.... please help me
You could use the SQL Count function, if I'm not mistaken
I Agree with your Hannes..!Quote:
Originally Posted by HanneSThEGreaT
Like this ;
"Select count(at_Yes) as CntOfYes from YOUR_TABLE_NAME"
then use CntOfyes field to retrieve the Count Value for Yes type of Records... and same for No type of Data.