var cmbContactsName = new DataGridViewComboBoxColumn(); var dt2 = new DataTable(); dt2 = StMethod.GetListDT<InvoiceAddress>("SELECT (FirstName +' '+ LastName) as Contact,EmailAddress ,ContactsID FROM contacts where (IsDelete=0 or IsDelete IS NULL) AND Companyid=" + grdCompany.Rows[grdCompany.CurrentRow.Index].Cells["CompanyID"].Value.ToString()); cmbContactsName.DataSource = dt2; cmbContactsName.ValueMember = dt2.Columns["ContactsID"].ToString(); cmbContactsName.DisplayMember = dt2.Columns["Contact"].ToString(); cmbContactsName.DataPropertyName = dt2.Columns["ContactsID"].ToString(); cmbContactsName.HeaderText = "Contacts Name"; cmbContactsName.ValueType = typeof(String); cmbContactsName.DefaultCellStyle.NullValue = "";
cmbContactsName.ValueMember = "ContactsID"; cmbContactsName.DisplayMember = "Contact"; cmbContactsName.DataPropertyName = "ContactsID";
cmbContactsName.ValueMember = "ContactsID"; cmbContactsName.DisplayMember = "Contact"; cmbContactsName.DataPropertyName = "ContactsID"; cmbContactsName.DataSource = dt2;
cmbContactsName.DataSource = dt2.DefaultView;
cmbContactsName.DataSource = dt2;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)