how to filter a datatable row with same value using linq

Question

this is my data from db name date amnt id a 2070-06-11 1000 23 b 2070-07-11 100 35 a 2070-06-11 1000 23 c 2070-08-11 100 46 d 2070-02-11 100 50 how to filter a datatable row with same value using linq in c# i want this model name date amnt id a 2070-06-11 1000,1000 23 b 2070-07-11 100 35 c 2070-08-11 100 46 d 2070-02-11 100 50 plz help me. thnkx in advn

Sivakumar Koneti · Answer

read below link and follow you can get solution https://stackoverflow.com/questions/19449449/how-i-can-filter-a-datatable-with-linq-to-datatable

Mohsin Arif · Answer

hey try this select tbl2.id, sum (tbl2.amnt) Amount, tbl2. name from ( select * from ( select 'a' as name , '2070-06-11 ' as datet, 1000 as amnt, 23 as id Union All select 'b' as name , '2070-07-11 ' as datet, 100 as amnt, 35 as id Union All select 'a' as name , ' 2070-06-11' as datet, 1000 as amnt, 23 as id Union All select 'c' as name , ' 2070-08-11' as datet, 100 as amnt, 46 as id Union All select 'd' as name , ' 2070-02-11' as datet, 100 as amnt, 50 as id )tbl) tbl2 group by tbl2.id , name

Mohsin Arif · Answer

so send me this Query or Code i see then try to solve this

Reylin Mathew · Answer

Mohsin Arif select id,name,amnt,date from demo

Reylin Mathew · Answer

Mohsin Arif yes

Mohsin Arif · Answer

ok send me code

Mohsin Arif · Answer

Reylin Mathew how you get this records name date amnt id a 2070-06-11 1000 23 b 2070-07-11 100 35 a 2070-06-11 1000 23 c 2070-08-11 100 46 d 2070-02-11 100 50 with this some query ,

Reylin Mathew · Answer

Mohsin Arif, query is not posible.. so i use only code behind.

Mohsin Arif · Answer

if you want same like as you present or sum same id values if sum same id values then use group by , send my your Query i will set this