How to sort numeric and string value in dataview

[garfield1]

I Need to set the values which will be having numeric as well as string values. such as 1,2 ,3 and like xc1,xc2. And willing to sort out these values by the numbers first and then the string values, but sorting these value would be displayed in dataview or datatable, I have tried out this and search lot related to this on the internet but endup with the clueless. And also let me know Is there any way to use IComparable interface to sort dataview data.

Thanks to those who help.

[X-Ray]

I think these numbers are being sorted as a string. If you add a simple XML file with no schema (with int and string elements) to the Data Source Catalog and open the Sort & Group dialog for the Data View you get the choice of sorting on elements containing numeric values as numeric values - and not as strings.check whether you have taken the datatype of datafield as integer or long. If not try this and tell me what happens....

[RichiRich]

I am wondering whether you solve this problem, because I have the same
issue as you.

Select the desired sort field in the dialog.
Edit the XSL - look for the dvt_1.body template, find the xsl:for-each and the
In my situation, I receive a xml file where one node is decimal or
empty. for example
<price>11</price>
<price>2</price>
xsl:sort within it that selects your sort field - add the attribute data-type="number"

[Astro121]

Could you please check if the SCE agent on those problemaic Windows XP is 6.06278.0? You will find this information from add/remove program. In VB.NET, the syntax for sorting is :
Dataview.Sort = "Sort-Order Desc/Asc"
That's why I asked you to enclose it in quotes. Anyways, the solution could be something else. I will suggest using a slightly different Profile Provider than what comes in ASP.NET by default.