如何绑定行中的动态数据以及asp.net中列中的动态数据？ [英] how to bind dynamic data in row and as well as dynamic data in column in asp.net ?

问题描述

大家好晚上好。我想要动态绑定行中的学生姓名和主题列与标记，所以我提供了一些3表和结果结构。请帮助我任何人。 
表1-tbl_学生
 
 Student_id学生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标记
 
 5 1 20 
 6 2 50 
 7 4 48 
 8 1 30 
 
 
 
结果
 
将所有学生按行绑定并将主题绑定为动态标题。标记也应与学生和主题亲属绑定。 
 
 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  >  

解决方案

< blockquote>您可以为这些BI问题创建动态数据透视表。

参见我的文章 [ ^ ]关于动态调整以了解如何完成

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>

解决方案

You can create a Dynamic Pivot for these BI questions.
See my article[^] about dynamic pivotting to understand how it can be done

这篇关于如何绑定行中的动态数据以及asp.net中列中的动态数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！