Retrieve data from a dataset

Question

I have a dataset that is populated from a stored procedure on sql server. I have a column that allows a set of values ​​to be used. I do not know what these values ​​are. All I know is that they are of type string. I want to extract all individual values ​​from this column.

Answer 1

You can use the DataView and set the 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();

Answer 2

You can simply use the DataTable select method:

DataRow[] extractedRows = 
     yourDataSet.Tables["YourTableName"].Select("YourColumnName = 123");

Answer 3

Linq . MS - http://msdn.microsoft.com/en-us/vbasic/bb688086.aspx

Answer 4

I hope that the instruction below will serve your purpose

ds.Tables["TableName"].DefaultView.ToTable( true, "columnName"); //For Dataset (true means distinct)

OR

   `ds.Tables[0].DefaultView.ToTable( true, "columnName");

// For a dataset where tableindex is 0

OR

dt.DefaultView.ToTable( true, "columnName"); //For Datatable

//Syntax is like Datatable.DefaultView.ToTable( Distinct true/false, "ColumnName");

MSDN: http://msdn.microsoft.com/en-us/library/wec2b2e6.aspx