最近写了一个小程序,用到了ACCESS数据库,记录下数据库的链接方法。 1、Winform 中链接ACCESS //需要引用一下两个命名空间 using System.Data.OleDb; using System.IO; string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Directory.GetCurrentDirectory()+(@"/zhenjiangDBA.mdb");//用于指定数据库文件与.exe文件在同一目录下 OleDbConnection objConnection = new OleDbConnection(strConnection); OleDbCommand objCommand = new OleDbCommand(); objConnection.Open(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { objCommand = new OleDbCommand("SELECT * FROM Content", objConnection); } else { objCommand = new OleDbCommand("SELECT * FROM Content WHERE 商品名称 like '%" + txtName.Text.Trim() + "%'", objConnection); } OleDbDataReader objDr = objCommand.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(objDr); objDr.Close(); objConnection.Close(); grdPrice.DataSource = dt; 2、asp.net中链接ACCESS //需要引用以下命名空间 using System.Data.OleDb; ///以下为链接内容 string strConnection = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + MapPath("~/App_Data/zhenjiangDBA.mdb");//在ASP.net中是用MapPath定位到数据库的位置 OleDbConnection objConnection = new OleDbConnection(strConnection); OleDbCommand objCommand = new OleDbCommand(); objConnection.Open(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { objCommand = new OleDbCommand("SELECT * FROM Content", objConnection); } else { objCommand = new OleDbCommand("SELECT * FROM Content WHERE 商品名称 like '%" + txtName.Text.Trim() + "%'", objConnection); } OleDbDataReader objDr = objCommand.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(objDr); objDr.Close(); objConnection.Close(); ViewState["DataSource"] = dt; grdPrice.DataSource = dt; grdPrice.DataBind();