使用C#在数据表中查找最小值和最大值

using System;
using System.Data;
using System.Linq;

class Program
{
    static void Main()
    {
        DataTable table = new DataTable();
        table.Columns.Add("Value", typeof(int));
        table.Rows.Add(10);
        table.Rows.Add(20);
        table.Rows.Add(30);
        table.Rows.Add(40);

        int minValue = table.AsEnumerable().Min(row => row.Field<int>("Value"));
        int maxValue = table.AsEnumerable().Max(row => row.Field<int>("Value"));

        Console.WriteLine($"Minimum Value: {minValue}");
        Console.WriteLine($"Maximum Value: {maxValue}");
    }
}

using System;
using System.Data;

class Program
{
    static void Main()
    {
        DataTable table = new DataTable();
        table.Columns.Add("Value", typeof(int));
        table.Rows.Add(10);
        table.Rows.Add(20);
        table.Rows.Add(30);
        table.Rows.Add(40);

        int minValue = (int)table.Compute("MIN(Value)", "");
        int maxValue = (int)table.Compute("MAX(Value)", "");

        Console.WriteLine($"Minimum Value: {minValue}");
        Console.WriteLine($"Maximum Value: {maxValue}");
    }
}