欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

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

程序员文章站 2022-05-20 22:37:16
...

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

       
       /// 
       /// 取所有表名
       /// 
       /// 
       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())
               {
                   cmd.CommandText = "SELECT TOP 1 * FROM [" + TableName + "]";
                   cmd.Connection = Conn;
                   OleDbDataReader dr = cmd.ExecuteReader();
                   for (int i = 0; i