Inserting data in database at regular interval all the time

Vishal agrawal

11y1.6k.NET

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

16 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal agrawal11y ago
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 sanyal11y ago
hi Vishal

Please go http://sudiptasanyal.blogspot.in/2014/01/schedule-job-at-specific-time-using.html
Vishal agrawal11y ago
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 Durano11y ago
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 agrawal11y ago
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 Durano11y ago
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 agrawal11y ago
Sir,

But how can i get data from my asp.net application to window service.
Vishal agrawal11y ago
But how can i get data from my asp.net application to window service.
Harish Chandra Patel11y ago
Hi Vishal

You need to create a windows service and host it to your web server.
Vishal agrawal11y ago
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 Uke11y ago
or you can create a saperate console application and add into task shedular inj windows
Shailesh Uke11y ago
yes you can not put in your project , You can create saperate windows service project
Vincent Maverick Durano11y ago
Windows service normally be in a separate project and should not be put inside your web application.
Vishal agrawal11y ago
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 Durano11y ago
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 Uke11y ago
Hi,

You can use the Windows Service for these program