DATATABLE合并行

Question

本帖最后由 holyshit_fuck 于 2012-04-12 22:22:50 编辑

Answer 1

 DataTable dt = new DataTable();
            dt.Columns.Add("A", typeof(string));
            dt.Columns.Add("B", typeof(string));
            DataRow dr1 = dt.NewRow();
            dr1["A"] = "1";
            dr1["B"] = "a";
            dt.Rows.Add(dr1);            DataRow dr2 = dt.NewRow();
            dr2["A"] = "1";
            dr2["B"] = "b";
            dt.Rows.Add(dr2);            DataRow dr3 = dt.NewRow();
            dr3["A"] = "1";
            dr3["B"] = "c";
            dt.Rows.Add(dr3);
           
            var vardt = from p in dt.AsEnumerable()
                        group p by p.ItemArray[0] into g
                        let concat= g.Concat(x =>x.ItemArray[1].ToString())
                        select new
                        {
                            A = g.Key,
                            Sum = concat
                        };
            foreach (var outputvar in vardt)
            {
                MessageBox.Show(outputvar.A + "  " + outputvar.concat);
            }

Answer 2

protected void Unite(GridView  gv)
    {
        int i;
        string LastType1;
        int LastCell;        if (gv.Rows.Count > 0)
        {
            LastType1 = gv.Rows[0].Cells[0].Text;
            gv.Rows[0].Cells[0].RowSpan = 1;
            LastCell = 0;
            for (i = 1; i < gv.Rows.Count; i++)
            {
                if (gv.Rows[i].Cells[0].Text == LastType1)
                {
                    gv.Rows[i].Cells[0].Visible = false;
                    gv.Rows[LastCell].Cells[0].RowSpan++;
                }
                else
                {
                    LastType1 = gv.Rows[i].Cells[0].Text;
                    LastCell = i;
                    gv.Rows[i].Cells[0].RowSpan = 1;
                }
            }
        }
    }
gridview  合并单元格