extract data from a dataset

Question

I have a dataset that gets populated from a stored proc in sql server. I have a column that has lets say has a set of values. I do not know what those values are. All I know is that they of the type "string". I want to extract all the distinct values from that column.

Answer 1

You can use a DataView and set its RowFilter to the desired condition:

var view = new DataView(dataset.Tables["Table"]);
view.RowFilter = "Column = 42";

UPDATE: based on your updated question, you can use LINQ:

var table = dataset.Tables["Table"].AsEnumerable();
var distinctValuesForColumn = 
  table.Select(row => (string)row["Column"]).Distinct();