Question

用c#操作数据库的删除代码怎么写？

Answer 1

//更新函数
public bool updatadb(string tostrsql)
{
/// <summary>
/// 更新函数
/// 直接执行删除SQL
/// </summary>
linkdb();
strsql = tostrsql;
OleDbCommand cm = new OleDbCommand();
cm.Connection = conn;
cm.CommandText = strsql;
cm.CommandTimeout = 10;
conn.Open();
cm.ExecuteNonQuery();
conn.Close();
return true;
}

Answer 2

string sqlstr=configurationmanager.connectionstrings["aaa"].connectionstring;
sqlconnection conn =new sqlconnection(sqlstr);
conn.open();
string del="delete from 表where条件";
Sqlcommand cmd=new Sqlcommand(del,conn);
cmd.ExecuteNonquery();
conn.close();