Click here to Skip to main content
15,891,864 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
XML
hello good evening all of you . i want bind dynamically student name  in row and Subject as column wise with marks ,so i am providing some 3 table and result   structure .please help me anyone.
table 1-tbl_Student

Student_id  student Id    

5           B            
6           C             
7           D             
8           E             
tbale 2-tbl_Subject-
Subject_Id  Subject   

1           hindi            
2           english             
3           match             
4           physics     

table 3-tbl_marks

Student_id  Subject_Id    marks

5           1              20
6           2              50
7           4              48
8           1              30



Result

bind all the student in row wise and subject bind as dynamic header .marks should  be also bind with student and subject relatives.
             
                   Subject_Id(1)      Subject_Id(2)     Subject_Id(4)
Student_Id(5)       20
Student_Id(6)                             50
Student_Id(7)                                            48   
Student_Id(8)        30





        </pre>
Posted
Updated 29-Aug-14 0:52am
v2

1 solution

You can create a Dynamic Pivot for these BI questions.
See my article[^] about dynamic pivotting to understand how it can be done
 
Share this answer
 
Comments
Bhavik_Patel 29-Aug-14 7:46am    
Dynamic Pivoting is best answer for this problem... good suggestion.
manvendra patel 3-Sep-14 2:16am    
thanks both of you ,i have solved this problem using PIVOT method.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900