CSDN博客

img bgu

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

发表于2004/9/21 20:17:00  1329人阅读

  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();

  }

0 0

相关博文

我的热门文章

img
取 消
img