How to create Pivot table using C#?

Question

I need to create a pivot like this

                     BatchID-1        BatchID-2
                     BachName-1       BachName-2

Chemical-1             0.1                null
Chemical-2             null                0.3

BatchID,BatchName are columns of the Sql Server Table. Here i need to display the value of specific chemical if Specific BatchID and BatchName

Can any one please help me.

Thank You

Please post the code you have written so far. People generally do not like to just write your code for you. — Mitch Wheat
– Mitch Wheat, Commented Mar 17, 2010 at 10:57
I just write code for Normal pivot table. I did not any code for this Pivot table. — vamshi
– vamshi, Commented Mar 17, 2010 at 11:06
Do you already have it in a "DataTable" object? Is the data coming down from some SQL database... Where is its origin? — DRapp
– DRapp, Commented Mar 17, 2010 at 11:10

SerialSeb · Accepted Answer · 2010-04-13 17:07:09Z

4

I suggest leaning a bit of SQL, a bit of C# and a bit about pivot table. Then write some code. Preferably, make it compile.

Once you know all these things, you'll probably be able to ask a more precise question, such as "Using the Xxx Pivot control, I try to read data from SQL server using this SQL query and try to populate the data, but I encounter this specific issue..."

At that point, stackoverflow will probably be helpful in answering your question. Until then, I don't think anyone is going to give you the code you require, as writing code is probably what you should be doing yourself to learn (if student), grow (if amateur) or get paid (professional).

answered Apr 13, 2010 at 17:07

SerialSeb

6,76626 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Thomas Levesque · Accepted Answer · 2010-03-17 11:45:20Z

0

Use a control such as XtraPivotGrid (DevExpress), or some free alternative

answered Mar 17, 2010 at 11:45

Thomas Levesque

294k73 gold badges639 silver badges769 bronze badges

2 Comments

vamshi Over a year ago

Can you please tell me those free alternatives?

Thomas Levesque Over a year ago

They're just hypothetical free alternatives, I actually don't know any of them...

Kirk Broadhurst · Accepted Answer · 2010-03-17 12:06:19Z

0

Write a stored procedure, or a LINQ statement.

answered Mar 17, 2010 at 12:06

Kirk Broadhurst

28.9k20 gold badges111 silver badges179 bronze badges

Collectives™ on Stack Overflow

How to create Pivot table using C#?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related