取得connectionStrings属性

取得Web config文件连接数据库字符各个属性。

代码
 public string GetConnectionValue(string Keyword,string connectionString)
        {
            
string[] aa = Keyword.Split(',');           
            
string[] bb = connectionString.Split(';');
            
string strTempValue = string.Empty;
            
foreach (string b in bb)
            {
                
foreach (string a in aa)
                {
                    
if (b.IndexOf("="< 0continue;  
                    
if (b.StartsWith(a, StringComparison.OrdinalIgnoreCase))
                        strTempValue 
= b.Substring(b.IndexOf("="+ 1);
                }
            }
            
return strTempValue;
        }

 

代码
        public string GetServerName()
        {
            
string key = "Data Source,Server,Address,Addr,Network Address";
            
return GetConnectionValue(key);
        }

        
public string GetDataBaseName()
        {
            
string key = "Initial Catalog,Database";
            
return GetConnectionValue(key);
        }

        
public string GetPassword()
        {
            
string key = "Password,Pwd";
            
return GetConnectionValue(key);
        }

        
public string GetUserId()
        {
            
string key = "User ID,uid";
            
return GetConnectionValue(key);
        }

        
public string GetPacketSize()
        {
            
string key = "Packet Size";
            
return GetConnectionValue(key);
        }

        
public string GetPooling()
        {
            
string key = "Pooling";
            
return GetConnectionValue(key);
        }

        
public string GetMaxPoolSize()
        {
            
string key = "Max Pool Size";
            
return GetConnectionValue(key);
        }

        
public string GetTrustedSecurity()
        {
            
string key = "Integrated Security,Trusted_Connection";
            
return GetConnectionValue(key);
        }

        
public bool IsTrustedSecurityConnection()
        {
            
string sScty = GetTrustedSecurity();
            
return (sScty == "SSPI" || sScty == "True");
        }

        
public bool IsAtLocalMachine()
        {
            
string sName = GetServerName();
            
return (sName == "127.0.0.1" || sName == "localhost");
        }

 

 

posted @ 2010-12-17 12:55  Insus.NET  阅读(1191)  评论(1编辑  收藏  举报