create a div dynamically for every row in database table ASP.Net

Question

I'm designing a website for my FYP, i have an customerOrder page, and a viewOrders page, customer places order in CustomerOrder page. in viewOrders i want to display the result of sql query, in dynamically created "div" and "labels" with CSS assigned to them for each row of table, in following SqlDataReader.tnx

protected void Page_Load(object sender, EventArgs e)
    {

        string localCnnString =
        ConfigurationManager.ConnectionStrings["LGDB"].ToString();
        SqlConnection SqlCnn = new SqlConnection(localCnnString);

        SqlCommand SqlCmd = new SqlCommand();

        SqlDataReader dReader;

        SqlCnn.Open();
        SqlCmd.Connection = SqlCnn;
        SqlCmd.CommandType = CommandType.StoredProcedure;

        SqlCmd.CommandText = "myrpoc";

        dReader = SqlCmd.ExecuteReader();

        while (dReader.Read())
        {
            //dynamic controls

        }

        dReader.Close();
        SqlCnn.Close();

    }
}

possible duplicate of dynamically creating div with dynamic content — Randhi Rupesh
– Randhi Rupesh, Commented Jul 11, 2013 at 9:10

TGH · Accepted Answer · 2013-07-11 05:16:21Z

2

This scenario can be solved in many different ways. The general approach though is some sort of data binding. If you're doing web forms I would look into the Repeater control, which will offer good template based data binding.

A less elegant way is to just loop out some dynamic html.

answered Jul 11, 2013 at 5:16

TGH

39.4k13 gold badges106 silver badges140 bronze badges

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

Comments

Randhi Rupesh · Accepted Answer · 2013-07-11 08:50:14Z

0

you can use data binding approach for Repeater or Gridview or Datalist.

another way is by string building for dynamic html and using it in divContent.InnerHtml

HTML

<div id="divContent" runat="server">

</div>

edited Jul 11, 2013 at 8:50

Randhi Rupesh

15.3k9 gold badges29 silver badges46 bronze badges

answered Jul 11, 2013 at 5:32

Gangadhar

1,74915 silver badges19 bronze badges

Collectives™ on Stack Overflow

create a div dynamically for every row in database table ASP.Net

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