Gridview组水平显示 [英] Gridview Group Display Horizontally
问题描述
我正在使用Asp.net 4.0和Sqlserver 2008.我想从数据库中获取记录并将其显示到gridview中。我是这个系统中的新手(Freshers)。我迫切需要它。所以如果有人可以请帮帮我。谢谢。
表结构:
创建表dbo.DwlEntry
(
Id INT IDENTITY(1,1),
UserName VARCHAR(100),
ConfigItem VARCHAR(100),
组件VARCHAR(100),
TimeLogged DECIMAL(13,2)
)
INSERT INTO dbo.DwlEntry (UserName,ConfigItem,Component,TimeLogged)VALUES(''Bubai'',''AFOTA'',''Documentation'',''3'')
INSERT INTO dbo.DwlEntry(UserName ,ConfigItem,Component,TimeLogged)VALUES(''Bubai'',''GENERAL'',''疑难解答'',''3'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem ,组件,TimeLogged)VALUES(''Bhanu'',''AFOTA'',''CodeChange'',''3 ')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged)VALUES(''Bubai'',''GENERAL'',''ProjectTraining'',''1'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged)VALUES(''Bhanu'',''GENERAL'',''疑难解答'',''5'')br />
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged)VALUES(''Bhanu'',''AFOTA'',''CodeChange'',''1'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged)VALUES(''Bubai'',''AFOTA'',''CodeChange'',''5'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged)VALUES(''Bubai'',''GENERAL'',''ProjectTraining'',''4'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged)VALUES(''Bhanu'',''AFOTA'',''Documentation'',''2'')
INSE RT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged)VALUES(''Bhanu'',''GENERAL'',''ProjectTraining'',''4'')
我希望结果如下。配置项将是第一行。和分组水平如下格式
配置项目AFOTA AFOTA一般总则
用户名文档CodeChange ProjectTraining故障排除总计
Bhanu 2 4 4 5 15
Bubai 3 5 5 3 16
总计 5 9 9 8 31
http://www.aspdotnet-suresh.com/2013/01/convert-gridview-columns-到行-in.html
I am using Asp.net 4.0 and Sqlserver 2008. I want to fetch record from Database and display it into gridview.I am very new in this system(Freshers).I need it urgently.So please help me if anybody can.Thanks in Advance.
Table Structure :
CREATE TABLE dbo.DwlEntry
(
Id INT IDENTITY(1,1),
UserName VARCHAR(100),
ConfigItem VARCHAR(100),
Component VARCHAR(100),
TimeLogged DECIMAL(13,2)
)
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged) VALUES(''Bubai'',''AFOTA'',''Documentation'',''3'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged) VALUES(''Bubai'',''GENERAL'',''Troubleshooting'',''3'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged) VALUES(''Bhanu'',''AFOTA'',''CodeChange'',''3'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged) VALUES(''Bubai'',''GENERAL'',''ProjectTraining'',''1'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged) VALUES(''Bhanu'',''GENERAL'',''Troubleshooting'',''5'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged) VALUES(''Bhanu'',''AFOTA'',''CodeChange'',''1'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged) VALUES(''Bubai'',''AFOTA'',''CodeChange'',''5'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged) VALUES(''Bubai'',''GENERAL'',''ProjectTraining'',''4'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged) VALUES(''Bhanu'',''AFOTA'',''Documentation'',''2'')
INSERT INTO dbo.DwlEntry(UserName,ConfigItem,Component,TimeLogged) VALUES(''Bhanu'',''GENERAL'',''ProjectTraining'',''4'')
I want the Result in below way . Config item would be first row. and grouping come Horizontally like below Format
Config Item AFOTA AFOTA GENERAL GENERAL
User Name Documentation CodeChange ProjectTraining Troubleshooting Total
Bhanu 2 4 4 5 15
Bubai 3 5 5 3 16
Total 5 9 9 8 31
http://www.aspdotnet-suresh.com/2013/01/convert-gridview-columns-to-rows-in.html
这篇关于Gridview组水平显示的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!