windows service
-
Hi I want to use a Windows Service to call certain stored procedures once a day. It needs to pass the DateTime.Now as a variable to these stored procedures. If someone could please help me out as to how i implement a timer and call stored procedures and pass the current datetime to the stored procedures. Thanks
-
Hi I want to use a Windows Service to call certain stored procedures once a day. It needs to pass the DateTime.Now as a variable to these stored procedures. If someone could please help me out as to how i implement a timer and call stored procedures and pass the current datetime to the stored procedures. Thanks
You can initialize a variable of System.Threading.Timer in the OnStart method as set up event handler for Elapsed event. In the event handler call the stored procedure using sqlcommand object and pass the parameter by adding it to Parameters collection
#region signature my articles #endregion