如何选择数据表中列的最小值和最大值? [英] How to select min and max values of a column in a datatable?

问题描述

对于以下数据表列，获取最小值和最大值的最快方法是什么?

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

AccountLevel  
0  
1  
2  
3 

推荐答案

int minAccountLevel = int.MaxValue;
int maxAccountLevel = int.MinValue;
foreach (DataRow dr in table.Rows)
{
    int accountLevel = dr.Field<int>("AccountLevel");
    minAccountLevel = Math.Min(minAccountLevel, accountLevel);
    maxAccountLevel = Math.Max(maxAccountLevel, accountLevel);
}

是的，这确实是最快的方式.使用 Linq Min 和 Max 扩展总是比较慢，因为你必须迭代两次.您可能会使用 Linq Aggregate，但语法不会比现在更漂亮.

Yes, this really is the fastest way. Using the Linq Min and Max extensions will always be slower because you have to iterate twice. You could potentially use Linq Aggregate, but the syntax isn't going to be much prettier than this already is.

这篇关于如何选择数据表中列的最小值和最大值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！