Creating dynamic DIV in asp .net c#

Question

I am creating DIVs dynamically which will fetch data from my sql table(from each row) and will show it in DIVs. What problem I am facing is, it only shows the last row of my sql table in a div form Here is the html

<div ID = "containerDiv" class="container" runat = "server">
  <div ID = "columnDiv" class="col-md-3 col-sm-4" runat = "server">
     <div ID = "textDiv" class="text" runat="server">
     </div>
   </div>
</div>

and here is the cs code

static int count = 0;
    protected void Page_Load(object sender, EventArgs e)
    {

        string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
        using (SqlConnection con = new SqlConnection(CS))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM tblProducts"))
            {
                cmd.Connection = con;
                con.Open();
                SqlDataReader rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    columnDiv.ID = "columnDiv" + count;
                    textDiv.ID = "textDiv" + count;
                    string name = rdr["prod_name"].ToString();
                    string price = rdr["prod_price"].ToString();


                    textDiv.InnerHtml = name + "   " + price;

                    columnDiv.Controls.Add(textDiv);

                    containerDiv.Controls.Add(columnDiv);
                    count++;
                }
            }
         }
      }

Are you using ASP.NET WebForms?

David Pine
– David Pine

2016-04-20 11:09:11 +00:00
Commented Apr 20, 2016 at 11:09 — David Pine
– David Pine, Commented Apr 20, 2016 at 11:09

David Pine · Accepted Answer · 2016-04-20 11:11:27Z

2

Try using a Repeater, like this (here's the MSDN):

<asp:Repeater ID="Repeater1" runat="server">
      <ItemTemplate>
          <div ID="containerDiv" class="container" runat = "server">
              <div ID="columnDiv" class="col-md-3 col-sm-4" runat = "server">
                  <div ID="textDiv" class="text" runat="server">
                  </div>
              </div>
          </div>
      </ItemTemplate>
</asp:Repeater>

And supply a DataSource in the code behind on the server, and add '<%# Eval("ColumnName") %>' expressions in the markup where appropriate.

answered Apr 20, 2016 at 11:11

David Pine

24.6k11 gold badges82 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Moustafa Elqabbany · Accepted Answer · 2016-04-20 11:28:46Z

0

The standard approach is to use a GridView:

https://msdn.microsoft.com/en-us/library/aa479342.aspx

answered Apr 20, 2016 at 11:28

Moustafa Elqabbany

1,1409 silver badges10 bronze badges

Collectives™ on Stack Overflow

Creating dynamic DIV in asp .net c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related