how to filter a datatable row with same value using linq

Reylin Mathew

7y1.6k.NET

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

9 Replies

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

Mohsin Arif7y ago
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
0
Mohsin Arif7y ago
so send me this Query or Code i see then try to solve this
0
Reylin Mathew7y ago

Mohsin Arif

select id,name,amnt,date from demo
0
Reylin Mathew7y ago
Mohsin Arif

yes
0
Mohsin Arif7y ago
ok send me code
0
Mohsin Arif7y ago
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 ,
0
Reylin Mathew7y ago
Mohsin Arif,
query is not posible..
so i use only code behind.
0
Mohsin Arif7y ago
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
0
Sivakumar Koneti7y ago
read below link and follow you can get solution

https://stackoverflow.com/questions/19449449/how-i-can-filter-a-datatable-with-linq-to-datatable
+1

how to filter a datatable row with same value using linq

Mohsin Arif

Reylin Mathew