在gridview中从行到列显示数据 [英] Display data in gridview from row to column
本文介绍了在gridview中从行到列显示数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的行数据如
I have data in Rows like
DateTime Status EmpId
2018-05-28 8:00 01 2000347
2018-05-28 20:18 02 2000347
2018-05-28 8:00 01 2000348
2018-05-28 17:18 02 2000348
现在我想将上面的数据转换成这样的列
Now i want above data convert into columns like this
EmpID Status (1)INTime Status(2)OutTime
2000347 2018-05-28 8:00 2018-05-28 20:18
2000348 2018-05-28 8:00 2018-05-28 17:18
日期明智IN OUT选择一个员工ID这个数据在数据库中退出并在转换成列后转移到另一个表
请帮助..
我的尝试:
Date wise IN OUT pick against one employee ID this data exit in data base and transfer it into another table after converting into columns
Kindly help ..
What I have tried:
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] { new DataColumn("Item"), new DataColumn("Quantity"), new DataColumn("Price") });
dt.Rows.Add("Shirt", 145, 500);
dt.Rows.Add("Jeans", 0, 2000);
dt.Rows.Add("Trousers", 190, 1545);
dt.Rows.Add("Tie", 30, 200);
dt.Rows.Add("Cap", 0, 300);
dt.Rows.Add("Hat", 90, 350);
dt.Rows.Add("Scarf", 290, 140);
dt.Rows.Add("Belt", 150, 400);
ViewState["dt"] = dt;
BindGrid(dt, false);
}
}
private void BindGrid(DataTable dt, bool rotate)
{
GridView1.ShowHeader = !rotate;
GridView1.DataSource = dt;
GridView1.DataBind();
if (rotate)
{
foreach (GridViewRow row in GridView1.Rows)
{
row.Cells[0].CssClass = "header";
}
}
}
protected void Convert(object sender, EventArgs e)
{
DataTable dt = (DataTable)ViewState["dt"];
if ((sender as Button).CommandArgument == "1")
{
btnConvert1.Visible = false;
btnConvert2.Visible = true;
DataTable dt2 = new DataTable();
for (int i = 0; i <= dt.Rows.Count; i++)
{
dt2.Columns.Add();
}
for (int i = 0; i < dt.Columns.Count; i++)
{
dt2.Rows.Add();
dt2.Rows[i][0] = dt.Columns[i].ColumnName;
}
for (int i = 0; i < dt.Columns.Count; i++)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
dt2.Rows[i][j + 1] = dt.Rows[j][i];
}
}
BindGrid(dt2, true);
}
else
{
btnConvert1.Visible = true;
btnConvert2.Visible = false;
BindGrid(dt, false);
}
推荐答案
这里是灵魂来源
here is soultion
SELECT empcode, MAX(CASE WHEN INOUT = 1 THEN Date END) AS INtime, MAX(CASE WHEN INOUT = 2 THEN Date END) AS Outtime
FROM HR AS t
GROUP BY empcode, CONVERT(date, Date)
这篇关于在gridview中从行到列显示数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文