C#链接ACCESS数据库

最近写了一个小程序，用到了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();