How to select min and max values of a column in a datatable?

c# .net select datatable
Ahmed Atia picture Ahmed Atia · Mar 14, 2010 · Viewed 204.2k times · Source

For the following datatable column, what is the fastest way to get the min and max values?

AccountLevel  
0  
1  
2  
3

Answer

Lalit picture Lalit · Feb 7, 2011

Easiar approach on datatable could be:

int minLavel = Convert.ToInt32(dt.Compute("min([AccountLevel])", string.Empty));

Related questions

yield return versus return select

Which are the advantages/drawbacks of both approaches? return items.Select(item => DoSomething(item)); versus foreach(var item in items) { yield return DoSomething(item); } EDIT As they are MSIL roughly equivalent, which one you find more readable?

Read More
How to make an HTTP POST web request

Canonical How can I make an HTTP request and send some data using the POST method? I can do a GET request, but I have no idea of how to make a POST request.

Read More
How can I convert String to Int?

I have a TextBoxD1.Text and I want to convert it to an int to store it in a database. How can I do this?

Read More