在c＃asp.net中，如何将数据库中的多行数据显示在gridview中的单行中 [英] In c# asp.net , how to display multiple row data from database in to a single row in gridview

问题描述

在c＃asp.net中，如何将数据库中的多行数据显示在gridview中的单行中，并在水晶报表中查看相同的内容







例如：



我希望它的输出：



StaffName |角色| GroupNumber

Adrian |讲师| 1,2



而不是：



员工名称|角色| GroupNumber

Adrian |讲师| 1

Adrian |讲师| 2

解决方案

您可以参考此查询来解决您的问题。它正在运行......

  SELECT  Employee_City，STUFF（（ SELECT  Employee_Name  AS   FROM  EmployeeMaster  AS  tab2  WHERE  
（Employee_City = tab1.Employee_City） FOR  XML PATH（' '））， 1 ， 2 ，' '） AS  Employee_Name 
  FROM  EmployeeMaster  AS  tab1 
  GROUP   BY  Employee_City 

In c# asp.net , how to display multiple row data from database in to a single row in gridview and same to view in crystal report



eg:

Output which i want it to be:

StaffName | Role | GroupNumber
Adrian | Lecturer | 1,2

Instead of:

StaffName | Role | GroupNumber
Adrian | Lecturer | 1
Adrian | Lecturer | 2

解决方案

You Can refer this query to solve your problem.It is working ...

SELECT Employee_City, STUFF((SELECT Employee_Name AS A FROM EmployeeMaster AS tab2 WHERE       
 (Employee_City = tab1.Employee_City) FOR XML PATH('')), 1, 2, '') AS Employee_Name
FROM  EmployeeMaster AS tab1
GROUP BY Employee_City

这篇关于在c＃asp.net中，如何将数据库中的多行数据显示在gridview中的单行中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！