在gridview中从行到列显示数据 [英] Display data in gridview from row to column

问题描述

我的行数据如

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屋！