Sorting with SQLDataSource vs LinqDataSource

[Adam]

Hi,

I have run into a bit of a problem with Sorting my grid and it seems to be related to the datasource, but I can't see why.

Originally in the code behind I had in the NeedDatasource event for my grid:

Dim lnqMerchSellers = db.usp_MER_Sellers_GetAll(drpStatus.SelectedValue, iSelectedCountryGroup, PageHelper.getUserAccessLevel(Profile.License, HttpContext.Current.User.Identity.Name, "Merchandise").ToString())
rgdMerchSellerList.DataSource = lnqMerchSellers

Sorting works.

I've now removed the sproc (usp_MER_Sellers_GetAll) from my DAL and access it using a SQL Datasource object on my aspx page.

<asp:SqlDataSource ID="sqlUserList" runat="server" ConnectionString="<%$ ConnectionStrings:AU_Deals_ConnectionString %>" SelectCommand="usp_MER_Sellers_GetAll" SelectCommandType="StoredProcedure" />

Then in the codebehind's NeedDatasource for my grid I use:

sqlUserList.SelectParameters.Clear()
sqlUserList.SelectParameters.Add("filter", DbType.Int32, drpStatus.SelectedValue)
sqlUserList.SelectParameters.Add("countryGroupID", DbType.Int32, iSelectedCountryGroup.ToString())
sqlUserList.SelectParameters.Add("accessLevel", DbType.String, PageHelper.getUserAccessLevel(Profile.License, HttpContext.Current.User.Identity.Name, "Merchandise").ToString())

rgdMerchSellerList.DataSource = lnqMerchSellers

Sorting on my grid, now doesn't work and I don't see why.

Any help would be greatly appreciated.

Thanks.

[Konstantin Dikov]

Hello Adam,

Generally, if you are providing an object as a data source to the grid within the OnNeedDataSource event, RadGrid will use its sorting mechanism on that object (DataTable, DataSet or any object collection that implements the IListSource, IList, IEnumerable, or ICustomTypeDescriptor interface), depending on the users interaction.

Since you are setting the DataSource property manually in both examples, I am not sure how the sorting will work in one of them. Can you please provide the markup of your RadGrid, so we can have a better idea of your exact scenario and made some test locally based on that?


Kind Regards,
Konstantin Dikov
Telerik