取出dataConfiguration.config里的数据,查询数据库中表的所有信息(如是否是主健等)

 1.取出dataConfiguration.config里的数据,查询数据库中表的所有信息(如是否是主健等)

 

DatabaseSettings databaseSettings  =  ConfigurationManager.GetConfiguration( " dataConfiguration " )  as  DatabaseSettings;
             string  dataBase  =   this .generateRule_ddl_Database.SelectedValue;
             if (databaseSettings.Instances[dataBase].DatabaseTypeName  == " Sql Server " )
            {
                ViewState[ " AlertRuleOorS " ]  =   " 0 " ;
            }
             else
            {
                ViewState[ " AlertRuleOorS " ]  =   " 1 " ;
            }
             string  connectString  =  databaseSettings.Instances[dataBase].ConnectionString;
            ConnectionStringData connectionStringData  =  databaseSettings.ConnectionStrings[connectString]; 
             bool  isPrimaryKey  =   false ;
             foreach ( ParameterData parameter  in  connectionStringData.Parameters ) 
            { 
                 switch ( parameter.Name.ToLower() ) 
                { 
                     case   " database " : 
                        ViewState[ " database " ]  =  parameter.Value; 
                         break ; 
                     case   " integrated security " : 
                        ViewState[ " Security " ]  =  parameter.Value; 
                         break ; 
                     case   " server " : 
                        ViewState[ " server " ]  =  parameter.Value;  
                         break ; 
                     case   " user id " : 
                        ViewState[ " userID " ]  =  parameter.Value;  
                         break ;
                     case   " password " : 
                        ViewState[ " password " ]  =  parameter.Value;  
                         break ;
                     case   " data source " : 
                        ViewState[ " dataSource " ]  =  parameter.Value;  
                         break ;
                } 
            } 
            DataConfiguration    config;
             if (ViewState[ " AlertRuleOorS " ].ToString()  ==   " 0 " )
            {
                config  =   new  DataConfiguration(DataBaseType.SqlServer ,ViewState[ " server " ].ToString(),
                    ViewState[ " userID " ].ToString() ,ViewState[ " password " ].ToString() ,ViewState[ " database " ].ToString() , null );
            }
             else