Merge Repeater Row If Field2 Is Empty

Question

Hello

This is my aspx page

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default4.aspx.cs" Inherits="Default4" %> 


    Untitled Page
        



    
    
       
                         
                           
                             
                                  
                            this is my code file
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections.Specialized;
using System.Text;
using System.Drawing;
using System.IO;
using System.Net;
using System.Net.Mail;
using System.Net.Configuration;

public partial class Default4 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //

        DataTable hdt = new DataTable();
        SqlConnection hcon1 = new SqlConnection(ConfigurationManager.ConnectionStrings["CHEMIMSConnectionString"].ConnectionString);
        hcon1.Open();
        SqlCommand hcmd1 = new SqlCommand("select * from Table1 ", hcon1);
        SqlDataAdapter hada1 = new SqlDataAdapter(hcmd1);
        hada1.Fill(hdt);
        Repeater2.DataSource = hdt;
        Repeater2.DataBind();
        hcon1.Close();
    }
}

this is sql database
 
/****** Object:  Table [dbo].[Table1]    Script Date: 03/23/2024 17:47:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Table1](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Field1] [varchar](150) NULL,
	[Field2] [float] NULL,
	[Field3] [varchar](50) NULL,
	[Field4] [float] NULL,
 CONSTRAINT [PK_Table1] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[Table1] ON
INSERT [dbo].[Table1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (1, NULL, 200, N'APPLE', 10)
INSERT [dbo].[Table1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (2, NULL, 5, N'CR1', 3.5)
INSERT [dbo].[Table1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (3, NULL, 2, N'M1', 4)
INSERT [dbo].[Table1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (4, NULL, NULL, N'WASH', NULL)
INSERT [dbo].[Table1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (5, NULL, 6, N'T8', 2.3)
INSERT [dbo].[Table1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (6, NULL, 7, N'T9', 3.7)
INSERT [dbo].[Table1] ([ID], [Field1], [Field2], [Field3], [Field4]) VALUES (7, NULL, NULL, N'D/W', NULL)
SET IDENTITY_INSERT [dbo].[Table1] OFF

It showing like this 
but i need to merege row if field2 is empty and make that row complete grey color like this as below  

                            
                         
                           FIELD 1
                           
                            FIELD 2
                             
                         FIELD 3
                                   
                         FIELD 4 
                          
                       
                         
                             
                             
                                  
                                   
                                  
                                     
                                      
                                    
                                     
                                     
                                     
                                     
                                        <%# Eval("Field3")%>

Accepted Answer

Hi @RAVI,

You can implement it in OnItemDataBound method. The specific code is as follows:

protected void repRequests_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
    if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
    {
        //Reference the Repeater Item.
        RepeaterItem item = e.Item;
        //Reference the Controls.
        string Field2 = (item.FindControl("LP") as Label).Text;
        HtmlTableRow tdValue = (HtmlTableRow)e.Item.FindControl("GraphTable");
        HtmlTableCell td = (HtmlTableCell)e.Item.FindControl("tdControl");
        if (Field2 == "")
        {
            td.ColSpan = 6;
            tdValue.Cells.RemoveAt(3);
            tdValue.Cells.RemoveAt(1);
            tdValue.Cells.RemoveAt(0);
            tdValue.Attributes.Add("style", "background-color: grey;");
        }
    }
}



    Untitled Page
    


    
        
            
                
                    
                    
                    
                        
                            FIELD 1
                            FIELD 2
                            FIELD 3
                            FIELD 4
                        
                
                
                        
                            
                        
                        
                            
                        
                        
                            <%# Eval("Field3")%>

User's image

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Merge Repeater Row If Field2 Is Empty

0 additional answers