C# 连接access并存至datatable中

来源:互联网 发布:广电网络客服电话绵阳 编辑:程序博客网 时间:2024/05/16 07:10

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:/test/db1.mdb");
conn.Open();

string sql = "SELECT * from yourTable";
OleDbDataAdapter adp
= new OleDbDataAdapter(sql, conn);

DataTable dtEmployee
= new DataTable();
adp.Fill(dtEmployee);


原创粉丝点击