How to find max value of a column in a datatable?

Total Post:102


 2031  View(s)
Rate this:

I am trying to find the max value of a column in a datatable.

 Below is my code:-

var maxVal = dsloadReferralCodes.Tables["dtReferralCodesTable"].AsEnumerable().Max(r =>  Convert.ToBoolean(int.TryParse(r.Field<string>("ROWNUM"), out intROWNUM)) ? (int?)intROWNUM : null);

and below id the error i am getting while trying to get the max value and assigning it to intROWNUM

Unable to cast object of type 'System.Decimal' to type 'System.String'

Can someone help me in resolving the issue. This has been troubling me since long.

Thanks in advance...

  1. Re: How to find max value of a column in a datatable?

    Hi Mark,

    You can get it in simple manner with DataTable.Select() :

    DataRow [] dr =dsloadReferralCodes.Tables["dtReferralCodesTable"].Select("ROWNUM=
     if(dr !=null)
         // Console.WriteLine(dr[0]["RowNum"]);
            int maxVal=Convert.ToInt32(dr[0]["RowNum"]);

      Modified On Apr-04-2018 01:58:08 AM


Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.