c#²éѯaccessÊý¾Ý¿â´úÂë

ÇëÎÊÔõÑùÔÚc#ÏîÄ¿ÖвéѯaccessÊý¾Ý¿âÖеÄÊý¾Ý£¬´úÂëÊÇÔõÑù°¡£¿£¿Çë¸ßÊÖÖ¸µã

---

oledbconnection

---

ͬ¥ÉÏ

---

²Î¿¼ÒÔÏ´úÂë,¿´ÄÜ·ñ½â¾öµ½ÄãµÄÎÊÌâ

string strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=MapPath("Êý¾Ý¿â.mdb");//ÕâÀïÊÇÏà¶Ô·¾¶

OleDbConnection objConnection=new OleDbConnection(strConnection);
objConnection.open();

string  strSQL="SELECT  *  from  Table";
OleDbCommand Comm = new OleDbCommand(strSQL, objConnection);

OleDbDataReader adr = Comm.ExecuteReader();

  while(adr.Read())
  {
             
    ±äÁ¿ = adr["×Ö¶ÎÃû"].ToString();
    ±äÁ¿ = adr["×Ö¶ÎÃû"].ToString();
               
  }

objConnection.close();

---

<add name="xkConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\XKArticle.mdb" providerName="System.Data.OleDb"/>

---

ÓÃaccess²Ù×÷Àà
public static string connectionString = ""£»
public static OleDbDataReader ExecuteReader(string strSQL)   
        {   
            OleDbConnecti