Make the gridview using C# and ASP.Net

Hi theunclevince,

The image link you shared is not accessible at our end.

Please share a valid accessable link.

Link to GV image

Hi theunclevince,

Refer below article.

Group GridView Header Row Columns by merging Cells in ASP.Net

Thanks for help.

I tried your link without success this is the output from gridview 

My code below

.aspx

            <asp:GridView ID="GridView1" HeaderStyle-BackColor="#9AD6ED" HeaderStyle-ForeColor="#636363"
                runat="server" AutoGenerateColumns="false" OnDataBound="OnDataBound">
                <Columns>
                    <asp:BoundField DataField="xHour" HeaderText="" ItemStyle-HorizontalAlign="Center" ItemStyle-Width="150" HtmlEncode="false" />
                    <asp:BoundField DataField="xDateHoiur" HeaderText="DateHour" ItemStyle-HorizontalAlign="Center" ItemStyle-Width="150" />
                    <asp:BoundField DataField="Total" HeaderText="Total" ItemStyle-HorizontalAlign="Center" ItemStyle-Width="150" HtmlEncode="false" />
                    <asp:BoundField DataField="A_RG" HeaderText="A_RG" ItemStyle-HorizontalAlign="Center" ItemStyle-Width="150" HtmlEncode="false" />
                    <asp:BoundField DataField="B_RG" HeaderText="B_RG" ItemStyle-HorizontalAlign="Center" ItemStyle-Width="150" HtmlEncode="false" />
                    <asp:BoundField DataField="c_RG" HeaderText="C_RG" ItemStyle-HorizontalAlign="Center" ItemStyle-Width="150" HtmlEncode="false" />
                </Columns>
            </asp:GridView>

.cs

    protected void OnDataBound(object sender, EventArgs e)
    {
        GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);

        TableHeaderCell cell = new TableHeaderCell();

        cell = new TableHeaderCell();
        cell.ColumnSpan = 1;
        cell.Text = "Hour";
        row.Controls.Add(cell);

        cell = new TableHeaderCell();
        cell.ColumnSpan = 1;
        cell.Text = "C_CO";
        row.Controls.Add(cell);

        cell = new TableHeaderCell();
        cell.Text = "710";
        cell.ColumnSpan = 4;
        row.Controls.Add(cell);

        cell = new TableHeaderCell();
        cell.Text = "810";
        cell.ColumnSpan = 3;
        row.Controls.Add(cell);

        cell = new TableHeaderCell();
        cell.ColumnSpan = 3;
        cell.Text = "830";
        row.Controls.Add(cell);

        cell = new TableHeaderCell();
        cell.ColumnSpan = 3;
        cell.Text = "E10";
        row.Controls.Add(cell);

        cell = new TableHeaderCell();
        cell.ColumnSpan = 3;
        cell.Text = "E40";
        row.Controls.Add(cell);

        cell = new TableHeaderCell();
        cell.ColumnSpan = 3;
        cell.Text = "TOTAL";
        row.Controls.Add(cell);

        row.BackColor = ColorTranslator.FromHtml("#3AC0F2");
        GridView1.HeaderRow.Parent.Controls.AddAt(0, row);
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            this.BindGrid();
        }
    }

    private void BindGrid()
    {
        GridView1.DataSource = RetrieveProducts();
        GridView1.DataBind();
    }

    private DataTable RetrieveProducts()
    {
        DataTable dt = new DataTable();
        DataSet ds = new DataSet();

        using (SqlConnection myConnectionString =
          new SqlConnection(ConfigurationManager.ConnectionStrings["ConnSqlServer"].ConnectionString))
        {
            using (SqlCommand cmd =
                new SqlCommand("sp_C_CO", myConnectionString))
            {
                cmd.CommandTimeout = 2147483;
                cmd.Connection.Open();
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Clear();

                SqlDataAdapter adapter =
                     new SqlDataAdapter(cmd);

                adapter.Fill(ds);

                if (ds.Tables.Count > 0)
                {
                    dt = ds.Tables[0];
                }
            }
        }
        return dt;
    }

Link to image