首页 > Windows开发 > 详细

C# timer使用

时间:2019-11-01 09:46:12      阅读:84      评论:0      收藏:0      [点我收藏+]

static System.Timers.Timer timer1 = new System.Timers.Timer();
static void Main(string[] args)
{
System.Timers.Timer timer1 = new System.Timers.Timer();
timer1.Interval = 10000; //设置计时器事件间隔执行时间
timer1.Enabled = true;//计时器是否执行
timer1.AutoReset =true;//计时器是否重复
timer1.Elapsed += new System.Timers.ElapsedEventHandler(timer1_Elapsed);//为计时器添加行为

}

private static void timer1_Elapsed(object sender, System.Timers.ElapsedEventArgs e)

{
Console.WriteLine(DateTime.Now);

if (DateTime.Now.Hour == 16 && DateTime.Now.Minute == 27)
{
//执行SQL语句或其他操作
try
{

SqlConnection con = new SqlConnection();
con.ConnectionString = "server=PC-20151122FDGB;database=school;uid=sa;pwd=";
con.Open();
SqlCommand com = new SqlCommand();
com.Connection = con;
com.CommandType = CommandType.Text;
com.CommandText = "select * from score";
SqlDataReader reader = com.ExecuteReader();//执行SQL,返回一个“流”
DataTable dt = new DataTable();
dt = ConvertDataReaderToDataTable(reader);

con.Close();//关闭数据库
}
catch (Exception ex)
{
using (System.IO.StreamWriter sw = new System.IO.StreamWriter("D:\\log.txt", true))
{
sw.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " 上传异常:" + ex.Message);
sw.Close();
return;
}
}


}
}
public static DataTable ConvertDataReaderToDataTable(SqlDataReader reader)
{
try
{
DataTable objDataTable = new DataTable();
int intFieldCount = reader.FieldCount;
for (int intCounter = 0; intCounter < intFieldCount; ++intCounter)
{
objDataTable.Columns.Add(reader.GetName(intCounter), reader.GetFieldType(intCounter));
}
objDataTable.BeginLoadData();

object[] objValues = new object[intFieldCount];
while (reader.Read())
{
reader.GetValues(objValues);
objDataTable.LoadDataRow(objValues, true);
}
reader.Close();
objDataTable.EndLoadData();

return objDataTable;

}
catch (Exception ex)
{
throw new Exception("转换出错!", ex);
}

}

C# timer使用

原文:https://www.cnblogs.com/lianxiaojie/p/11775027.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!