ASP.NET adding controls inside a loop

Question

Pardon me, this really is a noob question but please understand that I do not have much ASP.NET experience. All I need to do is:

1) Open up the following SQL query:

SELECT myid FROM mytable

2) For each record, generate this fragment of HTML:

<a href="#mynameanchor" onClick="myfunction( '__myid comes here__' );"><img src="http://someurl/__myid comes here as well__/small.png" /></a>

Its easy for me to use the classical ASP <% do until recordset.eof ... loop %> style loops but I need it in ASP.NET style, probably perform the operation in Page_Load event and use intrinsic ASP.NET controls.

Have you checked out ASP.NET MVC? It might be more familiar to you and therefore easier to pick up because it reuses some ASP Classic concepts including looping through a recordset and adding html elements (or user controls here.) — Paul Sasik
– Paul Sasik, Commented Dec 23, 2009 at 6:16

Gabriel McAdams · Accepted Answer · 2009-12-23 06:07:12Z

4

Use a repeater control. In the ItemTemplate, you can put whatever you would like to be generated for each record returned from your query.

http://articles.sitepoint.com/article/asp-net-repeater-control

answered Dec 23, 2009 at 6:07

Gabriel McAdams

58.5k12 gold badges67 silver badges78 bronze badges

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

6 Comments

Shantanu Gupta Over a year ago

I think what he want is different from using repeater

Kobi Over a year ago

@Shantanu Gupta - I disagree, a repeater seems perfect for this, though I'm not sure about the href.

Ariel Over a year ago

A repeater would be too much of an overkill (and add a lot of unecessary markup) for such a simple implementation...

Salman Arshad Over a year ago

Can I access the onclick attribute from within the repeater control?

Madi D. Over a year ago

yes you can , check up "Repeater.ItemCommand " and use asp:linkbuttons instead of normal links.. :)

|

Hiyasat · Accepted Answer · 2009-12-23 07:11:20Z

3

add this in the aspx page source

   <td id="urLink" runat="server">

   </td>

add this in the Page_Load event

 SqlConnection con = new SqlConnection();
 con.connectionstring = "your connection database";
 SqlDataReader reader;
 SqlCommand command = new SqlCommand(con);
 command.Commandtext = "SELECT myid FROM mytable";
 command.CommandType = CommandType.Text;
 reader = command.ExecuteReader();
 while(reader.Read())
 {
      urLink.innerHTML += "<a   href="#mynameanchor" onClick="myfunction( " + reader["myid"].tostring() + " );">
    <img src="http://someurl/" + reader["myid"].tostring() + "/small.png" /></a>";
 }

answered Dec 23, 2009 at 7:11

Hiyasat

8,9667 gold badges36 silver badges60 bronze badges

2 Comments

Salman Arshad Over a year ago

+1 for showing how to use data reader (I didn't know how to use it).

Ariel Over a year ago

One quick note - for efficient memory handling you'd want to wrap your connection, command, and reader in using() blocks so they get disposed when you're done with them ;)

Ariel · Accepted Answer · 2009-12-23 06:14:58Z

2

Looks like the onclick is a javascript event which means you can write out the HTML markup to a string and then append it all into a literal control. Remember to use a stringbuilder :)

here's a very basic example:

// get data from database and into a reader before

StringBuilder links = New StringBuilder();

while(reader.read())
{
    links.appendFormat("<a HREF='id_{0}'>{0}</a>", reader["ID"]);
}

ltlLinks.Text = links.ToString();

answered Dec 23, 2009 at 6:14

Ariel

4,5102 gold badges24 silver badges23 bronze badges

4 Comments

Shantanu Gupta Over a year ago

This seems to be very nice answer up to some extent. But how this control is being rendered at frontend ? R u using literal or span tag ?

Salman Arshad Over a year ago

+1 for simplicity. This is exactly what I wanted but instead I ended up using DataRepeater as the script might require enhancements in the future.

Ariel Over a year ago

@ Salman A - Thanks for the +1. I generally try to stay away from using runat="server" type controls such as a repeater because they create a really bloated html output.

Ariel Over a year ago

@Shantanu Gupta - The output is meant to go into a <asp:Literal></asp:Literal> control (which has no additional html markup on the client) or an html <span runat="server"></span>

Collectives™ on Stack Overflow

ASP.NET adding controls inside a loop

3 Answers 3

6 Comments

2 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

2 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related