读取access表的结构

怎么读取access中某表的结构(名称,类型,长度)?

---

http://blog.csdn.net/ACMAIN_CHM/archive/2008/12/24/3598577.aspx
获取ACCESS表结构

---

....这个我看过了,因为是VB写的没看明白

---

C#

---

有没有直接读取表结构的SQL语句?

---

我知道了,你是先把access表读到内存表中,然后再读结构

---

先读出在ini文件中，做为临时文件，比读在内存中好！！！he!he!he!

---

参考一下MSDN 中 connection.GetOleDbSchemaTable 方法的说明
C# code:
static void Main(string[] args)
{
string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\liuyann\Desktop\temp\access\xx.mdb;User Id=admin;Password=;";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
DataTable schemaTable = connection.GetOleDbSchemaTable(
OleDbSchemaGuid.Columns,
new object[] { null, null, null, null });

foreach (DataRow row in schemaTable.Rows)
{
Console.WriteLine("{0} - {1} - {2} - {3}", row[0], row[1], row[2], row[3]);
}
}
Console.Read();
}