使用定时器往数据库中写数据
下面的程序是每一秒往数据库中添加一条当前时间的记录
public partial class Form1 : Form
{
private const string CONNSTRING = @"Data Source=.\SQLEXPRESS;AttachDBFilename =|DataDirectory|\Datetime1.mdf;Integrated Security=True;User Instance=True";
public Form1()
{
InitializeComponent();
timer1.Start();
}
private void timer1_Tick(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(CONNSTRING);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Insert into datetime1(DT) values(@DT)";
cmd.Parameters.AddWithValue("DT", DateTime.Now);
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Dispose();
}
}
报错