I think the best solution is to add two parameters in the stored procedure,one for the column(field) name and the other one specify whether sorting is ASC/DESC.

If you don't want to do this, then you can add these lines in your code behind.


DataTable dTablePropertyList = new DataTable(); // declaring new datatable

//setting cloumn name and datatype
    foreach(DataColumn dColumnProperty in dSetPropertyList.Tables[0].Columns)
    {
        if(dColumnProperty.ColumnName.ToString().Trim().To Upper() == "VIEWEDCOUNT")
        {
            dTablePropertyList.Columns.Add(dColumnProperty.Col umnName,System.Type.GetType("System.Int32"));
        }
        else
        {
            dTablePropertyList.Columns.Add(dColumnProperty.Col umnName,dColumnProperty.DataType);
        }
    }
//adding rows to datatable
    foreach(DataRow dRowPropertyin dTablePropertyList.Tables[0].Rows )
    {
        DataRow dRow = dTablePropertyList.NewRow();
        dRow[0] = dRowProperty[0];
        dRow[1] = dRowProperty[1];
        dRow[2] = dRowProperty[2];
        dRow[3] = dRowProperty[3];
        dRow[4] = dRowProperty[4];
        dRow[5] = dRowProperty[5];
        dRow[6] = dRowProperty[6];

        dTablePropertyList.Rows.Add(dRow);
    }
DataView dViewPropertyList = new DataView(dTablePropertyList);

//


dViewPropertyList.Sort=Session["sortExpProperty"] + " " + Session["sortExpPropertyOrder"];

dGridProperty.DataSource = dViewPropertyList ;
dGridProperty.DataBind();



         hope this will help:)

I am having the same problem. I have checked the data type of the field in the data view and it is an integer. However, it will not apply a numeric sort. I did find one stranage thing. If I left of the asc or desc and only specified the field name in the sort command like (.sort = "field1") instead of (.sort = "field1 asc"), it performed a numeric sort. But as soon as I add the asc or desc part, it does a string sort. I just wondering if it does the same for you.

Ken Morman

Your datatable's fields are text fields by default. In a text field 15 is smaller than 20. When you define your datatable, make sure you define the datatype as being integer like the following, then it will sort correctly.

SurveyQAArray.Columns.Add("intQSortOrder", GetType(Integer))