access c# update ¼òµ¥´íÎó Çë½Ì¡£

accessÊý¾Ý¿â c# vs2008

  protected void tongji1(object sender, EventArgs e)
  {
  string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\\dbps.mdb";
  string str = "UPDATE table1 SET number =number + 1 where id = 1 ";
  OleDbConnection conn = new OleDbConnection(constr);

  conn.Open();
  OleDbCommand com = new OleDbCommand(str, conn);
  com.ExecuteNonQuery(); ÕâÀïÌáʾupdateÓï¾ä³ö´í

  ...................

ÇëÎʸÃÔõô¸Ã лл


{{