Link to home
Start Free TrialLog in
Avatar of SweetingA
SweetingA

asked on

Pass data from vb to sql server per time interval

Is it possible to pass data from vb 2010 express to an sql server 2008 database in time intervals, say every 10s?

Thanks for the help
ASKER CERTIFIED SOLUTION
Avatar of x-men
x-men
Flag of Portugal image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
what data are you looking to pass? is the "vb2010 express" some kind of web app, desktop app, or script? are you looking to have some kind of input form and save it to the database?

more details please
Avatar of SweetingA
SweetingA

ASKER

yes it will be in script

i will pass data from a form into an sql table

thanks
i know how to send data, i just don;t know how to do it every 10 seconds
oh forgot to mention i need to send the date/time stamp with it
without seeing what you have already, it's difficult to figure out what you're doing. is this an ajax request being sent to the server every 10 seconds? please explain a bit more what you're attempting to do
I have managed to do it using a timer but i have to use the varchar format to get it to work, is there a way to pass it as a datetime format....

Label9.Text = DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss")

I simply set the timer click to 10000 and use the on click event of the timer
It was correct but no detail how to achieve