vb and sql

[panimalar]

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......

[Sabin_33]

Which version of VB and SQL do you have?

Which controls on the form are you repopulating?

[HanneSThEGreaT]

Need a bit more info!

[panimalar]

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

[Shuja Ali]

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.

[panimalar]

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

[HanneSThEGreaT]

You could use the SQL Count function, if I'm not mistaken

[rahul.kul]

You could use the SQL Count function, if I'm not mistaken

I Agree with your Hannes..!

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.