[我的ASP.net学习历程]数据库操作之(二)

  private void Page_Load(object sender, System.EventArgs e)
  {
   string dbPath = @"Data\dbTest.mdb";
   string db = Server.MapPath(dbPath);
   string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + db;
   //string strSQL = "SELECT * FROM Customers";
   //string strSQL = "INSERT INTO Customers(CustomerID) VALUES ('QQQQQ')";
   //string strSQL = @"UPDATE Customers SET CustomerID='PPPPP',Address='64651546' WHERE id=11";
   //string strSQL = @"DELETE FROM Customers WHERE id = 11";

   OleDbConnection conn = new OleDbConnection(connectionString);
   OleDbCommand cmd = new OleDbCommand(strSQL,conn);

   cmd.Connection.Open();
   cmd.ExecuteReader();
   conn.Close();

  }

本文地址：http://com.8s8s.com/it/it8573.htm