Loading

How to insert an empty record (row) in asp:Repeater

How to insert an empty record (row) in asp:Repeater

Qayyum ChauDhary

6y1.2kLearn iOS Programming

How to insert one empty record after every 5 records in the repeater output?

Actually I need to insert one empty record after every 5 records in the repeater output.

For example Repeater original output is following

1.ABC

2.BCD

3.CDE

4.DEF

5.EFG

6.FGH

7.GHI

The desired output will be following

1.ABC

2.BCD

3.CDE

4.DEF

5.EFG

6.FGH

7.GHI

What i have done so far:

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server"> <title>title> head>
<body> <form id="form1" runat="server">
<div> <asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate> <asp:Label ID="Label1" runat="server" Text='<%#Eval("CustomerName") %>'>asp:Label>
<br />
ItemTemplate>
asp:Repeater>
div>
form>
body>
html>

and

public partial class WebForm2 : System.Web.UI.Page
{
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
protected void Page_Load(object sender, EventArgs e)
{
con.ConnectionString = "Data Source=PC\\SQLEXPRESS;Initial Catalog=AlvisDB;Persist Security Info=True;User ID=sa;Password=pass";
con.Open();
cmd.Connection = con;
cmd.CommandText = "SELECT CustomerName FROM Customers";
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adp.Fill(ds);
Repeater1.DataSource = ds;
Repeater1.DataBind();
con.Close();
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Accepted answer
Hi,

I did not get why you need blank row, you can change your repeater styles for different look,

but still you want to do that then Please try below code to add empty row in dataset, Add below code after adp.Fill(ds); line.
if (ds != null && ds.Tables[0].Rows.Count > 4)

{

    for (int i = 1; i < ds.Tables[0].Rows.Count - 1; i++)

{

var row = ds.Tables[0].NewRow();

row["CustomerName"] = string.Empty;



        if (i % 5 == 0)

{

ds.Tables[0].Rows.InsertAt(row,i);

ds.AcceptChanges();

}

}

}
Guest User6y ago
Why do you need an empty record?

If it is only used to change the layout, why not use CSS? Lookup :nth-child()

https://www.cssportal.com/css-selectors/selector-nth-child.php