private static Boolean keyEqual( String key, ConnectionItemType connectionItemType ) { if (connectionItemType == ConnectionItemType.Server) return key == "server"; if (connectionItemType == ConnectionItemType.Database) return key == "database"; if (connectionItemType == ConnectionItemType.UserId) return key == "user" || key == "uid" || key == "user id"; if (connectionItemType == ConnectionItemType.Password) return key == "password" || key == "pwd"; return false; }
public static String getConnectionItem(String connStr, ConnectionItemType connectionItemType) { if (strUtil.IsNullOrEmpty(connStr)) { throw new Exception("mysql connection string is empty"); } String[] arrItems = connStr.ToLower().Split(';'); foreach (String item in arrItems) { if (strUtil.IsNullOrEmpty(item)) { continue; } String[] arrPair = item.Split('='); if (arrPair.Length != 2) { continue; } String key = arrPair[0].Trim(); String val = arrPair[1].Trim(); if (keyEqual(key, connectionItemType)) { return(val); } } return(""); }
private String getEnumKey( ConnectionItemType connectionItem ) { if (connectionItem == ConnectionItemType.Server) return "server"; if (connectionItem == ConnectionItemType.UserId) return "userid"; if (connectionItem == ConnectionItemType.Password) return "password"; if (connectionItem == ConnectionItemType.Database) return "database"; if (connectionItem == ConnectionItemType.IsTrusted) return "istrusted"; return null; }
public String GetConnectionItem( String connectionString, ConnectionItemType connectionItem ) { String str = connectionItem.ToString().ToLower().Replace( "userid", "uid" ).Replace( "password", "pwd" ); String[] strArray = connectionString.ToLower().Split( new char[] { ';' } ); foreach (String item in strArray) { if (item.Trim().ToLower().StartsWith( str )) return item.Replace( str, "" ).Replace( "=", "" ).Replace( " ", "" ); } return null; }
public String GetConnectionItem( String connectionString, ConnectionItemType connectionItem ) { String str = connectionItem.ToString().ToLower().Replace( "database", "data source" ).Replace( "userid", "user id" ); String[] arrItem = connectionString.ToLower().Split( new char[] { ';' } ); foreach (String item in arrItem) { if (item.Trim().ToLower().StartsWith( str )) return item.Replace( str, "" ).Replace( "=", "" ).Replace( " ", "" ); } return null; }
public static String getConnectionItem( String connStr, ConnectionItemType connectionItemType ) { if (strUtil.IsNullOrEmpty( connStr )) throw new Exception( "mysql connection string is empty" ); String[] arrItems = connStr.ToLower().Split( ';' ); foreach (String item in arrItems) { if (strUtil.IsNullOrEmpty( item )) continue; String[] arrPair = item.Split( '=' ); if (arrPair.Length != 2) continue; String key = arrPair[0].Trim(); String val = arrPair[1].Trim(); if (keyEqual( key, connectionItemType )) return val; } return ""; }
public String GetConnectionItem(String connectionString, ConnectionItemType connectionItem) { String str = connectionItem.ToString().ToLower().Replace("database", "data source").Replace("userid", "user id"); String[] arrItem = connectionString.ToLower().Split(new char[] { ';' }); foreach (String item in arrItem) { if (item.Trim().ToLower().StartsWith(str)) { return(item.Replace(str, "").Replace("=", "").Replace(" ", "")); } } return(null); }
public String GetConnectionItem(String connectionString, ConnectionItemType connectionItem) { String str = connectionItem.ToString().ToLower().Replace("userid", "uid").Replace("password", "pwd"); String[] strArray = connectionString.ToLower().Split(new char[] { ';' }); foreach (String item in strArray) { if (item.Trim().ToLower().StartsWith(str)) { return(item.Replace(str, "").Replace("=", "").Replace(" ", "")); } } return(null); }
private static Boolean keyEqual(String key, ConnectionItemType connectionItemType) { if (connectionItemType == ConnectionItemType.Server) { return(key == "server"); } if (connectionItemType == ConnectionItemType.Database) { return(key == "database"); } if (connectionItemType == ConnectionItemType.UserId) { return(key == "user" || key == "uid" || key == "user id"); } if (connectionItemType == ConnectionItemType.Password) { return(key == "password" || key == "pwd"); } return(false); }
public String GetConnectionItem(String connectionString, ConnectionItemType connectionItem) { if (connectionString == null) { throw new NullReferenceException("connectionString"); } String[] arrItems = connectionString.Split(';'); Dictionary <String, String> dic = new Dictionary <String, String>(); foreach (String item in arrItems) { if (strUtil.IsNullOrEmpty(item)) { continue; } String[] arr = item.Trim().Split('='); if (arr.Length != 2) { continue; } String akey = getKey(arr[0].Trim()); if (akey == null) { continue; } dic[akey] = arr[1].Trim(); } String result = null; dic.TryGetValue(getEnumKey(connectionItem), out result); return(result); }
public String GetConnectionItem( String connectionString, ConnectionItemType connectionItem ) { if (connectionString == null) throw new NullReferenceException( "connectionString" ); String[] arrItems = connectionString.Split( ';' ); Dictionary<String,String> dic = new Dictionary<String,String>(); foreach (String item in arrItems) { if (strUtil.IsNullOrEmpty( item )) continue; String[] arr = item.Trim().Split( '=' ); if (arr.Length != 2) continue; String akey = getKey( arr[0].Trim() ); if (akey == null) continue; dic[akey] = arr[1].Trim(); } String result = null; dic.TryGetValue( getEnumKey( connectionItem ), out result ); return result; }
private String getEnumKey(ConnectionItemType connectionItem) { if (connectionItem == ConnectionItemType.Server) { return("server"); } if (connectionItem == ConnectionItemType.UserId) { return("userid"); } if (connectionItem == ConnectionItemType.Password) { return("password"); } if (connectionItem == ConnectionItemType.Database) { return("database"); } if (connectionItem == ConnectionItemType.IsTrusted) { return("istrusted"); } return(null); }
public String GetConnectionItem( String connectionString, ConnectionItemType connectionItem ) { return getConnectionItem( connectionString, connectionItem ); }
public String GetConnectionItem(String connectionString, ConnectionItemType connectionItem) { return(getConnectionItem(connectionString, connectionItem)); }