如何在GridView中将列值绑定为行值 [英] How to bind column values as row values in a gridview

问题描述

我想将列值绑定为网格视图中的行.
例如:

I want bind a column values as Row in a grid view .
Eg:

  Employee
--------------- 
EmpId EmpName EmpSal
----------------------
1      a        1000
2      b        2000
3      c        3000
4      d        4000
5      e        5000

SqlDataAdapter da = new SqlDataAdapter("select EmpName from employee",con);
DataSet ds = new DataSet();
da.Fill(ds);
Gridview1.DataSource=ds;// I want bind the data as rows.

Gridview1.DataBind();  //  Is it possible using Gridview

编辑TR:< pre>标签是你的朋友.它们使您的代码更易于阅读，并且表布局实际可用.

Edit TR : <pre> tags are your friend. They make you code easier to read and your table layout actually work. Please use them in future.

推荐答案

通过在Sql Server中使用数据透视运算符

By using Pivot Operator in Sql Server

这篇关于如何在GridView中将列值绑定为行值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！