Select distinct rows from datatable in Linq

Question

I am trying to get distinct rows based on multiple columns  attribute1 name  attribute2 name  and get datarows from datatable using Linq-to-Dataset     I want results like this  attribute1 name    attribute2 name --------------     ---------------  Age                State Age                weekend percent Age                statebreaklaw Age                Annual Sales Age                Assortment   How to do thin Linq-to-dataset

User · Answer

Check this link

get distinct rows from datatable using Linq (distinct with mulitiple columns)

Or try this

var distinctRows = (from DataRow dRow in dTable.Rows
                    select new  {  col1=dRow["dataColumn1"],col2=dRow["dataColumn2"]}).Distinct();

EDIT: Placed the missing first curly brace.

User · Answer

var Test    from row in Dataset1 Tables 0  AsEnumerable               select row Field lt string gt   attribute1 name     row Field lt int gt   attribute2 name    Distinct

User · Answer

We can get the distinct similar to the example shown below      example            var  distinctValues    DetailedBreakDown Table AsEnumerable   Select r   gt  new                               InvestmentVehicleID   r Field lt string gt   InvestmentVehicleID                    Universe   r Field lt string gt   Universe                    AsOfDate    imqDate                  Ticker                       Cusip                       PortfolioDate   r Field lt DateTime gt   PortfolioDate                    Distinct

User · Answer

If it s not a typed dataset  then you probably want to do something like this  using the Linq-to-DataSet extension methods   var distinctValues   dsValues AsEnumerable                            Select row   gt  new                               attribute1 name   row Field lt string gt   attribute1 name                                attribute2 name   row Field lt string gt   attribute2 name                                                        Distinct      Make sure you have a using System Data  statement at the beginning of your code in order to enable the Linq-to-Dataset extension methods   Hope this helps

User · Answer

Like this    Assuming a typed dataset   someTable Select r   gt  new   r attribute1 name  r attribute2 name    Distinct

User · Answer

Dim distinctValues As List Of Double     From r In   DirectCast DataTable AsEnumerable   IEnumerable Of DataRow   Where  Not r IsNull  ColName      Select r Field Of Double   ColName    Distinct   ToList

[c#] Select distinct rows from datatable in Linq

Examples related to c#

Examples related to vb.net

Examples related to linq

Examples related to linq-to-dataset