怎么用OLEDB连接ACCESS

Question

最好写下代码  谢谢

Answer 1

OleDbConnection conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source="+Server.MapPath("XXX.mdb")); OleDbDataAdapter mydata=new OleDbDataAdapter(_sql,conn); conn.Open()DataSet ds=new DataSet(); 
mydata.Fill(ds,); 其他的和mssql查不多的吧

Answer 2

private OleDbConnection GetOleDbConnection()
{
    string connStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = " + mdbFilename + "; User ID = Admin; Jet OLEDB:Database Password = tcgl200412; Persist Security Info=True; Mode = ReadWrite;";    OleDbConnection oleDbConn = null;
    try
    {
        oleDbConn = new OleDbConnection(connStr);
        oleDbConn.Open();
        return oleDbConn;
    }
    catch (Exception err)
    {
        MessageBox.Show("连接数据库失败: " + err.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
        return null;
    }
}

Answer 3

http://www.fwvv.net/info/2007/06/04/20070604-36809.shtml

Answer 4

mdbFilename是mdb文件带路径名称，如：@"c:\temp\sjk.mdb"

Answer 5

加上相应的命名空间　using System.Data.OleDb;button1的Click事件如下：
　　
        private void button1_Click(object sender, EventArgs e)
        {
            string filepath = "E:\\test.mdb";　
            string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filepath;
            OleDbConnection conn = new OleDbConnection(connectionString);
            OleDbDataAdapter da = new OleDbDataAdapter("Select * from 表", conn);
            DataTable dt = new DataTable();
            da.Fill(dt);
            dataGridView1.DataSource = dt.DefaultView;
        }

Answer 6

帮你的了个例子:
      http://blog.csdn.net/jingang123gz/archive/2007/11/02/1862562.aspx

Answer 7

            string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=数据库.mdb;Persist Security Info=True;password='密码'";
            OleDbConnection con = new OleDbConnection(strCon);            con.Open();
            string strSql = "Select * From 表名";
            OleDbCommand command = new OleDbCommand(strSql, con);
            OleDbDataAdapter dap = new OleDbDataAdapter(command);
            DataSet ds = new DataSet();
            dap.Fill(ds);
            con.Close();

Answer 8

office2007的连接
string reportPath = Application.StartupPath.Substring(0, 
                Application.StartupPath.Substring(0, 
                Application.StartupPath.LastIndexOf("\\")).LastIndexOf("\\"));
            reportPath += @"\te.accdb";
           
            string Constr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + reportPath;
            try
            {
                //建立连接
                OleDbConnection con = new OleDbConnection(Constr);
                con.Open();
                if (con.State == ConnectionState.Open)
                {
                    MessageBox.Show("连接成功");
                }
                else
                {
                    MessageBox.Show("失败");
                }
                //读取数据
                OleDbCommand cmd = new OleDbCommand("select * from mytable", con);
                OleDbDataReader drnew = cmd.ExecuteReader();
            
                if(drnew.HasRows)
                {
                    while (drnew.Read())
                    {
                        listView1.Items[0].SubItems.Add(drnew[0].ToString());
                        listView1.Items[1].SubItems.Add(drnew[1].ToString());
                        listView1.Items[2].SubItems.Add(drnew[2].ToString());
                    }
                }
                drnew.Close();
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(ex.Message);   
            }

Answer 9

string strPath = Application.StartupPath + "\db_09.mdb";
            string ConStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source='" + strPath + "'";
            OleDbConnection oleCon = new OleDbConnection(ConStr);
            OleDbDataAdapter oleDap = new OleDbDataAdapter("select * from 帐目", oleCon);
            DataSet ds=new DataSet();
            oleDap.Fill(ds, "帐目");
            this.dataGridView1.DataSource = ds.Tables[0].DefaultView;
            oleCon.Close();
            oleCon.Dispose();

Answer 10

webconfig中配置 <appSettings>
<add key="strCon" value="provider=microsoft.jet.oledb.4.0;data source="/>
<add key="dbPath" value="~/App_Data/Site.mdb"/>
</appSettings>程序获取string _connectionString = System.Configuration.ConfigurationManager.AppSettings["strCon"] + HttpContext.Current.Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["dbPath"]) + ";";