How to toggle visibilty of button inside repeater control

[Keith Harris]

Hi,

I have a Repeater control which is bound to a dataset. In the footer of the
repeater control, I have a Button whose visibility I want to vary according
to the sum of a column being > 0.

I have tried to set the button's visibility in Page_Load (after data
binding), but I get a NullReferenceEx ception stating that "Object reference
not set to an instance of an object".

I'm sure this has to do with when my repeater control and it's contained
controls are being rendered, I've tried putting the logic in several places
but I can't figure it out. Below is the code; thank you for any help.

-Keith

=============== =============== ============
WebForm.aspx
=============== =============== ============
<asp:Repeater id="Repeater1" runat="server">
<HeaderTemplate >
<table>
<tr>
<td>Name</td>
<td>Num Users</td>
</tr>
</HeaderTemplate>
<ItemTemplate >
<tr>
<td><%# DataBinder.Eval (Container.Data Item,"GroupName ") %></td>
<td><%# DataBinder.Eval (Container.Data Item,"NumUsers" ) %></td>
</tr>
</ItemTemplate>
<FooterTemplate >
<tr>
<td>
<asp:Button id="buttonNext " runat="server" Text="Next"
OnClick="button Next_Click" Visible="True"> </asp:Button>
</td>
</tr>
</table>
</FooterTemplate>

=============== =============== ============
WebForm.aspx.cs
=============== =============== ============
....
protected System.Web.UI.W ebControls.Repe ater Repeater1;
protected System.Web.UI.W ebControls.Butt on buttonNext;
....
private void Page_Load(objec t sender, System.EventArg s e)
{
this.Repeater1. DataSource=dsDa taSet;
this.Repeater1. DataBind();

object
sum=dsDataSet.T ables[0].Compute("SUM(N umUsers)","NumU sers=NumUsers") ;

buttonNext.Visi ble=( (int)sum > 0 );
}

[Karl Seguin]

Keith,
You'll find your answer in my asp.net databinding tutorial:
http://openmymind.net/databinding/index.html#7.2

Basically, you want to hook into the OnItemDataBound event, and check for
e.Item.ItemType == ItemType.Footer

then you can do a
Button btn = (Button)e.Item. FindControl("bu ttonNext")
and toggle the visible there via btn.Visible = true/false;

Specifically with respect to doing it via the sum of a column being zero,
you'll need to figure that out when you get your dataset and store it in a
class field variable

private int sum = 0;
void page_load{
if (!page.ispostba ck){
DataSet ds = GetData();
sum = //figure out sum;
repater.DataSou rce = ds;
repeater.OnItem DataBound += ...
repeater.DataBi nd();
}
}

and then use the sum to toggle visibility.

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"Keith Harris" <Ke*********@di scussions.micro soft.com> wrote in message
news:F8******** *************** ***********@mic rosoft.com...

Hi,

I have a Repeater control which is bound to a dataset. In the footer of the repeater control, I have a Button whose visibility I want to vary according to the sum of a column being > 0.

I have tried to set the button's visibility in Page_Load (after data
binding), but I get a NullReferenceEx ception stating that "Object reference not set to an instance of an object".

I'm sure this has to do with when my repeater control and it's contained
controls are being rendered, I've tried putting the logic in several places but I can't figure it out. Below is the code; thank you for any help.

-Keith

=============== =============== ============
WebForm.aspx
=============== =============== ============
<asp:Repeater id="Repeater1" runat="server">
<HeaderTemplate >
<table>
<tr>
<td>Name</td>
<td>Num Users</td>
</tr>
</HeaderTemplate>
<ItemTemplate >
<tr>
<td><%# DataBinder.Eval (Container.Data Item,"GroupName ") %></td>
<td><%# DataBinder.Eval (Container.Data Item,"NumUsers" ) %></td>
</tr>
</ItemTemplate>
<FooterTemplate >
<tr>
<td>
<asp:Button id="buttonNext " runat="server" Text="Next"
OnClick="button Next_Click" Visible="True"> </asp:Button>
</td>
</tr>
</table>
</FooterTemplate>

=============== =============== ============
WebForm.aspx.cs
=============== =============== ============
...
protected System.Web.UI.W ebControls.Repe ater Repeater1;
protected System.Web.UI.W ebControls.Butt on buttonNext;
...
private void Page_Load(objec t sender, System.EventArg s e)
{
this.Repeater1. DataSource=dsDa taSet;
this.Repeater1. DataBind();

object
sum=dsDataSet.T ables[0].Compute("SUM(N umUsers)","NumU sers=NumUsers") ;

buttonNext.Visi ble=( (int)sum > 0 );
}