string strSQL="update 表 set 列名=''";
OleDbConnection objConnection=new OleDbConnection(strConnect);
OleDbCommand objCommand=new OleDbCommand(strSQL,objConnection);
int intRowsAffected;
intRowsAffected=objCommand.ExecuteNonQuery();
OleDbConnection objConnection=new OleDbConnection(strConnect);
OleDbCommand objCommand=new OleDbCommand(strSQL,objConnection);
int intRowsAffected;
intRowsAffected=objCommand.ExecuteNonQuery();
把上面的Sql语句传给下面的方法。
public static bool InsertGMonitorLog(string strSql)
{
bool blnRst = false;
SqlConnection myConn = new SqlConnection(strConn);
SqlCommand myComm = new SqlCommand(strSql,myConn);
try
{
myConn.Open();
myComm.ExecuteNonQuery();
blnRst = true;
}
catch(SqlException e)
{
e.ToString();
}
finally
{
myConn.Close();
}
return blnRst;
}