Hi all,

country state area citizenCode income
------- ----- ----- ----------- ------
001 001 001 0001 1000
001 001 001 0001 500
001 001 001 0002 1000
001 002 001 0001 1000

i got such data table. i wish to generate a query for table adapter that wound able to sum then total income according to the citizen in the same country, state, area. Mean the result would be

country state area citizenCode income
------- ----- ----- ----------- ------
001 001 001 0001 1500
001 001 001 0002 1000
001 002 001 0001 1000

since too many selected fields, in my query it dint sum up the total income for first 2 records.

how should the queary looks like??

What does it look like now.

Post your code/query.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.