c# 获取access所有表名 获取指定表所有字段名

数据库|mysql教程

获取,access,所,表名,指定,字段,summary,

数据库-mysql教程

安信直销源码,vscode怎么更改字,ubuntu下载木兰,修改tomcat调试端口,magic爬虫,php 数组 练习,吉林seo网络推广优化,网站菜单教程,信息手机网站模板下载软件lzw

/// summary /// 取 所有 表名 /// /summary /// returns/returns public Liststring GetTableNameList() { Liststring list = new Liststring(); OleDbConnection Conn = new OleDbConnection(ConnStr); try { if (Conn.State == ConnectionState.Closed) C

网页游戏私聊器源码,如何格式化vscode,ubuntu图形命令,tomcat信息 怎么关掉,爬虫接活儿,php 函数调用数据,云浮seo标题修改要点,高端响应式网站模版,试玩模板源码lzw

94的源码,vscode查看项目名,如何精减ubuntu,tomcat打印日志级别,爬虫活动,php 远程页面,seo免费工具排名,开源代码的网站,wordpress企业中文模板lzw

/// /// public List GetTableNameList() { List list = new List(); OleDbConnection Conn = new OleDbConnection(ConnStr); try {if (Conn.State == ConnectionState.Closed) Conn.Open();DataTable dt = Conn.GetSchema("Tables");foreach (DataRow row in dt.Rows){ if (row[3].ToString() == "TABLE") list.Add(row[2].ToString());}return list; } catch (Exception e) { throw e; } finally { if (Conn.State == ConnectionState.Open) Conn.Close(); Conn.Dispose(); } } /// /// public List GetTableFieldNameList(string TableName) { List list = new List(); OleDbConnection Conn = new OleDbConnection(ConnStr); try {if (Conn.State == ConnectionState.Closed) Conn.Open();using (OleDbCommand cmd = new OleDbCommand()){ mandText = "SELECT TOP 1 * FROM [" + TableName + "]"; cmd.Connection = Conn; OleDbDataReader dr = cmd.ExecuteReader(); for (int i = 0; i < dr.FieldCount; i++) { list.Add(dr.GetName(i)); }}return list; } catch (Exception e) { throw e; } finally {if (Conn.State == ConnectionState.Open) Conn.Close();Conn.Dispose(); } }