从多个表中显示gridview中的值 [英] Display values in gridview from multiple tables

问题描述

我需要立即帮助guyssssss。场景是这样的：

我有3个表：主题，类和标记，其中有详细的主题，主题为主题; classid，类中的classname; markid，classid，subjectid，mark in mark。

我希望以类似的形式显示详细信息，形成垂直标题文本，水平标题和对应于（类，主题）的标记。

以下是所需的输出/ gridvew ...我尝试了很多方法......没有工作..

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

推荐答案

我们如何使用join ...我在使用join时没有得到这种形式...我的意思是我希望输出就像我展示的设计一样..你能给我一个例子吗？假设表格是主题，类别，标记;如何获得如图所示的数据????

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????

这篇关于从多个表中显示gridview中的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！