如何从数据表c#的输入创建范围

string connectionString = "your_connection_string";
string query = "SELECT * FROM your_table";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    SqlCommand command = new SqlCommand(query, connection);
    connection.Open();
    SqlDataReader reader = command.ExecuteReader();
    while (reader.Read())
    {
        // 处理每一行数据
    }
    reader.Close();
}

List<int> numbers = new List<int>();
while (reader.Read())
{
    int number = reader.GetInt32(0); // 假设第一列是数字列
    numbers.Add(number);
}
Range<int> numberRange = new Range<int>(numbers.Min(), numbers.Max());