private object ExecuteScalar(string script, SettingClass settings) { using (var con = new SqlConnection()) { string connectionString = string.Format("Server={0},{4};Database={1};User Id={2};Password={3};", settings.SQLServer, selectedDatabase, settings.SQLUsername, settings.SQLPassword, settings.SQLPort); con.ConnectionString = connectionString; using (var cmd = new SqlCommand()) { con.Open(); cmd.Connection = con; cmd.CommandText = script; return(cmd.ExecuteScalar()); } } }
private void ExecutePatch(string script, SettingClass settings) { StaticObjects.log.Info("Query"); StaticObjects.log.Info(script); using (var con = new SqlConnection()) { string connectionString = string.Format("Server={0},{4};Database={1};User Id={2};Password={3};", settings.SQLServer, selectedDatabase, settings.SQLUsername, settings.SQLPassword, settings.SQLPort); con.ConnectionString = connectionString; using (var cmd = new SqlCommand()) { con.Open(); cmd.Connection = con; cmd.CommandText = script; cmd.ExecuteNonQuery(); } } }
private void SettingsForm_Load(object sender, EventArgs e) { if (File.Exists(Environment.ExpandEnvironmentVariables("%allusersprofile%") + "/PostgreSQLMigrationUtility/Configuration.config")) { Settings = JsonConvert.DeserializeObject <SettingClass>(File.ReadAllText(Environment.ExpandEnvironmentVariables("%allusersprofile%") + "/PostgreSQLMigrationUtility/Configuration.config")); txtMigrationLocation.Text = Settings.MigrationLocation; txtPostgresPort.Text = Settings.PostgresPort; txtPostgreSQLPassword.Text = Settings.PostgresPassword; txtPostgreSQLUsername.Text = Settings.PostgresUsername; txtPostgresSQL.Text = Settings.Postgres; txtSQLPassword.Text = Settings.SQLPassword; txtSQLPort.Text = Settings.SQLPort; txtSQLServer.Text = Settings.SQLServer; txtSQLUsername.Text = Settings.SQLUsername; } else { Settings = new SettingClass(); } }
private DataSet ExecuteDataset(string script, SettingClass settings) { DataSet ds = new DataSet(); using (var con = new SqlConnection()) { string connectionString = string.Format("Server={0},{4};Database={1};User Id={2};Password={3};", settings.SQLServer, selectedDatabase, settings.SQLUsername, settings.SQLPassword, settings.SQLPort); con.ConnectionString = connectionString; using (var cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandText = script; using (var da = new SqlDataAdapter(cmd)) { da.Fill(ds); } } } return(ds); }