[Solved] RadGrid Sorting Problem

[Prakash]

hi,

i have a radgrid in my aspx page. The default sorting is not working.

below is the code

in aspx

<

 

telerik:RadGrid ID="rgPParts" DataSourceID="dsParts" Width="675px" Height='<%# SetHeight() %>'

 

 

AutoGenerateColumns="False" GridLines="None" AllowPaging="True" PageSize="30"

 

 

runat="server" CellPadding="0" OnItemDataBound="rgPParts_ItemDataBound" OnSelectedIndexChanged="rgPParts_SelectedIndexChanged"

 

 

Skin="" EnableEmbeddedSkins="False" ImagesPath="~\Images\Grid\" CssClass="grid"

 

 

OnPreRender="rgPParts_PreRender" AllowSorting="True" OnPageIndexChanged="rgPParts_PageIndexChanged">

 

 

<PagerStyle Position="Bottom" Mode="NextPrevAndNumeric" PagerTextFormat="{4} Showing {2}-{3} of {5}"

 

 

CssClass="gridpager" />

 

 

<MasterTableView AllowPaging="true" DataKeyNames="SkuId">

 

 

 

<HeaderStyle CssClass="gridheaderstyle"></HeaderStyle>

 

 

<Columns>

 

 

<telerik:GridBoundColumn HeaderText="PN" DataField="PartNumber">

 

 

<HeaderStyle Width="80px"></HeaderStyle>

 

 

<ItemStyle Width="80px"></ItemStyle>

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn HeaderText="DESC" DataField="Description">

 

 

<HeaderStyle Width="108px"></HeaderStyle>

 

 

<ItemStyle Width="108px"></ItemStyle>

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn HeaderText="CD" DataField="Condition">

 

 

<HeaderStyle Width="30px"></HeaderStyle>

 

 

<ItemStyle Width="30px"></ItemStyle>

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn HeaderText="WH" DataField="WarehouseId" AllowSorting="false">

 

 

<HeaderStyle Width="60px"></HeaderStyle>

 

 

<ItemStyle Width="60px"></ItemStyle>

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn HeaderText="Q" DataField="Quantity">

 

 

<HeaderStyle Width="60px"></HeaderStyle>

 

 

<ItemStyle Width="60px"></ItemStyle>

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn HeaderText="QA" DataField="QuantityAvailable">

 

 

<HeaderStyle Width="60px"></HeaderStyle>

 

 

<ItemStyle Width="60px"></ItemStyle>

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn HeaderText="CST" DataField="AverageCostPrice" AllowSorting="false">

 

 

<HeaderStyle Width="60px"></HeaderStyle>

 

 

<ItemStyle Width="60px"></ItemStyle>

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn HeaderText="LST" DataField="ListPrice" AllowSorting="false">

 

 

<HeaderStyle Width="60px"></HeaderStyle>

 

 

<ItemStyle Width="60px"></ItemStyle>

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn HeaderText="WS" DataField="WholesalePrice" AllowSorting="false">

 

 

<HeaderStyle Width="60px"></HeaderStyle>

 

 

<ItemStyle Width="60px"></ItemStyle>

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridBoundColumn HeaderText="RT" DataField="RetailPrice" AllowSorting="false">

 

 

 

</telerik:GridBoundColumn>

 

 

<telerik:GridTemplateColumn HeaderText="" Visible="False">

 

 

<ItemTemplate>

 

 

<asp:Label ID="lblType" runat="server" Text='<%# Bind("InventoryType") %>' Visible="false">

 

 

</asp:Label>

 

 

</ItemTemplate>

 

 

</telerik:GridTemplateColumn>

 

 

</Columns>

 

 

</MasterTableView>

 

 

<SelectedItemStyle BackColor="#FFFFCC" />

 

 

<ClientSettings EnablePostBackOnRowClick="true">

 

 

<Scrolling AllowScroll="True" UseStaticHeaders="true" ScrollHeight="260" />

 

 

<Selecting AllowRowSelect="true" />

 

 

</ClientSettings>

 

 

<SortingSettings SortToolTip="" />

 

 

<ActiveItemStyle BackColor="#FFFFCC" />

 

 

<CommandItemStyle BorderColor="White" HorizontalAlign="Right" />

 

 

</telerik:RadGrid>

 

<

 

csla:CslaDataSource ID="dsParts" runat="server" TypeName="Cis.Cims.Library.Vendor"

 

 

 

 

 

TypeSupportsPaging="false" TypeSupportsSorting="true" OnSelectObject="dsParts_SelectObject">

 

 

 

 

 

</csla:CslaDataSource>

in Codebehind

 

 

protected void dsParts_SelectObject(object sender, Csla.Web.SelectObjectArgs e)

 

{

 

try

 

 

 

 

{

 

if (Page.IsPostBack)

 

{

e.BusinessObject = GetParts();

}

}

 

catch (Exception ex)

 

{

lblSystemMessage.Text = ex.Message;

}

}

 

private

 

InventoryInfoList GetParts()

 

{

 

InventoryInfoList invenInfoList = SessionHelper.SessionBusinessObjectsInfo.InventoryInfoListBusinessObject;

 

 

try

 

 

 

 

 

{

 

 

if (invenInfoList == null)

 

{

 

rgPParts.CurrentPageIndex = 0;

 

 

 

 

 

 

 

 

string PCategory = ClassificationMenu1.ClassificationText;

 

 

if (PCategory.ToUpper() == "ALL")

 

{

PCategory =

"";

 

}

 

 

 

 

 

invenInfoList =

InventoryInfoList.GetPartsBySearch(ddlVendor.SelectedValue, txtPartNumber.Text.Trim(), GlobalHelper.ReplaceEscapeChars(txtKeywords.Text.Trim()), Convert.ToInt32(ddlCondition.SelectedValue.Trim()), PCategory);

 

 

SessionHelper.SessionBusinessObjectsInfo.InventoryInfoListBusinessObject = invenInfoList;

 

 

 

 

 

}

 

catch (Exception ex)

 

{

 

throw ex;

 

}

 

return invenInfoList;

 

}

i dont know where i have made mistake any help on this will be greatly appreciated.

[Daniel]

Hello Prakash,

Please set the OverrideDataSourceControlSorting="true" to your MasterTableView:

<MasterTableView OverrideDataSourceControlSorting="true" ...>

I hope this helps.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Prakash]

Thanks Daniel :) Its working fine now...:)