Creating Total Cell in DataGrid not working with Template Field

[daz_oldham]

(Using C# 2.0)

Hi

I was trying to get a field formatted as currency, but could not do
this in my DataGrid unless I did the field as a template field.

However, when I try to create a total row when the row is databound, I
am just getting back that the value is a zerol length string -
presumably because my value is in a label.

How do I get around this? Given that unles the value is in the
template field, for some reason it won't write the £ sign out.

Many thanks

Darren
Source code:
<asp:TemplateFi eld HeaderText="£ Per Night">
<EditItemTempla te>
<asp:TextBox ID="TextBox1" runat="server" Text='<%#
Bind("PricePerN ight") %>'></asp:TextBox>
</EditItemTemplat e>
<ItemTemplate >
<asp:Label ID="Label1" runat="server" Text='<%#
Bind("PricePerN ight", "{0:c}") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateFie ld>
Code Behind:
protected void dgRoomBreakdown _ItemDatabound( object sender,
GridViewRowEven tArgs e)
{

switch (e.Row.RowType)
{
case DataControlRowT ype.DataRow:

if (e.Row.Cells[4].Text.Length > 0)
{
dPricePerNight +=
Double.Parse(e. Row.Cells[4].Text);
}
break;
case DataControlRowT ype.Footer:
e.Row.Cells[4].Text = dPricePerNight. ToString();
break;

}
}

[daz_oldham]

Fixed it myself!

You basically put the value into a text box (see code below) and then
do something like the following...

Daz

switch (e.Row.RowType)
{
case DataControlRowT ype.DataRow:
TextBox txtVal = (TextBox)(e.Row .Cells[4].Controls[1]);
if (txtVal.Text.Le ngth > 0)
{
dPricePerNight +=
Double.Parse(tx tVal.Text.Repla ce("£",""));
}
break;
case DataControlRowT ype.Footer:
e.Row.Cells[4].Text = dPricePerNight. ToString();
break;

}
}