linq to search datatable

Question

I want to write a linq to search datatTable to return the Itemname who does not have atleast one tax applied My datatable structure is ItemName cst 2% vat 2% sale tax excise Item1 TRUE TRUE Item2 TRUE Item3 my output should be Item3 please suggest me the solution

Devendra Dighe · Answer

My Datatable structure is ItemName cst2% vat5.5% ...... columns are dynamic count increases Item1 NULL NULL Item2 TRUE TRUE Item3 NULL TRUE Item4 NULL NULL Output should be Item1 Item4

Manas Mohapatra · Answer

Please provide DataTable structure properly with sample data and output also.. http://www.codeproject.com/Questions/86951/Linq-Query-to-DataTable

Bikesh Srivastava · Answer

its not any big deal. Just write one line of code. var data=from c in _dbcontext.tblname where c.fieldname eqals param.filedname select c;

Rajeev Punhani · Answer

Hi Devendra Please see the below link. https://dotnetfiddle.net/rzALwE

ItemName	cst 2%	vat 2%	sale tax	excise
Item1	TRUE		TRUE
Item2		TRUE
Item3