CodeSmith Community

Hello:  Okay, I've done quite a bit of searching for this, but to no avail.  Item in question is the 'OrderByClause' used with typed datasources as an input parameter.  The obvious use is and 'order by' clause for a stored proc parameter.  The unobvious is what the 'OrderByClause' traces back to.  I've found that the 'OrderByClause' is an alias in the EntityDataSource and as a dictionary indexer in the CustomDataSource, but that's it.  For the typed datasource, I cannot find how/where the 'OrderByClause' is used; however, I do see where the DataSourceSelectArguments propeties are assigned to the various BaseDataSource parameters including OrderBy (from SortExpression) in BaseDataSource.  So, my confusion is with where is the 'OrderByClause' parameter used and is it actually necessary?  Any clarification and/or insight would be greatly appreciated.  Thanks...

In case you want to order the datalist of a typed datasource you can use the Sort property instead of an OrderByClause.

 Example:   Let's say you want to populate a Radiobutton list with the typed dataSource

RepeatDirection="Vertical" RepeatColumns="1"

DataTextField="LotTypeName" DataValueField="LotTypeID" >

</asp:RadioButtonList>

<data:LotTypeDataSource ID="LotTypeDataSource1" runat="server" SelectMethod="GetAll">

</data:LotTypeDataSource>

You need then the following code in your PageLoad code behind

LotTypeDataSource1.Sort = "LotTypeID";

Hope this helps

Tanno