请问怎样在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
