我现在是这样干的: //清空账目
private void button13_MouseClick(object sender, MouseEventArgs e)
{
if (MessageBox.Show("你确认要清空所有收入和支出账目吗?", "确认清空?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
String sql = "delete from sr_data"; //表1
String sql2 = "delete from zc_data";//表2
con.Open();
cmd.CommandText = sql;
cmd.Connection = con;
cmd.ExecuteNonQuery();
cmd.CommandText = sq2;
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("账目清空完毕,请重新启动程序");
}
}
有其他更好的办法没?
private void button13_MouseClick(object sender, MouseEventArgs e)
{
if (MessageBox.Show("你确认要清空所有收入和支出账目吗?", "确认清空?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
String sql = "delete from sr_data"; //表1
String sql2 = "delete from zc_data";//表2
con.Open();
cmd.CommandText = sql;
cmd.Connection = con;
cmd.ExecuteNonQuery();
cmd.CommandText = sq2;
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("账目清空完毕,请重新启动程序");
}
}
有其他更好的办法没?
String sql = "truncate table sr_data; truncate table zc_data"; con.Open();
cmd.CommandText = sql;
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
用一楼的方法写sql string