show a cross table in datagridview in visual c#

Question

5.00/5 (1 vote)

See more:

hi,

I have 3 tables that they are student table, lesson and result. What that I want to do is that I want to show student name and family in row and show lesson name in columm header and show student lesson grade how can I do this in DataGridView?

Thanx for your help

Posted 4-Mar-11 4:32am

sadegh_sh

Updated 4-Mar-11 4:57am

Henry Minute

v2

Add a Solution

3 solutions

Solution 1

Yes you can do it. What you looking for is called Join Here is very brief intro http://www.w3schools.com/sql/sql_join.asp[^]

the example assumes what your tables may look like. You need to adjust it to fit your design.

SQL

SELECT first_name, family_name, lesson_name 
FROM students s
INNER JOIN lessons l
ON s.id = l.id

Posted 4-Mar-11 4:41am

Yusuf

Comments

Manas Bhardwaj 4-Mar-11 11:03am

OP said:
that was not my mean I want to make a cross table in datagridviw with 3 tables

Solution 3

You can use join query as Ysuf said (join the three tables using parent child relationship) and on the result of the join query use a pivoting query. That result can be bind to the gridview.

Here is an example of pivot query.

http://www.mssqltips.com/tip.asp?tip=1019[^]

Posted 4-Mar-11 5:54am

Albin Abel

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)

DrNimnull · Accepted Answer · 2011-03-04T05:59:00

Solution 4

Hi,

look at this Article:
C# Pivot Table[^]

Hope that helps.

Posted 4-Mar-11 5:59am

DrNimnull