How to Excecute sql SP by using Windows/Web servieces?

Question

I want to check some Customers status and update it on daily at perticular time automatic. So How to Excecute sql SP by using Windows/Web servieces? I done by agents and Windows tast schdeular which will not getting on shared hosting.

Azeem Anzari · Answer

Have you added installers to your project? If not then please follow below link to do that https://msdn.microsoft.com/en-us/library/ddhy0byf(v=vs.110).aspx After that you should install it from the framework's path for ex c:/Windows/Microsoft .net framework/v2.0..../ There you should have a file install.exe So the cmd prompt path is above framework path then install.exe -i c:/installer.exe Regards

Dawood Abbas · Answer

See I coded like below and installed .exe file by command prompt but its not working.. public partial class Service1 : ServiceBase { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings[dbconnection].ConnectionString.ToString()); SqlCommand command; private Timer timer = new Timer(); private double servicePollInterval; public Service1() { InitializeComponent(); servicePollInterval = 1000; } protected override void OnStart(string[] args) { timer.Elapsed += new ElapsedEventHandler(timer_Elapsed); timer.Interval = servicePollInterval; timer.AutoReset = true; timer.Enabled = true; timer.Start(); } protected override void OnStop() { timer.Stop(); } public void timer_Elapsed(object sender EventArgs e) { // Check the time to update the database if its 8 AM for ex if (DateTime.Now.Hour == 12 & DateTime.Now.Minute == 44 & DateTime.Now.Second == 1) { if (connection.State == ConnectionState.Closed) connection.Open(); command = new SqlCommand(); command.CommandText = Get_LoginFlag; command.CommandType = CommandType.StoredProcedure; command.Connection = connection; command.ExecuteNonQuery(); } } }

Dawood Abbas · Answer

aftre this how to run this serviece? and where to set its file?

Azeem Anzari · Answer

Create the project as windows service You have to use this namespace for timer using System.Timers; Declare below two variables at the class level private Timer timer = new Timer(); private double servicePollInterval; in the constructor initilize the servicePollInterval to 1000 public ClassA() { InitializeComponent(); servicePollInterval = 1000; } do the following in the onstart and stop method of windows service protected override void OnStart(string[] args) { timer.Elapsed += new ElapsedEventHandler(timer_Elapsed); timer.Interval = servicePollInterval; timer.AutoReset = true; timer.Enabled = true; timer.Start(); } protected override void OnStop() { timer.Stop(); } And then delcare timer_elapsed event as follows void timer_Elapsed(object sender EventArgs e) { // Check the time to update the database if its 8 AM for ex if (DateTime.Now.Hour == 08 & DateTime.Now.Minute == 00 & DateTime.Now.Second == 1 ) { //your update code goes here } Let me know n mark it as accepted if its useful for you regards

Dawood Abbas · Answer

in ElapsedEventHandler(timer_Elapsed); and timer.Interval = servicePollInterval; what is the 'timer_Elapsed' and 'servicePollInterval'? how to define it?

Dawood Abbas · Answer

What name spaces should I use for it?

Azeem Anzari · Answer

1. Create a windows service. 2. Declare a timer 3. in windows Service on_start method start the timer. protected override void OnStart(string[] args) { timer.Elapsed += new ElapsedEventHandler(timer_Elapsed); timer.Interval = servicePollInterval; timer.AutoReset = true; timer.Enabled = true; timer.Start(); } 4. in timer_elapsed function --> check the time you want to make the update for ex: if you want to update it at 8 AM if (DateTime.Now.Hour == 08 & DateTime.Now.Minute == 00 & DateTime.Now.Second == 1 ) { //update code goes here } Let me know by accepting the answer if its helps you regards