Display values in gridview from multiple tables

Question

0.00/5 (No votes)

See more:

Hi I need immediate help guyssssss. The scenario is like this:
I have 3 tables: subject,class and mark which have details subjectid,subject in subject; classid, classname in class; markid, classid,subjectid,marks in mark.
I want to display the details in a form like class forms the header text vertically, subject horizontally and marks corresponding to (class,subject).
Below is the required output/gridvew...i tried lots of ways..not working..

Class/Subject	Class 5 Class 6 Class 7
abcd              66      62	  56	 Delete
efg               77      77      55     Delete
rst               56      87      98     Delete

Posted 4-Jun-13 16:44pm

Sindhu Namboodiri

Updated 4-Jun-13 20:08pm

_Amy

v2

Add a Solution

Comments

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 4-Jun-13 23:09pm

Can you post what you have tried so far?

ExpertITM 5-Jun-13 0:03am

You have to use pivoting in sql server

vaibhav10Dec1987 5-Jun-13 1:47am

if you are using a sql server database for fetching these record, then why r you not using join? Or Can you post a code in which what you have done.

VishwaKL 5-Jun-13 2:18am

yes Vaibhav you are right, he should use joins for his query

Member 7677029 5-Jun-13 6:39am

how can we use join...i am not getting in this form while using join..i mean i want the output like the design i have shown..can u pl give me an example? suppose the tables are subject,class,marks; how to get data shown as in figure????

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)

Member 7677029 · Answer 1 · 2013-06-04T23:55:00

Solution 1

how can we use join...i am not getting in this form while using join..i mean i want the output like the design i have shown..can u pl give me an example? suppose the tables are subject,class,marks; how to get data shown as in figure????

Posted 4-Jun-13 23:55pm

Member 7677029