void dataGridView1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e) { DataGridView d = (DataGridView)sender; // Se si sta per modificare il valore del parametro... if (e.ColumnIndex == 2) { ParamBinding b = (ParamBinding)Enum.Parse(typeof(ParamBinding), d.Rows[e.RowIndex].Cells[1].Value.ToString()); // Se la riga corrente si riferisce ad un parametro variable-bound, fai in modo che si apra il popup della scelta delle variabili. if (b == ParamBinding.Variable) { // Mostra il dialog di scelta delle variabili VariableChooser vc = new VariableChooser(_vars); DialogResult dr = vc.ShowDialog(); if (dr == DialogResult.OK) { Microsoft.SqlServer.Dts.Runtime.Variable v = vc.GetResult(); d.Rows[e.RowIndex].Cells[2].Value = v.QualifiedName; e.Cancel = true; //d.EndEdit(); } } else if (b == ParamBinding.InputField) { if (_input_options == null || _input_options.Length < 1) { MessageBox.Show("There is no input attached to this lane. First attach an input, then you'll be able to select a vale from this box."); e.Cancel = true; } } } }
private void button4_Click(object sender, EventArgs e) { VariableChooser vc = new VariableChooser(_vars, new TypeCode[] { TypeCode.Object }, null); DialogResult dr = vc.ShowDialog(); if (dr == DialogResult.OK) { Microsoft.SqlServer.Dts.Runtime.Variable v = vc.GetResult(); if (v.DataType != TypeCode.Object) { MessageBox.Show("The cookie variable MUST be of type \"Object\"."); return; } cookieVarTb.Text = v.QualifiedName; } }
private void browseButton_Click(object sender, EventArgs e) { // If variable is selected, open the variable browser, otherwise open the file browser if (variableR.Checked) { VariableChooser vc = new VariableChooser(_vars, new TypeCode[] { TypeCode.String }, null); DialogResult dr = vc.ShowDialog(); if (dr == DialogResult.OK) { Microsoft.SqlServer.Dts.Runtime.Variable v = vc.GetResult(); uiWebURL.Text = v.QualifiedName; } } else { var res = openFileDialog1.ShowDialog(this); if (res == DialogResult.OK) { // Update the textedit with the file path uiWebURL.Text = openFileDialog1.FileName; } } }