Repeater Problem

[Mick Walker]

Hi everyone, I hope you all had a great weekend.
I have a problem, and I am really not sur eon how I should address it; I
have a repeater control, which is bound to a SqlDataSource, however
within the repeater control are a number of ImageButtons, and basically
if the Data Item is empty of NULL then I wish the image on the button to
be "cross.gif" otherwise I would like it to be "tick.gif".

As I said before I really have never came accross anything of the like
before, so I am totally stumped. Here is my current code:

<asp:Repeater ID="repItems" runat="server" DataSourceID="R epDS">
<HeaderTempla te ><table cellpadding="5" cellspacing="2" >
<tr class="TableCap tions">
<td><b>UID</b></td>
<td><b>Suppli er SKU</b></td>
<td><b>Linked SKU</b></td>
<td><b>Name</b></td>
<td><b>SD</b></td>
<td><b>SKD</b></td>
</tr>
</HeaderTemplate>
<ItemTemplate >
<tr class="RowStyle ">
<td align="left" valign="top"><a sp:Label ID="lblName"
runat="server" /></td>
<td><asp:ImageB utton ID="IBSupplierS KU"
runat="server" ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBLinkedSKU " runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBName" runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBShortDesc ription"
runat="server" ImageUrl="~/imgs/cross.gif" /></td>
</tr>
</ItemTemplate>
<AlternatingIte mTemplate>
<tr class="RowStyle ">
<td align="left" valign="top"><a sp:Label ID="lblName"
runat="server" /></td>
<td><asp:ImageB utton ID="IBSupplierS KU" runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBLinkedSKU " runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBName" runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBShortDesc ription" runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBSKUDescri ption" runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
</tr>
</AlternatingItem Template>
</asp:Repeater>
<asp:SqlDataSou rce ID="repDS" runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:DBConn %>"
SelectCommand=" SELECT [UID], [SupplierSKUCode], [LinkedSKU],
[Name], [ShortDescriptio n], [SKUDescription] FROM [Import_Lines]">
</asp:SqlDataSour ce>

If anyone can help, i'll gladly buy you virtual beer for the rest of
your life.

Kind Regards
Mick

[Eliyahu Goldin]

The most flexible way is to handle the ItemDataBound event. The event fires
for every repeater row (item) as it gets bound. You need to filter out items
that you don't want to handle, like header, footer, separator. For every
data item you get full access to the control in ItemTemplate and to the
DataItem. You can check and set any properties.

--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Mick Walker" <Mi*********@pr ivacy.netwrote in message
news:5e******** *****@mid.indiv idual.net...

Hi everyone, I hope you all had a great weekend.
I have a problem, and I am really not sur eon how I should address it; I
have a repeater control, which is bound to a SqlDataSource, however within
the repeater control are a number of ImageButtons, and basically if the
Data Item is empty of NULL then I wish the image on the button to be
"cross.gif" otherwise I would like it to be "tick.gif".

As I said before I really have never came accross anything of the like
before, so I am totally stumped. Here is my current code:

<asp:Repeater ID="repItems" runat="server" DataSourceID="R epDS">
<HeaderTempla te ><table cellpadding="5" cellspacing="2" >
<tr class="TableCap tions">
<td><b>UID</b></td>
<td><b>Suppli er SKU</b></td>
<td><b>Linked SKU</b></td>
<td><b>Name</b></td>
<td><b>SD</b></td>
<td><b>SKD</b></td>
</tr>
</HeaderTemplate>
<ItemTemplate >
<tr class="RowStyle ">
<td align="left" valign="top"><a sp:Label ID="lblName"
runat="server" /></td>
<td><asp:ImageB utton ID="IBSupplierS KU" runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBLinkedSKU " runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBName" runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBShortDesc ription"
runat="server" ImageUrl="~/imgs/cross.gif" /></td>
</tr>
</ItemTemplate>
<AlternatingIte mTemplate>
<tr class="RowStyle ">
<td align="left" valign="top"><a sp:Label ID="lblName"
runat="server" /></td>
<td><asp:ImageB utton ID="IBSupplierS KU" runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBLinkedSKU " runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBName" runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBShortDesc ription" runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
<td><asp:ImageB utton ID="IBSKUDescri ption" runat="server"
ImageUrl="~/imgs/cross.gif" /></td>
</tr>
</AlternatingItem Template>
</asp:Repeater>
<asp:SqlDataSou rce ID="repDS" runat="server" ConnectionStrin g="<%$
ConnectionStrin gs:DBConn %>"
SelectCommand=" SELECT [UID], [SupplierSKUCode], [LinkedSKU], [Name],
[ShortDescriptio n], [SKUDescription] FROM [Import_Lines]">
</asp:SqlDataSour ce>

If anyone can help, i'll gladly buy you virtual beer for the rest of your
life.

Kind Regards
Mick