求.net连接access（C#）如何连接？

[jhdxhj]

求.net连接access（C#）如何连接？哪个提供个例子看看啊

[liujiayu10]

web.config 里面 :
<connectionStrings>
<add name="myConn" connectionString="~/Data/DB.mdb"/>
</connectionStrings>

        public static OleDbConnection GetConn()
        {
            OleDbConnection Conn;
            string myConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["myConn"].ConnectionString);
            string ConnString = myConnectionString;
            Conn = new OleDbConnection(ConnString);
            return Conn;
        }

[fzh5810]

首先，使用命名空间：using System.Data.Odbc;
其次，添加代码：
OdbcConnection thisConnection = new OdbcConnection(@"PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=d:\db1.mdb;");
thisConnection.Open();

连接其他数据库也是类似。
下面是我学习的时候，用来连接公司Firebird数据库的一段代码,是在控制台环境下运行的，呵呵，你可以模仿一下
OdbcConnection thisConnection = new OdbcConnection(@"DRIVER=Firebird/InterBase(r) driver;UID=sysdba; PWD=MASTERKEY;CLIENT=d:\soft\\Firebird\bin\fbclient.dll;DBNAME=d:\ssDB.FDB;");
thisConnection.Open();
OdbcCommand thisCommand = thisConnection.CreateCommand();
thisCommand.CommandText="SELECT * FROM \"chChild\"";
OdbcDataReader thisReader = thisCommand.ExecuteReader();
while (thisReader.Read())
{
Console.WriteLine("\t{0}\t{1}",
thisReader["FChildNo"],thisReader["FBirthDay"]);
}


thisReader.Close();
thisConnection.Close();
Console.Write("============end==========");
Console.ReadLine();

[lq89603243]

//String connectionString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";
//connectionString += @"d:\jinXiaoCun.mdb";
//OleDbConnection myConnection = new OleDbConnection(connectionString);

//myConnection.Open(); //打开数据库链接
//OleDbDataAdapter objAdap = new OleDbDataAdapter("SELECT * FROM f_jinhuodan", myConnection);

//DataSet objDSet = new DataSet();
//objAdap.Fill(objDSet, "f_jinhuodan");
//dataGridView1.DataSource = objDSet.Tables[0].DefaultView;

[wlpsgh]

学习

[douyitong]

查询 OleDbConnection类
就用这个类就行
另外还要用到datareader或者OleDbDataAdapter
找本c#的书来看，基础一点的
基本上所有的书都会涉及到跟数据库的连接

[suners]

网搜

[止戈而立]

OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\yourdb.mdb");
            conn.Open();

[johncccheung]

web.config 里面
<add name="ptsgeDBconnstr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\ptsge\DB\ptsgeDB.mdb;User Id=admin;Password=;" providerName="System.Data.OleDb"/>

string myallconn = (System.Configuration.ConfigurationManager.ConnectionStrings["ptsgeDBconnstr"]).ToString();//取得字符串
之后就做你应该做的啦

[jhdxhj]

string strCon = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + sPath + ";Extended Properties='Excel 12.0 Xml;HDR=NO;IMEX=1'";