VB.Net 如何获取Access数据库中的表名称
最新回答
因为太帅被罚块
2026-01-05 14:38:27
/// <summary>
/// 获得当前Access数据库的表
/// </summary>
/// <param name="Source"></param>
/// <returns></returns>
public ArrayList DataScoreTableName(string Source)
{
ArrayList TableName = new ArrayList();
string ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Source;
OleDbConnection conn = new OleDbConnection(ConnectionString);
conn.Open();
DataTable schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] { null, null, null, "TABLE"});
foreach (DataRow dr in schemaTable.Rows)
{
TableName.Add(dr["TABLE_NAME"]);
}
conn.Close();
return TableName;
}
热门标签
