如何从dataGridView预定义列中的sql表列中添加值(不添加新列)? [英] How to add value from sql table column in dataGridView predefined columns (without adding new columns)?

问题描述

我有一个像这样的表

i have a table like this

Period	EmployeeId	SubjectName	Class	Section	TDay
I   	E10001	            Math	IV	   A	Monday    
II   	E10002	            Math	V	   B	Tuesday   
IV   	E10002	            Math	I	   c	Monday    
V   	E10001	            Math	III	   A	Tuesday 
II   	E10001	            Math	II	   c	Monday

我想要像这样的datagridveiw中的这些数据

empid = E10001

and i want these data in datagridveiw like this

empid=E10001

period     I               II           III        IV        V
Monday   class IV A      class II c      
Tuesday                                                   class III c

how could i access data like this through code in my datagridveiw?

推荐答案

阅读有关 SQL PIVOT :
使用PIVOT和UNPIVOT [了解PIVOT和UNPIVOT [在SQL Server中透视数据 [

Read aboutSQL PIVOT:
Using PIVOT and UNPIVOT[^]
Understanding PIVOT and UNPIVOT[^]
Pivoting data in SQL Server[^]

Try!

这篇关于如何从dataGridView预定义列中的sql表列中添加值(不添加新列)?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！