How to merge GridView's Cells(not Headers or Footers) horizontally?

Question

0.00/5 (No votes)

See more:

Posted 5-Jun-14 19:54pm

AR547

Updated 5-Jun-14 19:57pm

v3

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thanks7872 · Answer 1 · 2014-06-05T20:03:00

Solution 1

Finest and best solution is already available on internet. Please use Google.

Hint: In RowDataBound Event of GridView, you are suppose to loop through Cells of row . If you find text similar,merge them. Start this from rowIndex of 1 because you will not be merging the Header[Better to say ignore header in the Event],right? Let me know if you need more clarification on this.

Regards..

Posted 5-Jun-14 20:03pm

Thanks7872

Updated 5-Jun-14 20:06pm

v3

Comments

AR547 6-Jun-14 2:19am

Rohan,
Got your point. But I am not comparing any cell having same values, actually I need to create a 3 row with 2 columns in which I have to bind data from a textbox outside the gridview. But I tried that trick of applying 1 in rowIndex in RowDataBound but it was creating extra duplicate rows of that 3rd row.
:(

Thanks7872 6-Jun-14 3:29am

I think you are tyring to merge 2nd and 3rd cells regardless of its same values. If so,just merge them without comparing their values. Whats the issue?

AR547 6-Jun-14 4:02am

Almost done..but cannot generate new rows on next click. it is merging cells on each row now.
here is my code in RowDataBound:

protected void GV_Requests_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowState != DataControlRowState.Edit) // check for RowState
{
if (e.Row.RowType == DataControlRowType.DataRow) //check for RowType
{
//Loop through all the cells in the row
for (int j = 0; j < GV_Requests_Sys.Rows.Count+1; j++)
{
if (j % 2 !=0)
{
e.Row.Cells[0].Text = "Request<br/>Description";
e.Row.Cells[0].ColumnSpan = 2;
e.Row.Cells[1].ColumnSpan = 4;
for (int i =1; i < e.Row.Cells.Count - 1; i++)
{
Checking If current cell is same as next cell value
if (e.Row.Cells[i].Text == e.Row.Cells[i + 1].Text)
{
e.Row.Cells[i + 1].Visible = false;
}
}
}
}
}
}
}

Debabrata_Das · Answer 2 · 2014-06-05T20:19:00

Solution 2

Hello freind, you may try this code:

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        if (e.Row.RowIndex > 0)
        {
            int colSpanValue = 2;
            //Loop through all the cells in the row
            for (int i = 0; i < e.Row.Cells.Count - 1; i++)
            {
                //Checking If current cell is same as next cell value
                if (e.Row.Cells[i].Text == e.Row.Cells[i + 1].Text)
                {
                    e.Row.Cells[i].ColumnSpan = colSpanValue;
                    e.Row.Cells[i + 1].Visible = false;
                    colSpanValue++;
                }
            }
        }
    }
}

Posted 5-Jun-14 20:19pm

Debabrata_Das

Comments

AR547 6-Jun-14 2:23am

Dear Friend,
This code will work if we have to compare the same values of cells. But data is coming from DataTable. The 3rd Row's first column's text is hard coded as Remarks and the 2nd column will have Random Text binded from textbox outside the gridview. The other 3rd 4th and 5th column should be merged.

Debabrata_Das 6-Jun-14 2:29am

Hi,

It will merge the columns whenever there are consecutive cells with same values. I think it will work for your requirement. I would suggest you to give a try and then let me know your findings.

- DD

AR547 6-Jun-14 2:34am

And how will I create a new row after data has been bound. Like Headers(1st row) and 2nd row created and now I need to create new row of Remarks and then I will check those cells with null values and will use your code here.

Debabrata_Das 6-Jun-14 3:30am

Hi,
Let's not jump directly into the actual problem. First try with a simple POC where you can achieve cells merging functionality. Once you are successful, you'll feel more confident and you can implement the same logic into your real program.

Please note the code I shared is not going to solve your problem 100%. It's just a direction and then you have to tweak as per your requirement. :)

- DD

AR547 6-Jun-14 4:02am

Almost done..but cannot generate new rows on next click. it is merging cells on each row now.
here is my code in RowDataBound:

protected void GV_Requests_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowState != DataControlRowState.Edit) // check for RowState
{
if (e.Row.RowType == DataControlRowType.DataRow) //check for RowType
{
//Loop through all the cells in the row
for (int j = 0; j < GV_Requests_Sys.Rows.Count+1; j++)
{
if (j % 2 !=0)
{
e.Row.Cells[0].Text = "Request<br/>Description";
e.Row.Cells[0].ColumnSpan = 2;
e.Row.Cells[1].ColumnSpan = 4;
for (int i =1; i < e.Row.Cells.Count - 1; i++)
{
Checking If current cell is same as next cell value
if (e.Row.Cells[i].Text == e.Row.Cells[i + 1].Text)
{
e.Row.Cells[i + 1].Visible = false;
}
}
}
}
}
}
}

How to merge GridView's Cells(not Headers or Footers) horizontally?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to merge GridView's Cells(not Headers or Footers) horizontally?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us