将数据表对象转换为列表C#

DataTable dataTable = new DataTable();

string connectionString = "your_connection_string";
string query = "SELECT * FROM your_table";
using (SqlConnection connection = new SqlConnection(connectionString))
{
    using (SqlCommand command = new SqlCommand(query, connection))
    {
        connection.Open();
        SqlDataAdapter adapter = new SqlDataAdapter(command);
        adapter.Fill(dataTable);
    }
}

List<YourDataType> list = new List<YourDataType>();

foreach (DataRow row in dataTable.Rows)
{
    YourDataType item = new YourDataType();
    // 将数据从数据行中提取并赋值给item对象的属性
    // 例如：item.Property1 = (YourDataType)row["column1"];
    //      item.Property2 = (YourDataType)row["column2"];
    //      ...
    list.Add(item);
}