private void SearchBanksForm_Load(object sender, EventArgs e) { try { AccountFields.Add(new Field("banksortcode", "string")); AccountFields.Add(new Field("bankcode", "string")); AccountFields.Add(new Field("bankname", "string")); AccountFields.Add(new Field("branchcode", "string")); AccountFields.Add(new Field("branchname", "string")); cbField.DataSource = AccountFields; cbField.DisplayMember = "Name"; cbField.ValueMember = "Name"; cbOperator.DataSource = Op.GetList(); cbOperator.DisplayMember = "Description"; cbOperator.ValueMember = "Symbol"; lstCriteria.DataSource = criteriaBuilder.CriterionItemList(); var _Banksquery = from b in db.Banks select b; List <Bank> _Banks = _Banksquery.ToList(); DataGridViewComboBoxColumn colBank = new DataGridViewComboBoxColumn(); colBank.HeaderText = "Bank"; colBank.Name = "cbBank"; colBank.DataSource = _Banks; colBank.DisplayMember = "BankName"; colBank.DataPropertyName = "BankCode"; colBank.ValueMember = "BankCode"; colBank.MaxDropDownItems = 10; colBank.DisplayIndex = 4; colBank.MinimumWidth = 5; colBank.Width = 200; colBank.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; colBank.FlatStyle = FlatStyle.Flat; colBank.DefaultCellStyle.NullValue = "--- Select ---"; colBank.ReadOnly = true; if (!this.dataGridViewBanks.Columns.Contains("cbBank")) { dataGridViewBanks.Columns.Add(colBank); } var _BankBranchesquery = from bb in db.BankBranches select bb; List <BankBranch> _BankBranches = _BankBranchesquery.ToList(); DataGridViewComboBoxColumn colBranch = new DataGridViewComboBoxColumn(); colBranch.HeaderText = "Branch"; colBranch.Name = "cbBranch"; colBranch.DataSource = _BankBranches; colBranch.DisplayMember = "BranchName"; colBranch.DataPropertyName = "BankSortCode"; colBranch.ValueMember = "BankSortCode"; colBranch.MaxDropDownItems = 10; colBranch.DisplayIndex = 3; colBranch.MinimumWidth = 5; colBranch.Width = 150; colBranch.FlatStyle = FlatStyle.Flat; colBranch.DefaultCellStyle.NullValue = "--- Select ---"; colBranch.ReadOnly = true; if (!this.dataGridViewBanks.Columns.Contains("cbBranch")) { dataGridViewBanks.Columns.Add(colBranch); } this.dataGridViewBanks.AutoGenerateColumns = false; this.dataGridViewBanks.SelectionMode = DataGridViewSelectionMode.FullRowSelect; } catch (Exception ex) { Utils.ShowError(ex); } }
private void SelectForm_Load(object sender, EventArgs e) { try { empFields.Add(new Field("EmpNo", "string")); empFields.Add(new Field("Surname", "string")); empFields.Add(new Field("DoB", "date")); empFields.Add(new Field("DoE", "date")); empFields.Add(new Field("Department", "string")); empFields.Add(new Field("MaritalStatus", "string")); empFields.Add(new Field("PayPoint", "string")); empFields.Add(new Field("EmpGroup", "string")); empFields.Add(new Field("EmpPayroll", "string")); empFields.Add(new Field("Gender", "string")); cbField.DataSource = empFields; cbField.DisplayMember = "Name"; cbField.ValueMember = "Name"; cbOperator.DataSource = Op.GetList(); cbOperator.DisplayMember = "Description"; cbOperator.ValueMember = "Symbol"; lbCriteria.DataSource = criteriaBuilder.CriterionItemList(); var _departmentsquery = from dp in db.Departments select dp; List <Department> _Departments = _departmentsquery.ToList(); DataGridViewComboBoxColumn colCboxDepartment = new DataGridViewComboBoxColumn(); colCboxDepartment.HeaderText = "Department"; colCboxDepartment.Name = "cbDepartment"; colCboxDepartment.DataSource = _Departments; // The display member is the name column in the column datasource colCboxDepartment.DisplayMember = "Description"; // The DataPropertyName refers to the foreign key column on the datagridview datasource colCboxDepartment.DataPropertyName = "Department"; // The value member is the primary key of the parent table colCboxDepartment.ValueMember = "Code"; colCboxDepartment.MaxDropDownItems = 10; colCboxDepartment.Width = 100; colCboxDepartment.DisplayIndex = 4; colCboxDepartment.MinimumWidth = 5; colCboxDepartment.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; colCboxDepartment.FlatStyle = FlatStyle.Flat; colCboxDepartment.DefaultCellStyle.NullValue = "--- Select ---"; colCboxDepartment.ReadOnly = true; if (!this.dataGridViewEmployees.Columns.Contains("cbDepartment")) { dataGridViewEmployees.Columns.Add(colCboxDepartment); } var gender = new BindingList <KeyValuePair <string, string> >(); gender.Add(new KeyValuePair <string, string>("M", "Male")); gender.Add(new KeyValuePair <string, string>("F", "Female")); DataGridViewComboBoxColumn colCboxGender = new DataGridViewComboBoxColumn(); colCboxGender.HeaderText = "Gender"; colCboxGender.Name = "cbGender"; colCboxGender.DataSource = gender; // The display member is the name column in the column datasource colCboxGender.DisplayMember = "Value"; // The DataPropertyName refers to the foreign key column on the datagridview datasource colCboxGender.DataPropertyName = "Gender"; // The value member is the primary key of the parent table colCboxGender.ValueMember = "Key"; colCboxGender.MaxDropDownItems = 10; colCboxGender.Width = 100; colCboxGender.DisplayIndex = 3; colCboxGender.MinimumWidth = 5; //colCboxGender.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; colCboxGender.FlatStyle = FlatStyle.Flat; colCboxGender.DefaultCellStyle.NullValue = "--- Select ---"; colCboxGender.ReadOnly = true; if (!this.dataGridViewEmployees.Columns.Contains("cbGender")) { dataGridViewEmployees.Columns.Add(colCboxGender); } dataGridViewEmployees.AutoGenerateColumns = false; this.dataGridViewEmployees.SelectionMode = DataGridViewSelectionMode.FullRowSelect; dataGridViewEmployees.DataSource = bindingSourceEmployees; } catch (Exception ex) { Utils.ShowError(ex); } }