.net与access数据库

web.config:

<appSettings>
  <add key="ACCESSCONNECTIONSTRING" value="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="></add>
 </appSettings>

aspx.cs：

private readonly string ACCESSCONNECTIONSTRING = ConfigurationSettings.AppSettings["ACCESSCONNECTIONSTRING"].ToString();

查找

private void ShowDBData()
  {
   string accessString = ACCESSCONNECTIONSTRING + Server.MapPath("MyFirstAccessDB.mdb");
   string cmdText = "SELECT * FROM MyDataTable";
   OleDbConnection accessConn = new OleDbConnection(accessString);
   OleDbCommand accessComm = new OleDbCommand(cmdText,accessConn);

   string dataString = "<br>MyID  MyName  MyType  My Length<br>";

   try
   {
    ///打开OLEDB数据库的链接
    accessConn.Open();
    Response.Write("连接MyFirstAccessDB数据源成功！！！");

    //显示数据库中的信息
    OleDbDataReader reca = accessComm.ExecuteReader();

    while(reca.Read())
    {
     dataString += reca["MyID"].ToString() +" " + reca["MyName"].ToString()
      +" " + reca["MyType"].ToString() +" " + reca["MyLength"].ToString();
     dataString += "<br>";
    }
    reca.Close();
   
    ///显示数据库中的内容
    Response.Write(dataString);    

    ///关闭OLEDB数据库的链接
    accessConn.Close();
    Response.Write("<br><br>OLEDB数据库连接的关闭状态：" + accessConn.State.ToString());    
   }
   catch(Exception ex)
   {
    //抛出数据库连接异常
    Response.Write(ex.Message);
   }   

  } 

 

更新：

private void UpdataDBData(String myID,String myName)
  {   
   string accessString = ACCESSCONNECTIONSTRING + Server.MapPath("MyFirstAccessDB.mdb");
   string cmdText = "UPDATE MyDataTable SET MyName='" + myName + "' WHERE MyID=" + myID;
   OleDbConnection accessConn = new OleDbConnection(accessString);
   OleDbCommand accessComm = new OleDbCommand(cmdText,accessConn);

   try
   {
    ///打开OLEDB数据库的链接
    accessConn.Open();

    ///执行更新数据操作
    accessComm.ExecuteNonQuery();

    ///关闭OLEDB数据库的链接
    accessConn.Close();    
   }
   catch(Exception ex)
   {
    //抛出数据库连接异常
    Response.Write(ex.Message);
   }

  }