---

使用adox 加载数据结构

---

使用adox 加载数据结构

 

 

        ADOX.Catalog dd = new ADOX.Catalog();
       
        ADODB.Connection conn = new ADODB.Connection();
        string ConnectionString = "Provider=SQLOLEDB.1; Initial Catalog=BSystem;Data Source=.;";
        ConnectionString = "Provider=SQLNCLI;Server=.;Database=BSystem;Uid=BSystem;Pwd=BSystem;";
     
        conn.Open(ConnectionString, "BSystem", "BSystem", -1);
      
        //dd.ActiveConnection=conn;

        dd.let_ActiveConnection(conn);
        
      
        foreach (ADOX.Column t in dd.Tables["admin"].Columns)
        {
            echo(t.Name + "n");
            echo(t.DefinedSize + "n");
            echo(t.Type + "n");
            echo(t.Attributes + "n");

        

            foreach(ADOX.Property p  in t.Properties){
               //echo("    "+  p.Name + "=" + p.Value + "n" );

                echo("    " + p.Name + "==" + p.Type + "=="   + "n");
           
                 

                   
            }

        }

---