Binding NULL column causing Page_Load to run twice

T

T-Bone

Problem with page_load firing twice was driving me mad.
I had an aspx page with several webusercontrols in it.
One of them had a repeater with some databinders in it.
In my codebehing I bind a dataset to the repeater.
However when one of the values in my dataset (in my case field
'banLocation' holding the location of an banner) was a NULL value the
page was loaded a again after the databind() command. Just filling the
field in the table of my SQL server database with some value solved
the problem. Leaving the field NULL and removing the '' in the <IMG
SRC> tag solved it.

source of the webusercontrol:

<asp:repeater id="rptBanners" runat="server" EnableViewState="True">
<ItemTemplate>
<a href='click.aspx?id=<%#
Databinder.Eval(Container.DataItem,"banID") %>&url=<%#
Databinder.Eval(Container.DataItem,"banUrl") %>' target='<%#
Databinder.Eval(Container.DataItem,"banTarget") %>'>
<img src='<%# Databinder.Eval(Container.DataItem,"banLocation")
%>' border=0></a>
<asp:Label id="lblbanid" runat="server" Visible="False" Text='<%#
Databinder.Eval(Container.DataItem,"banID") %>'>
</asp:Label>
<br>
</ItemTemplate>
</asp:repeater>



codebehind:

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
If Not IsPostBack Then
Dim myConnection As New
SqlConnection(GetDBConnectionString)
Dim getbanners As New SqlDataAdapter("select * from
i_banners ", myConnection)
Dim banDS As New DataSet
getbanners.Fill(banDS)
Me.rptBanners.DataSource = banDS
Me.rptBanners.DataBind()
End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,764
Messages
2,569,564
Members
45,040
Latest member
papereejit

Latest Threads

Top