[Solved] RadGrid Sorting Behaviour

[Adrian Eng Ying Ming]

Hi,
    i have a scenario where i use the grid inbuilt sorting inbuilt sorting behaviour:

<sortexpressions>
        <telerik:gridsortexpression fieldname="Sort" sortorder="Ascending" />
</sortexpressions>

i got an undersired behaviour instead of having row sorting from 1- 15, i get 1-10-15- 2-9. as seen in the attached a screen shot.

Regards;
Adrian

[Pavlina]

Hello Adrian,

Could you please elaborate a bit more on the described issue? How are you populating the grid control with data?

Regards,
Pavlina
the Telerik team

[Adrian Eng Ying Ming]

hi Pavlina ,
here is the sample code to duplicate the error

       protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
        {
            RadGrid1.DataSource = Getdata();
        }

        private object Getdata()
        {
            if (ViewState["Data"] == null)
            {
                DataTable dt = new DataTable();
                dt.Columns.Add(new DataColumn("SortOrder"));
                dt.Columns.Add(new DataColumn("ValueCol"));
                object[] a;
                for (int b = 1; b <= 10; b++)
                {
                    a = new object[] { b, "Value : " + b };
                    dt.Rows.Add(a);
                }
                ViewState["DataTable"] = dt;
            }
            return ViewState["DataTable"];
        }

      <telerik:radgrid id="RadGrid1" runat="server" onneeddatasource="RadGrid1_NeedDataSource">
            <mastertableview clientdatakeynames="SortOrder, ValueCol">
                <sortexpressions>
                    <telerik:gridsortexpression fieldname="SortOrder" sortorder="Ascending" />
                </sortexpressions>
            </mastertableview>
            <clientsettings allowrowsdragdrop="true">
                <selecting allowrowselect="true" enabledragtoselectrows="false" />
            </clientsettings>
        </telerik:radgrid>

Regards,
Adrian

[Pavlina]

Hi Adrian,

Please note that the described behavior is expected when you are sorting string values. To achieve the desired functionality your column could be of type int as demonstrated in the attached project.

I hope this helps.

Best wishes,
Pavlina
the Telerik team