Member Avatar for mistyfy_t

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??

  • 2 Contributors
  • 1 Reply
  • 89 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by finito
Member Avatar for finito

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.