public void Open() { JkDataSetList.Add(this); OnBeforeOpen(); SqlDataAdapter DataAdapter = new SqlDataAdapter(CommandText, Connection.ConnectionString); try { try { if (Parameters.Count > 0) { for (int i = 0; i <= Parameters.Count - 1; i++) { if (String.IsNullOrWhiteSpace(Parameters[i].Value)) { DataAdapter.SelectCommand.Parameters.AddWithValue("@" + Parameters[i].Name, 0); } else { DataAdapter.SelectCommand.Parameters.AddWithValue("@" + Parameters[i].Name, Parameters[i].Value); } } } DataTable.Clear(); DataAdapter.Fill(DataTable); } finally { DataAdapter.SelectCommand.Connection.Close(); DataAdapter.Dispose(); Active = true; } } catch (Exception ex) { new Exception("Object Name: " + this.Name + "\rError: " + ex.Message); } }
private void JkDataGridView_EditModeChanged(object sender, EventArgs e) { foreach (DataGridViewColumn column in this.Columns) { if (this.Columns[column.Index] is DataGridViewComboBoxColumn) { String controlName = this.DataSet.Columns.Find(c => c.Name == this.Columns[column.Index].DataPropertyName).ControlName; JkLookUpComboBox comboBox = JkLookUpComboBoxList.FindByName(controlName); JkDataSet dataSet = JkDataSetList.FindByName(comboBox.DataSet); if (dataSet.Filtered && dataSet.Filter != null && this.EditMode != DataGridViewEditMode.EditProgrammatically && !String.IsNullOrWhiteSpace(dataSet.Filter)) { ((this.Columns[column.Index] as DataGridViewComboBoxColumn).DataSource as DataTable).DefaultView.RowFilter = dataSet.Filter; } else { ((this.Columns[column.Index] as DataGridViewComboBoxColumn).DataSource as DataTable).DefaultView.RowFilter = String.Empty; } } } }