Example #1
0
        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;
        }
        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;
        }