Hi guys,

I have an ASP.NET DropDownList that i'd like to sort alphabetically by the Name field, but i'd like to apply sorting to the LLBLGen Pro Datasource that it is bound to. Please advise? Here is the code:

** <asp ropDownList id="DropDownList1" runat="server" DataSourceID="LLBLGenProDataSource2" AppendDataBoundItems="true" SelectedValue='<%# Bind("ParentId") %>' DataValueField="Id" DataTextField="Name" OnDataBound="DropDownList1_DataBound" ><asp:ListItem Text="-No Parent-" Value="" Selected="True"/> </asp ropDownList> **

and the DataSource:

** <llblgenpro:LLBLGenProDataSource ID="LLBLGenProDataSource2" runat="server" DataContainerType="EntityCollection" EntityCollectionTypeName="Eyeballs.Data.CollectionClasses.AdvertiserCollection, Eyeballs.Data" SortingMode="ClientSide" OnElementsFetched="LLBLGenProDataSource2_ElementsFetched"> </llblgenpro:LLBLGenProDataSource> **

At the moment, the fields returned by the LLBLGen Pro Datasource include Id, ParentId, Name, sActive, DateCreated, DateUpdated.

I am using LLBLGen Pro Version 2.5 (ORMSupportClasses Type: SelfServicing) on ASP.NET 2.0 and Windows XP Service Pack 2, with MS SQL Server 2005.

Thanks,

Lloyd Dube

At code behind pass (eg. PageLoad): use the following:

LLBLGenProDataSource2.SorterToUse = new SortExpression(...);

Thanks Walaa, i appreciate. I saw something to that effect in the LLBLGen docs - i'm having trouble figuring out what the argument to SorterToUse should be, i.e. what type/ format it should take.

Please check the reference manual if you're unsure what type and VS.NET doesn't reveal it to you. (ISortExpression btw)

Hehehe okay Frans...i think you really mean, "sorry no spoonfeeding here" lol

Ciao