Why No LINQ?  For people coming here without the same restriction, here are three ways to do this, the bottom two both using LINQ.

**C#**



    List<object> colValues = new List<object>();

    //for loop
    foreach (DataRow row in dt.Rows) {
        colValues.Add(row["ColumnName"]);
    }

    //LINQ Query Syntax
    colValues = (from DataRow row in dt.Rows select row["ColumnName"]).ToList();

    //LINQ Method Syntax
    colValues = dt.AsEnumerable().Select(r => r["ColumnName"]).ToList();

**VB**



    Dim colValues As New List(Of Object)

    'for loop
    For Each row As DataRow In dt.Rows
        colValues.Add(row("ColumnName"))
    Next

    'LINQ Query Syntax
    colValues = (From row As DataRow In dt.Rows Select row("ColumnName")).ToList

    'LINQ Method Syntax
    colValues = dt.Rows.AsEnumerable.Select(Function(r) r("ColumnName")).ToList

To use the `AsEnumerable` method on a `DataTable`, you'll have to have a Reference to System.Data.DataSetExtensions which add the [LINQ extension methods](http://msdn.microsoft.com/en-us/library/system.linq.enumerable.aspx).  Otherwise, you can just cast the `Rows` property of the `DataTable` as type `DataRow` (you don't have to do this with the Query syntax because it automatically casts for you).

In C#, is it possible to get all values of a particular column from all rows of a DataSet with a simple instruction (no LINQ, no For cicle)?

Get all values of a column from a DataSet

The accepted answer is mostly complete, but will not fully resolve the issue.  
Here's a reproduction of my [question and answer on this issue][SO Question].

### The Problem:

In short, the problem occurs when the `MSDataSetGenerator` tool runs, but the `System.Data.DataSetExtensions` assembly has not yet been loaded into the current Visual Studio process.  

### The Solution: 

One way to load the assembly is just to open any XSD file and *THEN* re-generate the designer code.

The following steps should generate the appropriate designer file:

1. Open any XSD file to the designer view (this loads DataSetExtensions.dll)
2. Right Click on the XSD and Select `Run Custom Tool`

**Here's a full [step by step walkthrough of the issue and solution with pictures][walkthrough]**


### Other Instances:

This problem has also been reported to Microsoft in the following bug tickets:

* [#668724 - MSDataSetGenerator generates incorrect output sometimes][MS 668724]
* [#733077 - MSDataSetGenerator does not generate TypedTableBase<T> derived classes][MS 733077]


[MS 668724]: http://connect.microsoft.com/VisualStudio/feedback/details/668724/
[MS 733077]: http://connect.microsoft.com/VisualStudio/feedback/details/733077/
[SO Question]: https://stackoverflow.com/q/23661756/1366033

[walkthrough]: http://imgur.com/a/H9nwo



I'm migrating our DAL class library to .NET 4 (from .NET 3.5). We're using typed datasets quite often, and we often iterate over tables:

    foreach(var row in ds.MyTable) var tmp = row.ID;

This does not work anymore, as the designer changes the dataset's code so that tables do not derive from `TypedTableBase<T>` anymore, but from `DataTable` (and implement the non-generic `IEnumerable`). That's what the diff shows. Therefore, the row is of type `object` at compile-time.

Does anybody know if this is the usual behavior? At the moment, I'm doing it the way shown below, but I hope there's a more elegant solution:

    foreach(var row in ds.MyTable.Cast<MyDs.MyRow>()) var tmp = row.ID;
