######################小问题!帮忙看一下!!!!!谢谢啦!!在线等!!
string serchstr="";
if (dateTimePicker2.Enabled == false)
{
serchstr = "delete from 聊天 where sj>='" + dateTimePicker1.Value.ToShortDateString() + "'";
}
else
{
serchstr ="delete from 聊天 where sj>='"+dateTimePicker1.Value.ToShortDateString()+"' and sj<='"+dateTimePicker2.Value.ToShortDateString()+"'";
}
SqlConnection sql = new SqlConnection(Form1.str);
SqlCommand sqlc = new SqlCommand();
sqlc.Connection = sql;
sqlc.CommandText = serchstr;
sql.Open();
sqlc.ExecuteNonQuery();
//////////////////////////////////////////////////////////
string serchstr1 = "";
if (dateTimePicker2.Enabled == false)
{
serchstr1 = "delete from 聊天1 where sj>='" + dateTimePicker1.Value.ToShortDateString() + "'";
}
else
{
serchstr1 = "delete from 聊天1 where sj>='" + dateTimePicker1.Value.ToShortDateString() + "' and sj<='" + dateTimePicker2.Value.ToShortDateString() + "'";
}
sqlc.CommandText = serchstr1;
int i = sqlc.ExecuteNonQuery();
if (i == 1)
{
MessageBox.Show("删除成功!");
}
else
{
MessageBox.Show("删除失败!");
}
以上是我想删除两个表(聊天,聊天1)两个表里的内容,根据dateTimePicker1控件里的值去删除具体内容!为什么删除不了啊!