Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

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
0
SweetingA
Asked:
SweetingA
  • 5
  • 2
1 Solution
 
x-menIT super heroCommented:
yes, create connection to the SQL Database on your project.
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
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
0
 
SweetingAAuthor Commented:
yes it will be in script

i will pass data from a form into an sql table

thanks
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
SweetingAAuthor Commented:
i know how to send data, i just don;t know how to do it every 10 seconds
0
 
SweetingAAuthor Commented:
oh forgot to mention i need to send the date/time stamp with it
0
 
Big MontySenior Web Developer / CEO of ExchangeTree.org Commented:
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
0
 
SweetingAAuthor Commented:
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
0
 
SweetingAAuthor Commented:
It was correct but no detail how to achieve
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now