private void PassParametersCheckbox_CheckedChanged(object sender, EventArgs e) { Engine.AutomationEngineInstance currentScriptEngine = new Engine.AutomationEngineInstance(); var startFile = v_taskPath.ConvertToUserVariable(currentScriptEngine); var Sender = (CheckBox)sender; AssignmentsGridViewHelper.Visible = Sender.Checked; //load variables if selected and file exists if ((Sender.Checked) && (System.IO.File.Exists(startFile))) { Script.Script deserializedScript = Core.Script.Script.DeserializeFile(startFile); foreach (var variable in deserializedScript.Variables) { DataRow[] foundVariables = v_VariableAssignments.Select("VariableName = '" + variable.VariableName + "'"); if (foundVariables.Length == 0) { v_VariableAssignments.Rows.Add(variable.VariableName, variable.VariableValue); } } AssignmentsGridViewHelper.DataSource = v_VariableAssignments; for (int i = 0; i < AssignmentsGridViewHelper.Rows.Count - 1; i++) { DataGridViewComboBoxCell returnComboBox = new DataGridViewComboBoxCell(); returnComboBox.Items.Add("Yes"); returnComboBox.Items.Add("No"); AssignmentsGridViewHelper.Rows[i].Cells[2] = returnComboBox; } } }
private void TestConnection(object sender, EventArgs e) { try { var engine = new Engine.AutomationEngineInstance(); var oleDBConnection = CreateConnection(engine); oleDBConnection.Open(); oleDBConnection.Close(); MessageBox.Show("Connection Successful", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { MessageBox.Show($"Connection Failed: {ex.ToString()}", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error); } }