// 插入数据
private void btnInsert_Click(object sender, EventArgs e)
{
int count=0;
Thread td = new Thread(new ThreadStart(()=> {
string connectionString = @"Data Source=F:\kvs-3.db;Version=3;";
SQLiteConnection conn = new SQLiteConnection(connectionString);
conn.Open();
string sqlSQLite = "insert into FoodBumped values('TERRYSURFACEPRO', 'NT3', '0', '-1', '2018-06-27', '21:37:52')";
SQLiteCommand cmd = new SQLiteCommand(sqlSQLite, conn);
for (int i = 0; i < 10000; i++)
{
count += cmd.ExecuteNonQuery();
// 委托类型
Invoke(new Action(() =>
{
lblCount.Text = Convert.ToString(count);
}));
}
}));
td.Start();
}
// 关闭窗体时发生
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
Application.ExitThread();// 强制中止调用线程上的所有消息,同样面临其它线程无法正确退出的问题;
Environment.Exit(0); //这是最彻底的退出方式,不管什么线程都被强制退出,把程序结束的很干净
}
private void btnInsert_Click(object sender, EventArgs e)
{
int count=0;
Thread td = new Thread(new ThreadStart(()=> {
string connectionString = @"Data Source=F:\kvs-3.db;Version=3;";
SQLiteConnection conn = new SQLiteConnection(connectionString);
conn.Open();
string sqlSQLite = "insert into FoodBumped values('TERRYSURFACEPRO', 'NT3', '0', '-1', '2018-06-27', '21:37:52')";
SQLiteCommand cmd = new SQLiteCommand(sqlSQLite, conn);
for (int i = 0; i < 10000; i++)
{
count += cmd.ExecuteNonQuery();
// 委托类型
Invoke(new Action(() =>
{
lblCount.Text = Convert.ToString(count);
}));
}
}));
td.Start();
}
// 关闭窗体时发生
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
Application.ExitThread();// 强制中止调用线程上的所有消息,同样面临其它线程无法正确退出的问题;
Environment.Exit(0); //这是最彻底的退出方式,不管什么线程都被强制退出,把程序结束的很干净
}