What is not working exactly?
On 10/5/05, smartboy3k <[EMAIL PROTECTED]> wrote:
> Dear All,
>
> I have written a windows service which will hit the database at a
> regular intervals, and display a popup on the desktop if a new record
> is inserted into the table. But it seems to be not working.
>
> for testing i implemented the code in windows form and my timer is
> calling the function which hit the DB at regular intervals. This is
> not happening in the windows service. Can any one pls help me out
> with this as it is very urgent.
>
> Below is the code i wrote in windows service. Any kind of help on
> this is well appreciated.
>
> public class Service1 : System.ServiceProcess.ServiceBase
> {
>
> protected Timer timer;
> private static int initalCnt = 0;
> private static int cnt = 0;
>
> public Service1()
> {
>
> this.ServiceName = "ForumService";
> timer = new Timer();
> timer.Interval = 10000;
> timer.Enabled = true;
> timer.Elapsed += new ElapsedEventHandler(OnTimer);
> timer.Start();
> }
>
> static void Main()
> {
> System.ServiceProcess.ServiceBase[] ServicesToRun;
> ServicesToRun = new System.ServiceProcess.ServiceBase
> [] { new Service1() };
> System.ServiceProcess.ServiceBase.Run(ServicesToRun);
> }
>
> protected override void OnStart(string[] args)
> {
> if(Convert.ToInt32(Process.GetProcessesByName
> ("SysTray").Length) <= 0)
> {
> string arg = ConfigurationSettings.AppSettings
> ["url"].Trim() ;
> System.Diagnostics.Process.Start
> (@ConfigurationSettings.AppSettings["TrayExe"].ToString(),arg);
> timer.Enabled = true;
> }
> }
>
> protected void OnTimer(Object source, ElapsedEventArgs e)
> {
> string strQuery = string.Empty;
> string strUserName =
> ConfigurationSettings.AppSettings["username"].Trim().ToString();
>
> if(strUserName.Length > 0)
> strQuery = "select p.postid from
> posts p,forums f,users u where postdate = (select max(postdate) from
> posts) and p.forumid = f.forumid and f.forumgroupid = u.role and
> u.username = '" + strUserName + "' and postlevel =1";
> else
> //strQuery = "select p.postid from
> posts p,forums f,users u where postdate = (select max(postdate) from
> posts) and p.forumid = f.forumid and f.forumgroupid = u.role and
> and postlevel =1";
> strQuery = "select count(*) from
> posts";
>
> string strCon =
> ConfigurationSettings.AppSettings["DatabasePath"].ToString();
> SqlConnection con = new SqlConnection
> (@strCon);
>
> SqlCommand cmd = new SqlCommand(strQuery,con);
> try
> {
>
> con.Open();
> cnt = Convert.ToInt32
> (cmd.ExecuteScalar());
>
> if(initalCnt != cnt && cnt != 0)
> {
>
> string arg =
> ConfigurationSettings.AppSettings["url"].ToString()+ "/AddPost.aspx?
> PostID=" + Convert.ToString(cmd.ExecuteScalar());
>
> System.Diagnostics.Process.Start
> (@ConfigurationSettings.AppSettings["TrayExe"].ToString(),arg);
>
> initalCnt = cnt;
> }
>
> }
> catch(Exception ex)
> {
> this.LogEvent(ex.Message);
> }
> finally
> {
> con.Close();
> }
>
> }
>
>
>
>
>
>
>
> Thanks in Advance
> Avinash
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
--
Dean Fiala
Very Practical Software, Inc
http://www.vpsw.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
