How to get max value from datatable having string column datatype

[Anil_Potekar]

I have statement data in datatable using screen scraping all column in string data type, I want to get max debit entry from debit column with remaining balance from bal. Column.

[pawanrajpurohit]

Hello ,

you can use linq using this format

var maxValue = table.Max(x => x.Status)
var result = table.First(x => x.Status == maxValue);

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

Hi @Anil_Potekar

Please have a look at the below workflow
Main.xaml (15.2 KB)

[arivu96 (Arivazhagan A)]

Hi @Anil_Potekar ,
you can use below query to get max value of the column
int MaxValue=Convert.ToInt32(dt.AsEnumerable().Max(Function(row) Convert.ToInt32(row("Column2"))))

Regards,
Arivu

[Anil_Potekar]

I’m facing this error
Max is not a member of system.data.Enumerablerowcollextion(of system.data.datarow)

[Anil_Potekar]

It’s shows error
Assign: input string was not in a correct format

[arivu96 (Arivazhagan A)]

Hi @Anil_Potekar ,

@arivu96

int MaxValue=Convert.ToInt32(dt.AsEnumerable().Max(Function(row) Convert.ToInt32(row(“Column2”))))

I checked its working fine for me
try below one
int maxval = Convert.ToInt32(dt.Compute("max([ColumnNmae])", string.Empty))

Regards,
Arivu

[arivu96 (Arivazhagan A)]

@Anil_Potekar

Max is not a member of system.data.Enumerablerowcollextion(of system.data.datarow)

please refer below post to fix the issue

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.

Regards,
Arivu

[Anil_Potekar]

Facing this error
Assign invalid usage of aggregate function Max ()and type: object