Inserting data in database at regular interval all the time

Question

sir I need to create such a utility under my asp.net C# web application that will keep on inserting data at regular interval all the time on server side only. Currently i m using timer base data insertion but problem that i m facing is that data is being inserted as long as client request the url. And Data is not inserted until and unless there is a single client request to the url and also when more that one client using the same url then there is duplicate data insertion inb database. Kindly suggest me any solution to overcome this problem. Regards Vishal Agrawal

Vishal agrawal · Answer

i m not able to call class objects and method in application_start event in global.asax. Kindly tell how to access those objects and method written under defualt.aspx.cs file

sudipta sanyal · Answer

hi Vishal Please go http://sudiptasanyal.blogspot.in/2014/01/schedule-job-at-specific-time-using.html

Vishal agrawal · Answer

Sir let me clear to you I have to display real reading which i m getting from some hardware equipment continuously to client on the web and simultaneously i have to save these reading in database for analysis purpose. The problem is that since client is not active all the time so the code which i have written in my asp.net program would not executed all the time. And also i am using net socket for getting reading from this equipment which can respond to one project at a time. let me know how to create such a function that stored these reading in database all the time and simultaneously display the reading to client when any request is made . Regards Vishal

Vincent Maverick Durano · Answer

Well that how the web works. A client will issue a request then your server give a response back to the client allowing them to do something in the page. In this case they input data and you collect the data in your web app code. The data inputs typically coming from the client. How do you collect and store data if there no request from the client?

Vishal agrawal · Answer

Dear Vincent Maverick Durano sir but data will only be stored in database as long as client request to URL. Data will not be stored when url is not being requested by any of client. Regards Vishal

Vincent Maverick Durano · Answer

You need to store your data from you web app (asp.net) in a database or file so in your service you can pull the data from it and do your process.

Vishal agrawal · Answer

Sir But how can i get data from my asp.net application to window service.

Vishal agrawal · Answer

But how can i get data from my asp.net application to window service.

Harish Chandra Patel · Answer

Hi Vishal You need to create a windows service and host it to your web server.

Vishal agrawal · Answer

Sir I m getting data which i have to save in database is taken by net socket control which can be used at one project only because it can provide data to one connection at a time . so how we can use it more than project simultaneously. regards Vishal

Shailesh Uke · Answer

or you can create a saperate console application and add into task shedular inj windows

Shailesh Uke · Answer

yes you can not put in your project  You can create saperate windows service project

Vincent Maverick Durano · Answer

Windows service normally be in a separate project and should not be put inside your web application.

Vishal agrawal · Answer

Sir Thank U for your immediate reply. Actually i m new to this. Kindly tell me how to add window service inside my existing Web application. Regards Vishal

Vincent Maverick Durano · Answer

I agree that using windows service is the way to go. You could write an scheduled job that inserts data to your database using windows service. here's a step by step example that you can refer. Alternatively you could also try looking into SQL Job Agent.

Shailesh Uke · Answer

Hi You can use the Windows Service for these program