Solved

Pass data from vb to sql server per time interval

Posted on 2014-01-28
8
172 Views
Last Modified: 2014-02-06
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
Comment
Question by:SweetingA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
8 Comments
 
LVL 18

Accepted Solution

by:
x-men earned 500 total points
ID: 39814710
yes, create connection to the SQL Database on your project.
0
 
LVL 33

Expert Comment

by:Big Monty
ID: 39815169
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
 

Author Comment

by:SweetingA
ID: 39816266
yes it will be in script

i will pass data from a form into an sql table

thanks
0
MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

 

Author Comment

by:SweetingA
ID: 39816267
i know how to send data, i just don;t know how to do it every 10 seconds
0
 

Author Comment

by:SweetingA
ID: 39816278
oh forgot to mention i need to send the date/time stamp with it
0
 
LVL 33

Expert Comment

by:Big Monty
ID: 39816287
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
 

Author Comment

by:SweetingA
ID: 39816391
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
 

Author Closing Comment

by:SweetingA
ID: 39838970
It was correct but no detail how to achieve
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question