public ConfigConnexion() { InitializeComponent(); List <string> list1 = EnumDsn(); for (int i = 0; i < list1.Count; i++) { comboBox1.Items.Add(list1[i]); } List <string> list2 = EnumDsn(); for (int i = 0; i < list2.Count; i++) { comboBox2.Items.Add(list2[i]); } Connexion.ConnexionSaveLoad settings = new Connexion.ConnexionSaveLoad(); if (settings.isSettings()) { settings.Load(); comboBox1.Text = settings.configurationConnexion.ODBC.DNS; textBox2.Text = settings.configurationConnexion.ODBC.USER; textBox3.Text = settings.configurationConnexion.ODBC.PWD; comboBox2.Text = settings.configurationConnexion.SQL.DNS; textBox4.Text = settings.configurationConnexion.SQL.USER; textBox1.Text = settings.configurationConnexion.SQL.PWD; } }
public static string getPrefix() { string result = ""; string pathModule = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location); Connexion.ConnexionSaveLoad connexionSaveLoad = new Connexion.ConnexionSaveLoad(); if (connexionSaveLoad.isSettings()) { connexionSaveLoad.Load(); result = connexionSaveLoad.configurationConnexion.SQL.PREFIX + ".dbo."; } return(result); }
public string ReturnTaskName() { string taskName = "ConnecteurSage"; try { Connexion.ConnexionSaveLoad settings = new Connexion.ConnexionSaveLoad(); if (!settings.isSettings()) { MessageBox.Show("Veuillez renseigner la configuration de connexion ODBC d'abord.", "Config Général", MessageBoxButtons.OK, MessageBoxIcon.Information); return(null); } settings.Load(); taskName += "_" + settings.configurationConnexion.SQL.PREFIX; return(taskName); } catch (Exception ex) { MessageBox.Show("Message: " + ex.Message, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); return(null); } }
public string getDNS() { Connexion.ConnexionSaveLoad settings = new Connexion.ConnexionSaveLoad(); settings.Load(); return(settings.configurationConnexion.SQL.PREFIX); }