I'm trying to bind a listbox, which is working fine, as is the filter.

However, when I try to add the sort clause in, it isn't working - any ideas as to why?

Many thanks

Darren

PredicateExpression filter = new PredicateExpression();
            filter.Add(ManufacturerFields.CatalogueId == m_iCatalogueID);

            SortExpression sort = new SortExpression();
            SortClause clause = new SortClause(ManufacturerFields.Name, SortOperator.Ascending);

            ManufacturerCollection manufacturers = new ManufacturerCollection();

            LLBLGenProDataSource dsManuf = new LLBLGenProDataSource();
            dsManuf.CacheLocation = DataSourceCacheLocation.Session;
            dsManuf.DataContainerType = DataSourceDataContainerType.EntityCollection;
            dsManuf.FilterToUse = filter;
            dsManuf.SorterToUse = sort;
            dsManuf.EntityCollection = manufacturers;
            dsManuf.EntityCollectionTypeName = "RedStarEnergy.DAL.CollectionClasses.ManufacturerCollection";
            lstManufacturer.DataSource = dsManuf;
            lstManufacturer.DataValueField = "ManufacturerID";
            lstManufacturer.DataTextField = "Name";
            lstManufacturer.DataBind();

Hi Darren, I think you should add the SortClause to the SortExpression clauses collection.

SortExpression sort = new SortExpression();
SortClause clause = new SortClause(ManufacturerFields.Name, SortOperator.Ascending);

// line missing
sort.Add(clause);

Cheers

daelmo - thank you for not laughing me off the forum!

best regards

darren