how to show summary of thr result in a particular format?

Question

0.00/5 (No votes)

See more:

Hello ,
I am recieving some data from the service . It's in this format

WareHouse   WareHouseType    Type     

AAA             1             11
AAA             1             12
AAA             1             13
AAA             1             12
BBB             1             11
AAA             1             12
AAA             1             12
BBB             1             11
BBB             1             12

Now i need result in this format

warehouse      WareHouseType    Type   Count
AAA               1              11     1
AAA               1              12     4
AAA               1              13     1
BBB               1              11     2
BBB               1              12     1

any suggestion how to achive this ?? I tried search about grouping inside datatable but no luck..

Posted 23-Sep-15 1:55am

Riya-Pandey

Updated 23-Sep-15 2:03am

v2

Add a Solution

Comments

[no name] 23-Sep-15 8:07am

In which format you are getting the result from the service? in which container you are keeping this?

Riya-Pandey 23-Sep-15 8:10am

I am inserting this data into a datatable.

[no name] 23-Sep-15 8:21am

Please see my solution. If you have any query let me know.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sisir Patro · Answer 1 · 2015-09-23T02:20:00

Hi,

I can suggest you one way. This might not be a solution but you can try. I am sure there would be more such type of solutions.

If your data is in DataTable format then you can follow the following steps to get the required result.

1.) Import the DataTable to a database table (Temporary table).
2.) Once the data is imported to the table you can use the "Partition By" clause based on your data to be sorted out.
3.) Put a count in the query for the partitioned by column and get the last column reformed.

For references:
Partition By
Inserting a datatable to DB

Hope this will help you in achieving the goal. This is one of the way you can achieve your task. There may be many more.

Thanks,
Sisir Patro