阅读文件的访问到数据集 [英] Read Access File into a DataSet

问题描述

有没有一种简单的方法来读取整个访问文件（.mdb）转换成在.NET中（特别是C＃或VB）？一个数据集

Is there an easy way to read an entire Access file (.mdb) into a DataSet in .NET (specifically C# or VB)?

或者至少拿到表的列表从访问文件，这样我可以遍历它，并将其添加一次到DataSet？

Or at least to get a list of tables from an access file so that I can loop through it and add them one at a time into a DataSet?

推荐答案

感谢您的建议。我能够利用这些样本放在一起这个code，这似乎达到我在寻找什么。

Thanks for the suggestions. I was able to use those samples to put together this code, which seems to achieve what I'm looking for.

Using cn = New OleDbConnection(connectionstring)
    cn.Open()
    Dim ds As DataSet = new DataSet()

    Dim Schema As DataTable = cn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
    For i As Integer = 0 To Schema.Rows.Count - 1
    	Dim dt As DataTable = New DataTable(Schema.Rows(i)!TABLE_NAME.ToString())

    	Using adapter = New OleDbDataAdapter("SELECT * FROM " + Schema.Rows(i)!TABLE_NAME.ToString(), cn)
    		adapter.Fill(dt)
    	End Using

    	ds.Tables.Add(dt)
    Next i
End Using

这篇关于阅读文件的访问到数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！