我想打开一个OleDbConnection阅读在Access数据库中的表街道列名。我叫于GetOleDbSchemaTable,但我似乎无法弄清楚如何让我的列。
我想使用.NET 3.5框架,如果可能的话。
解决方案 使用(OleDbConnection的连接=新的OleDbConnection(的connectionString))
{
connection.Open();
数据表TableColumn来= connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns将,新的对象[] {NULL,NULL,街道,空}));
的foreach(DataRow的行tableColumns.Rows)
{
VAR columnNameColumn =行[栏];
VAR dateTypeColumn =行[DATA_TYPE];
VAR ordinalPositionColumn =行[ORDINAL_POSITION];
...
}
}
I'm trying to read the column names of a table "Streets" in an Access database by opening an OleDbConnection. I call GetOleDbSchemaTable but I can't seem to figure out how to get at my columns.
I'd like to use .NET 3.5 framework if possible.
解决方案using (OleDbConnection connection = new OleDbConnection(connectionString))
{
connection.Open();
DataTable tableColumns = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, new object[] { null, null, "Streets", null }));
foreach (DataRow row in tableColumns.Rows)
{
var columnNameColumn = row["COLUMN_NAME"];
var dateTypeColumn = row["DATA_TYPE"];
var ordinalPositionColumn = row["ORDINAL_POSITION"];
...
}
}