void SAPQuery_SelectedIndexChanged(object sender, EventArgs e) { //throw new NotImplementedException(); ComboBox comboBox = sender as ComboBox; if (comboBox.DataSource != null) { QuerySelectionParameterCollection collection = (QuerySelectionParameterCollection)comboBox.DataSource; foreach (QuerySelectionParameter item in collection) { if (item.DescriptionText == comboBox.Text) { dgvParameters.Rows[dgvParameters.CurrentCell.RowIndex].Cells["CKIND"].Value = item.Kind == Kind.SelectOption ? "SelectOption" : "Parameter"; dgvParameters.Rows[dgvParameters.CurrentCell.RowIndex].Cells["CFIELDNAME"].Value = item.FieldName; dgvParameters.Rows[dgvParameters.CurrentCell.RowIndex].Cells["CNAME"].Value = item.Name; } } } comboBox.SelectedIndexChanged -= new EventHandler(SAPQuery_SelectedIndexChanged); }
private void GetQueryDefinition() { try { WorkSpace area = checkStandard.Checked == true ? WorkSpace.StandardArea : WorkSpace.GlobalArea; SAPConnection con = new SAPConnection(systemName); q = con.CreateQuery(area, userGroup, queryName, variant); // parameterCollection = new QuerySelectionParameterCollection(); parameterCollection = q.SelectionParameters; dgvParameters.Rows.Clear(); DataGridViewComboBoxColumn col = (DataGridViewComboBoxColumn)dgvParameters.Columns["CSELNAME"]; col.DataSource = null; col.DataSource = parameterCollection; col.DisplayMember = "DescriptionText"; q = null; } catch (Exception e) { MessageBox.Show(e.Message); } }