这是我写的windows服务程序,怎么数据库中没有结果啊 ?using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.ServiceProcess;
using System.Text;
using System.Net;//需要引用.Net命名空间
using System.Data.SqlClient; // Use SQL Server data provider namespace
using System.Timers;
using System.Threading;namespace Service
{
public partial class Service1 : ServiceBase
{ SqlConnection con;
SqlDataAdapter da;
SqlCommandBuilder thisBuilder;
DataSet ds;
public Service1()
{
InitializeComponent();
} protected override void OnStart(string[] args)
{
// TODO: 在此处添加代码以启动服务。
Thread.Sleep(10000);
this.timer.Enabled = true;
} protected override void OnStop()
{
// TODO: 在此处添加代码以执行停止服务所需的关闭操作。
this.timer.Enabled = false;
} private void timer_Tick(object sender, EventArgs e)
{
try
{
this.con = new SqlConnection(
@"Server=***;Integrated Security=True;
Database=mybase");
this.con.Open();
}
catch (Exception err)
{
throw new ApplicationException("连接数据库出错,系统信息:" + err.Message);
} this.da = new SqlDataAdapter("SELECT * FROM student ", this.con);
this.thisBuilder = new SqlCommandBuilder(da);
this.ds = new DataSet();
this.da.Fill(ds, "student");
//获得主机名
string HostName = Dns.GetHostName();
/* foreach (DataRow dr in dataset.Tables["student"].Rows)
{
if (Convert.ToString(dr["Sno"]) == "11")
{
dr["Sname"] = HostName;
return;
} da.Update(dataset,"student");
con.Close(); }*/
DataRow dr = this.ds.Tables["student"].NewRow();
dr["Sno"] = 100;
dr["Sname"] = HostName;
dr["Sage"] = 20;
this.ds.Tables["student"].Rows.Add(dr);
this.da.Update(ds, "student");
this.con.Close();
}
}
}
加了timer控件,每个30秒运行
怎么数据库中的不到想要的结果呢?
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.ServiceProcess;
using System.Text;
using System.Net;//需要引用.Net命名空间
using System.Data.SqlClient; // Use SQL Server data provider namespace
using System.Timers;
using System.Threading;namespace Service
{
public partial class Service1 : ServiceBase
{ SqlConnection con;
SqlDataAdapter da;
SqlCommandBuilder thisBuilder;
DataSet ds;
public Service1()
{
InitializeComponent();
} protected override void OnStart(string[] args)
{
// TODO: 在此处添加代码以启动服务。
Thread.Sleep(10000);
this.timer.Enabled = true;
} protected override void OnStop()
{
// TODO: 在此处添加代码以执行停止服务所需的关闭操作。
this.timer.Enabled = false;
} private void timer_Tick(object sender, EventArgs e)
{
try
{
this.con = new SqlConnection(
@"Server=***;Integrated Security=True;
Database=mybase");
this.con.Open();
}
catch (Exception err)
{
throw new ApplicationException("连接数据库出错,系统信息:" + err.Message);
} this.da = new SqlDataAdapter("SELECT * FROM student ", this.con);
this.thisBuilder = new SqlCommandBuilder(da);
this.ds = new DataSet();
this.da.Fill(ds, "student");
//获得主机名
string HostName = Dns.GetHostName();
/* foreach (DataRow dr in dataset.Tables["student"].Rows)
{
if (Convert.ToString(dr["Sno"]) == "11")
{
dr["Sname"] = HostName;
return;
} da.Update(dataset,"student");
con.Close(); }*/
DataRow dr = this.ds.Tables["student"].NewRow();
dr["Sno"] = 100;
dr["Sname"] = HostName;
dr["Sage"] = 20;
this.ds.Tables["student"].Rows.Add(dr);
this.da.Update(ds, "student");
this.con.Close();
}
}
}
加了timer控件,每个30秒运行
怎么数据库中的不到想要的结果呢?
{
InitializeComponent();
} protected override void OnStart(string[] args)
{
logger = log4net.LogManager.GetLogger("logAll"); timerExecuter = new System.Timers.Timer(); timerExecuter.Enabled = true; timerExecuter.Interval =Properties.Settings.Default.Interval * 60000 ; // setting number is minutes timerExecuter.Elapsed += new System.Timers.ElapsedEventHandler(timerExecuter_Elapsed); logger.Info("service start.");
//logger.Info("first upload.");
//BeginUpload();
} void timerExecuter_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
{
//check start time.
DateTime time = Properties.Settings.Default.StartTime; if (DateTime.Now.CompareTo(time) > 0)
{
Properties.Settings.Default.StartTime = Properties.Settings.Default.StartTime.AddDays(1);
logger.Info("begin to upload" + DateTime.Now.ToString());
}
else
{
logger.Info("time is not arrive :" + time.ToString());
return;
}
BeginUpload();
}
Timer控件改为我写的那样。
邮箱:[email protected]
QQ:250110961 谢谢!
邮箱:[email protected]
QQ:250110961 谢谢!收到邮件测试正常后,我会在这个两个上给散发:60 分 谢谢大家支持!
http://topic.csdn.net/u/20110830/10/45fb0123-9717-4e24-b1fd-41dc5ee8d1d0.html?seed=680969590&r=75234806#r_75234806
http://topic.csdn.net/u/20110830/11/b77db9ba-fcaa-449c-809f-720d5d139750.html