change the format of DataTable splitting the column in two

Question

User364607740 posted

I've a DataTable which format I need to change. The values of the DataTable are from the Database. 

Current DataTable format

CUSTOMER TYPE	FEE	NEW_FREE	NEW_PAID	OLD_FREE	OLD_PAID
GOLD	0	NULL	NULL	2	NULL
BRONZE	100	NULL	1	1	1
OTHERS	200	NULL	NULL	1	NULL

This DataTable shows the new & free customer type having free & paid registration. But I've to change the format of this DataTable to ::

Required DataTable format

		NEW		OLD
CUSTOMER TYPE	FEE	FREE	PAID	FREE	PAID
GOLD	0	NULL	NULL	2	NULL
BRONZE	100	NULL	1	1	1
OTHERS	200	NULL	NULL	1	NULL

The table top row should be to categorized as NEW/OLD customer and from the second row customer type and free and paid customer type. How can I do this?

Code so far I've done ::

CODE BEHIND ::

protected void search_Click(object sender, EventArgs e)
        {
                // code blocks
                if (dt != null && dt.Rows.Count > 0)
                {
                    DataView dv = dt.DefaultView;
                    //   Sort data
                    dv.Sort = "CUSTOMER TYPE DESC";
                    //   Convert back your sorted DataView to DataTable
                    dt = dv.ToTable();
                    GridView1.DataSource = dt;
                    GridView1.DataBind();
                    div_error.Visible = true;
					DataTable_Format(dt);
                }            
        }
		
protected void DataTable_Format(DataTable temp_dt)
        {
                DataTable dt = new DataTable();
                dt.Columns.Add(new DataColumn() { DataType = typeof(string), ColumnName = "CUSTOMER TYPE" });
                dt.Columns.Add(new DataColumn() { DataType = typeof(int), ColumnName = "FREE" });
                dt.Columns.Add(new DataColumn() { DataType = typeof(int), ColumnName = "PAID" });
                dt.Columns.Add(new DataColumn() { DataType = typeof(int), ColumnName = "FREE" });
                dt.Columns.Add(new DataColumn() { DataType = typeof(int), ColumnName = "PAID" });
        }		

My above code is not correct. I've just provided the code so far I tried to do. Further I've no idea how to proceed. 

How can I categorized the top row of the table as NEW & OLD and the second row as CUSTOMER TYPE, FEE, and for NEW column two columns FREE & PAID and for OLD column again two columns FREE & PAID?

Please help me. Thanks!!!