The following code retrieves records from a database table & displays
it in a Repeater control:
<script runat="server">
Sub Page_Load(ByVal obj As Object, ByVal ea As EventArgs)
If Not (Page.IsPostBac k) Then
Dim dSet As DataSet
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter
sqlConn = New SqlConnection(" Data
Source=MyDS\SQL EXPRESS;Initial Catalog=MyDB;In tegrated Security=True")
sqlDapter = New SqlDataAdapter( "SELECT * FROM Users",
sqlConn)
dSet = New DataSet()
sqlDapter.Fill( dSet, "Users")
rptrUsers.DataS ource = dSet
rptrUsers.DataM ember = "Users"
rptrUsers.DataB ind()
sqlConn.Close()
End If
End Sub
Sub BindData(ByVal obj As Object, ByVal ea As
RepeaterItemEve ntArgs)
Response.Write( "Data Bound<hr>")
End Sub
Sub ItemCreated(ByV al obj As Object, ByVal ea As
RepeaterItemEve ntArgs)
Response.Write( "Item Created<br>")
End Sub
</script>
<form runat="server">
<asp:Repeater ID="rptrUsers" OnItemCreated=" ItemCreated"
OnItemDataBound ="BindData" runat="server">
<HeaderTemplate >
<table border="1">
<tr>
<th>NAME</th>
<th>PHONE NO.</th>
</tr>
</HeaderTemplate>
<ItemTemplate >
<tr>
<td>
<asp:LinkButt on ID="linkbut" runat="server"> <%#
Container.DataI tem("UName") %></asp:LinkButton>
</td>
<td><%# Container.DataI tem("Phone") %></td>
</tr>
</ItemTemplate>
<AlternatingIte mTemplate>
<tr>
<td><%# Container.DataI tem("UName") %></td>
<td><%# Container.DataI tem("Phone") %></td>
</tr>
</AlternatingItem Template>
<FooterTemplate >
</table>
</FooterTemplate>
</asp:Repeater>
</form>
Note that the records under the "NAME" column within the <ItemTemplate >
are hyperlinks whereas the records under the "NAME" column within the
<AlternatingIte mTemplatearen't hyperlinks. Assume that the Repeater
displays 4 rows.
When the page loads for the very first time, both OnItemCreated &
OnItemDataBound get fired & the Repeater with the 4 rows also gets
rendered. Next I click the first hyperlink (whose index is 0). When the
page re-loads, only OnItemCreated gets fired. Now although the entire
code in the Page_Load sub (which creates & opens a DB connection,
retrieves the records, fills the DataSet & finally spits out the
resultset in the Repeater control) is within the "If Not
(Page.IsPostBac k)" condition, the Repeater still displays the 4 rows
when the page re-loads.
Now during this postback, the Repeater with the 4 rows gets recreated
from the ViewState, isn't it? This is what I did like to make sure of
i.e. whether the Repeater gets recreated from the ViewState or not?
Please correct me if I am wrong.
Thanks,
Arpan
