从数据库中取出所有表(oracle,sqlserver),从表中取出所有的列名及类型.

 

1.从数据库中取出所有表

public  DataSet getDataBaseTables( string  databaseName)
        {
             try
            {
                Database db  =  DatabaseFactory.CreateDatabase(databaseName);
                 if (db.GetType().Name  ==   " SqlDatabase " )
                {
                    DBCommandWrapper tables  =  db.GetSqlStringCommandWrapper( " Select name from sysobjects where xtype = 'U'order by name " );
                    DataSet allTables  =  db.ExecuteDataSet(tables);
                     return  allTables;
                }
                 else   if (db.GetType().Name  ==   " OracleDatabase " )
                {
                    DBCommandWrapper tables  =  db.GetSqlStringCommandWrapper( " select TABLE_NAME from user_tables " );
                    DataSet allTables  =  db.ExecuteDataSet(tables);
                     return  allTables;
                }
                 return   null ;        
            }
             catch (Exception ex)
            {
                DataBaseException dbex  =   new  DataBaseException(ex.Message, ex);
                 throw (dbex);
            }
        }

 

2.从表中取出所有的列及类型:

 

public  DataSet getColumns( string  databaseName, string  tableName)
        {
             try
            {
                Database db  =  DatabaseFactory.CreateDatabase(databaseName);
                 if (db.GetType().Name  ==   " SqlDatabase " )
                {
                    DBCommandWrapper columns  =  db.GetSqlStringCommandWrapper( " select top 0 * from " " + tableName + " " " );
                    DataSet allColumns =   new  DataSet();
                    allColumns  =  db.ExecuteDataSet(columns);
                     return  allColumns;
                }
                 else   if (db.GetType().Name  ==   " OracleDatabase " )
                {
                    DBCommandWrapper columns  =  db.GetSqlStringCommandWrapper( " select * from  " + tableName + "  where rownum=0 " );
                    
                    DataSet allColumns  =  db.ExecuteDataSet(columns);
                     return  allColumns;
                }
                 return   null ;
            }
             catch (Exception ex)
            {
                DataBaseException dbex  =   new  DataBaseException(ex.Message, ex);
                 throw (dbex);
            }
        }