private void LoadContact() { Data.ContactColumns clsContactColumns = new Data.ContactColumns(); clsContactColumns.ContactName = true; Data.ContactColumns clsSearchColumns = new Data.ContactColumns(); clsContactColumns.ContactName = true; clsContactColumns.ContactCode = true; Data.Contacts clsContact = new Data.Contacts(); cboSupplier.DataTextField = Data.ContactColumnNames.ContactName; cboSupplier.DataValueField = Data.ContactColumnNames.ContactID; cboSupplier.DataSource = clsContact.Suppliers(clsContactColumns, 0, System.Data.SqlClient.SortOrder.Ascending, clsSearchColumns, txtSupplier.Text, 100, false, Data.ContactColumnNames.ContactName, System.Data.SqlClient.SortOrder.Ascending).DefaultView; cboSupplier.DataBind(); clsContact.CommitAndDispose(); cboSupplier.Items.Add(new ListItem("All Suppliers", "0")); cboSupplier.SelectedIndex = cboSupplier.Items.Count - 1; }