Get Maximum value from a List of String using LINQ in C# and VB.Net

Hi nabilabolo,

Please refer below sample.

Note: For this sample i have used temporary DataTable. For more details refer How to create Temporary Table in ASP.Net using C# and VB.Net.

HTML

<asp:Label ID="lblMessage" runat="server"></asp:Label>

Namespace

C#

using System.Data;

VB.Net

Imports System.Data

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[1] { new DataColumn("RequesterId", typeof(string)) });
        dt.Rows.Add("FY21_997");
        dt.Rows.Add("FY21_998");
        dt.Rows.Add("FY21_999");
        dt.Rows.Add("FY21_1000");
        var result = from v in dt.AsEnumerable()
                        select Convert.ToInt32(v["RequesterId"].ToString().Split('_')[1]);
        lblMessage.Text = string.Format("Max Requester Id : <b>{0}</b>", result.Max().ToString());
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim dt As DataTable = New DataTable()
        dt.Columns.AddRange(New DataColumn(0) {New DataColumn("RequesterId", GetType(String))})
        dt.Rows.Add("FY21_997")
        dt.Rows.Add("FY21_998")
        dt.Rows.Add("FY21_999")
        dt.Rows.Add("FY21_1000")
        Dim result = From v In dt.AsEnumerable() Select Convert.ToInt32(v("RequesterId").ToString().Split("_")(1))
        lblMessage.Text = String.Format("Max Requester Id : <b>{0}</b>", result.Max().ToString())
    End If
End Sub

Screenshot