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

Dawood Abbas

11y994Visual Basic .NET

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.

7 Replies

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

Azeem Anzari11y ago
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
0
Dawood Abbas11y ago
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();
}
}
}

0
Dawood Abbas11y ago
aftre this how to run this serviece?
and where to set its file?
0
Azeem Anzari11y ago
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
0
Dawood Abbas11y ago
in ElapsedEventHandler(timer_Elapsed); and timer.Interval = servicePollInterval;
what is the 'timer_Elapsed' and 'servicePollInterval'? how to define it?
0
Dawood Abbas11y ago
What name spaces should I use for it?
0
Azeem Anzari11y ago
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
0