private void SaveLoginSettings() { Logins.username = (textBoxUsername.Text); Logins.password = (textBoxPassword.Text); SQLSettings.setLoginInformation(Logins); }
private void SaveSqlSettings() { sqlSettings.Server = txt_Server.Text; sqlSettings.Database = txt_Database.Text; sqlSettings.Username = txt_Username.Text; sqlSettings.Password = txt_Password.Text; SQLSettings.setActiveSQLSettings(sqlSettings); }
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 static void setActiveSQLSettings(SQLSettings aSettings) { if (!Directory.Exists(AppPaths.AppSettingsPath)) { Directory.CreateDirectory(AppPaths.AppSettingsPath); } var filename = Path.Combine(AppPaths.AppSettingsPath, "AppData.dat"); using (var fs = File.Open(filename, FileMode.Create)) { try { var xmlser = new XmlSerializer(typeof(SQLSettings)); xmlser.Serialize(fs, aSettings); } catch { } //fs.Close(); //fs.Dispose(); } }
public MainForm() { InitializeComponent(); sqlSettings = SQLSettings.GetActiveSQLSettings(); Logins = SQLSettings.getLoginInformation(); }