public static SqlConnection GetSQLConnection() { try { //string conn_string = "Data Source=./db.s3db; FailIfMissing=True; MultipleActiveResultSets=True"; //MessageBox.Show(conn_string); SqlConnectionStringBuilder con_build = new SqlConnectionStringBuilder(); string DBString = readDBString(); con_build.DataSource = GH.Split_csv_get_specific(DBString, 0); con_build.InitialCatalog = GH.Split_csv_get_specific(DBString, 1); con_build.UserID = GH.Split_csv_get_specific(DBString, 2); con_build.Password = GH.Split_csv_get_specific(DBString, 3); //MessageBox.Show(con_build.ToString()); SqlConnection conn = new SqlConnection(con_build.ToString()); conn.Open(); return(conn); } catch (SystemException ex) { //MessageBox.Show(ex.Message); return(null); } }
public static string readDBString() { return(GH.DecodeFrom64(xmlParser.getXMLValue(Global.variables.settingsFile, "Settings", "name", "dbstring"))); }