How do I logically work with List<Tuples>

Question

0.00/5 (No votes)

See more:

Hi Geeks,

I just stuck up with a logic. Can someone help me to figure out the logic.
The problem is ...

In Gridview,

HTML

Combo        SIZE     RATIO
 1            50        1
 1            56        2
 1            62        1
 2            56        1
 2            62        2
 2            68        2

So there only 2 combos(1,2) and 4 sizes( 50,56,62,68) and I need to show the report like this.

HTML

Combo    50   56   62   68(Depends on gridview addition)
  1      1     2    1    -
  2      -     1    2    2

No duplicates allowed ....

I used List<tuple> and stored all values like key value pair. Is there any logic to find out ???

Posted 7-Jul-14 23:39pm

Sriram Ramachandran

Add a Solution

Comments

DamithSL 8-Jul-14 5:50am

how you store data? can you update the question with that code?

Sriram Ramachandran 8-Jul-14 6:02am

I didnt save the data. Just wanna see the details before saving to the DB. Just displaying whatever typed in Gridview

jo.him1988 8-Jul-14 6:35am

hi if grid view data is bind from database table than pivot is the answer :)
SELECT * from (select Combo,[Size], ratio FROM PivotTesting)as s
PIVOT(Sum( ratio)FOR [Size] IN([50],[56],[62],[68]))AS test

output
Combo 50 56 62 68
1 1 2 1 null
2 null 1 2 2

happy coding :) :)

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)

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 1 · 2014-07-08T00:05:00

Solution 1

Yeah you can do this using those key value pairs. But that is not an efficient solution.

I would suggest you to refer the article - Pivoting DataTable Simplified[^] and implement the same.

Posted 8-Jul-14 0:05am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)