ASP.net repeater control with SQLDataReader as data source
Posted
by PhilSando
on Geeks with Blogs
See other posts from Geeks with Blogs
or by PhilSando
Published on Thu, 22 Apr 2010 06:56:36 GMT
Indexed on
2010/04/22
8:14 UTC
Read the original article
Hit count: 246
Here is the markup for the repeater control and its templates:
<asp:Repeater ID="Repeater" runat="server">
<HeaderTemplate>
<table>
<tr>
<td colspan="3"><h2>Header information:</h2></td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%#Container.DataItem%></td>
</tr>
</ItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
Here is the code to populate it with data:
SQLString = "select something from foo where something"
SQLCommand = New SqlCommand(SQLString, SQLConnection)
SQLConnection.Open()
SQLDReader = SQLCommand.ExecuteReader
If SQLDReader.HasRows Then
Contactinforepeater.DataSource = SQLDReader
Contactinforepeater.DataBind()
End If
End If
SQLConnection.Close()
SQLDReader.Close()
© Geeks with Blogs or respective owner