要获取列名：

myTable.Columns.Cast<DataColumn>().Select(dc =>dc.ColumnName).ToList();

The problem is Select() is projecting the objects into a new form. You are seeing 2018 because of '=' instead of '=='. You need to use Where()

var linqTable = myTable.AsEnumerable().Where( x => x.Field<int>(0) == 2018);

You will still end up with a list of DataRows though. The DataTable object isn't really what you should be using because it already provides a nice way to filter its rows:

myTable.Rows.Find(2018);

If you are trying to convert it to a list of objects you should use the Select() method something like:

var linqTable = myTable.AsEnumerable().Where(x => x.Field<int>(0) == 2018)
            .Select(x => new
            {
                year = x[0],
                p1 = x[1],
                p2 = x[2] // etc...
            });

您可以创建以下函数：

public static DataTable CreateDataTableFromAnyCollection<T>(IEnumerable<T> list)
    {
        Type type = typeof(T);
        var properties = type.GetProperties();

        DataTable dataTable = new DataTable();
        foreach (PropertyInfo info in properties)
        {
            dataTable.Columns.Add(new DataColumn(info.Name, Nullable.GetUnderlyingType(info.PropertyType) ?? info.PropertyType));
        }

        foreach (T entity in list)
        {
            object[] values = new object[properties.Length];
            for (int i = 0; i < properties.Length; i++)
            {
                values[i] = properties[i].GetValue(entity,null);
            }

            dataTable.Rows.Add(values);
        }

        return dataTable;
    }

并传递LINQ查询返回的任何类型的对象。

DataTable dt = CreateDataTableFromAnyCollection(query);

希望这对你有帮助。
Creating a DataTable From a Query (LINQ to DataSet)