将access数据读取填充到datatable中

别cpu我

于 2021-10-13 12:06:23 发布

阅读量505

点赞数

文章标签： c# 数据库 access

本文链接：https://blog.youkuaiyun.com/qq_45031599/article/details/120741250

版权

读取access数据库（2007），将数据通过 OleDbDataAdapter类填充到datatable中

    string path = 数据库路径;
        string strConnect = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + "\\数据库名.accdb";
        OleDbConnection conn = new OleDbConnection(strConnect);
        OleDbCommand cmd = new OleDbCommand("select * from 表名", conn);
        conn.Open();                    
        OleDbDataAdapter da = new OleDbDataAdapter(cmd);
        OleDbCommandBuilder cb = new OleDbCommandBuilder(da);
        cb.QuotePrefix = "[";
        cb.QuoteSuffix = "]";
        DataSet ds = new DataSet();
        da.Fill(ds, "table名");
        Console.WriteLine(da.ToString());
        DataTable dt = ds.Tables["table名"];
        conn.Close();