using timer in asp.net for performing insertion to a database at a particular time.

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

, +

Hi,

I want to add all my contents in my tables in local database to server database at the end of day automatically.Is it possible by setting timer in login page.Or else any other way.

I am using C# ASP.net 2008,SQL 2005.

Please help me.

Thanks.....

Posted 3-Aug-15 23:44pm

sayana3

Add a Solution

Comments

Ravi Shankar Dokka 4-Aug-15 6:02am

You can either create a stored procedure with all the insert statements or create an SSIS package.

Create a job to execute the stored procedure/SSIS package at your desired intervals.

Hope it helps.
Thanks.

sayana3 4-Aug-15 6:04am

Thanks for replying.
Where should i call the procedure then?

Ravi Shankar Dokka 4-Aug-15 6:11am

On your local database server you need to create a job. Refer the below link for creating the SQL job.
https://msdn.microsoft.com/en-IN/library/ms187910.aspx

sayana3 4-Aug-15 6:10am

how to check intervals in timer.Please any sample code or limk.

Thanks for replyng..

DamithSL 4-Aug-15 6:23am

what you mean by local database? asp.net running on server and you may have database server as well, so you have client databases?

sayana3 4-Aug-15 6:25am

i am doing an application for an institute.it has windows applications also.At evening all data must store in domain database automatically.

DamithSL 4-Aug-15 6:28am

where those windows applications store data temporarily?

sayana3 5-Aug-15 0:28am

In our local host database.

2 solutions

Solution 2

Setting up a timer at the page level will not solve your problem. ASP.Net pages are rendered on the client side and not on the server side.

Maybe you can create some sort of service that will push this data.
It will need to be installed on the client though...

Posted 4-Aug-15 1:01am

Abhinav S

Comments

sayana3 5-Aug-15 0:30am

Will you please give any sample link.I have no idea about it.

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

F-ES Sitecore · Accepted Answer · 2015-08-04T00:13:00

Solution 1

Google "asp.net schedule task", this is a very frequently asked question.

Posted 4-Aug-15 0:13am

F-ES Sitecore

using timer in asp.net for performing insertion to a database at a particular time.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

using timer in asp.net for performing insertion to a database at a particular time.

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us