Sort String Collection containing Numbers using LINQ in ASP.Net

Hi nauna,

It's because you are sorting them as strings and for strings 1000 comes before 101. You'll need to convert the acode to int value and then sort by that.

Check the below code.

C#

protected void Page_Load(object sender, EventArgs e)
{
    List<Data> datas = new List<Data>();
    datas.Add(new Data { acode = "1" });
    datas.Add(new Data { acode = "2" });
    datas.Add(new Data { acode = "100" });
    datas.Add(new Data { acode = "1000" });
    datas.Add(new Data { acode = "101" });
    datas.Add(new Data { acode = "102" });
    datas.Add(new Data { acode = "103" });

    var result = datas.OrderBy(u => Convert.ToInt32(u.acode));
}

public class Data
{
    public string acode { get; set; }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim datas As List(Of Data) = New List(Of Data)()
    datas.Add(New Data With {.acode = "1"})
    datas.Add(New Data With {.acode = "2"})
    datas.Add(New Data With {.acode = "100"})
    datas.Add(New Data With {.acode = "1000"})
    datas.Add(New Data With {.acode = "101"})
    datas.Add(New Data With {.acode = "102"})
    datas.Add(New Data With {.acode = "103"})
    Dim result = datas.OrderBy(Function(u) Convert.ToInt32(u.acode))
End Sub

Public Class Data
    Public Property acode As String
End Class

Output

1

2

100

101

102

103

1000