public static Boolean DBConnect() { if (isConnected) { return(true); } SQLSettings sqlSettings = SQLSettings.GetActiveSQLSettings(); if (!string.IsNullOrEmpty(sqlSettings.Server.Trim()) && !string.IsNullOrEmpty(sqlSettings.Database.Trim()) && !string.IsNullOrEmpty(sqlSettings.Username.Trim()) && !string.IsNullOrEmpty(sqlSettings.Password.Trim())) { connectionStringMain = String.Format("Data Source={0};Network Library=DBMSSOCN;Initial Catalog={1};Persist Security Info=True; MultipleActiveResultSets=True;User ID={2};Password={3};Max Pool Size=4000", sqlSettings.Server.Replace(":", ",").Replace(" ", ""), sqlSettings.Database, sqlSettings.Username, sqlSettings.Password); } else { Err = "Database connection parameters are not set!"; return(false); } try { if (connectionMain == null) { connectionMain = new SqlConnection(); } if (connectionMain.State == System.Data.ConnectionState.Open) { connectionMain.Close(); connectionMain.Dispose(); SqlConnection.ClearPool(connectionMain); } SqlCommand com = new SqlCommand(); connectionMain.ConnectionString = connectionStringMain; com.Connection = connectionMain; connectionMain.Open(); isConnected = true; return(true); } catch (Exception ex) { Err = ex.Message; return(false); } }
public MainForm() { InitializeComponent(); sqlSettings = SQLSettings.GetActiveSQLSettings(); Logins = SQLSettings.getLoginInformation(); }