linq to filter records

Hi,

In excel i have read and created data table with columns and rows as shown

so i want to get [Ticket Status - Unsorted] and store in variable

I tried like this

var dataRow = from customer in dt.AsEnumerable()

where customer.Field("Insights value") ==' # Tickets'

select new

{

strInsightsvalue = customer.Field("Insights value"),

strExplorerValue = customer.Field("Explore value"),

strExploreAggregate = customer.Field("Explore Aggregator")

};

it show dataRow=null

or i tried below one

var dataRow = dt.AsEnumerable().Where(x => x.Field("Explore Aggregator") == '# Tickets').FirstOrDefault();

using Datatable for each will take more time , so please help

1 Reply

Know the answer? Post it — somebody with the same question will find it here.