How to add value from sql table column in dataGridView predefined columns (without adding new columns)?

Question

0.00/5 (No votes)

See more:

i have a table like this

Period	EmployeeId	SubjectName	Class	Section	TDay
I   	E10001	            Math	IV	   A	Monday    
II   	E10002	            Math	V	   B	Tuesday   
IV   	E10002	            Math	I	   c	Monday    
V   	E10001	            Math	III	   A	Tuesday 
II   	E10001	            Math	II	   c	Monday

and i want these data in datagridveiw like this

empid=E10001

period     I               II           III        IV        V
Monday   class IV A      class II c      
Tuesday                                                   class III c

how could i access data like this through code in my datagridveiw?

Posted 4-Aug-12 6:23am

143Deepak

Add a Solution

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)

Sandeep Mewara · Answer 1 · 2012-08-04T10:23:00

Solution 1

Read aboutSQL PIVOT:
Using PIVOT and UNPIVOT[^]
Understanding PIVOT and UNPIVOT[^]
Pivoting data in SQL Server[^]

Try!

Posted 4-Aug-12 10:23am

Sandeep Mewara

Comments

143Deepak 7-Aug-12 5:18am

but sir to pivot a table ,the column should be integer on which the aggregations will be applied and i have all of my column in char or varchar.

i tried much after reading your solution but did not get what i want.

know what to do?