Datagrid - formatting columns (i.e. add £ symbol)

[daz_oldham]

I am populating my datagrid 'by hand' by that I mean that i am not
using the wizard!

What I would like to know, is if I can format my colums - for example
if I have a column that is returning 100.0500, how would I get it to
display £100.05.

Also, is it possible to create "total rows" to total up the values of a
given column?

Many thanks

Darren

[Sundar Raghavendran MCP]

Darren,

1) you will have to set the culture info on web.config to uk and set the
DataFormatstrin g property of the bound column in the datagrid.

On web.config file, add the following
<globalizatio n requestEncoding ="utf-8" responseEncodin g="utf-8"
culture="en-gb" />
and on the webform add this foll. line:
<asp:BoundColum n DataField="Pric e" HeaderText="Pri ce in GBP"
DataFormatStrin g={0:C}"></asp:BoundColumn >

2) Here you go:
http://support.microsoft.com/default...en-us%3B326339

best regards
Sundar Raghavendran
----------------------------------------------------------------------------------------------
"daz_oldham " <Da************ **@gmail.com> wrote in message
news:11******** **************@ i40g2000cwc.goo glegroups.com.. .
I am populating my datagrid 'by hand' by that I mean that i am not
using the wizard!

What I would like to know, is if I can format my colums - for example
if I have a column that is returning 100.0500, how would I get it to
display £100.05.

Also, is it possible to create "total rows" to total up the values of a
given column?

Many thanks

Darren

[daz_oldham]

Thanks very much for that Sundar.

I'm back at home now, but I will have a look at that in the morning.

Regards

Darren

Sundar Raghavendran MCP wrote:

Darren,

1) you will have to set the culture info on web.config to uk and set the
DataFormatstrin g property of the bound column in the datagrid.

On web.config file, add the following
<globalizatio n requestEncoding ="utf-8" responseEncodin g="utf-8"
culture="en-gb" />
and on the webform add this foll. line:
<asp:BoundColum n DataField="Pric e" HeaderText="Pri ce in GBP"
DataFormatStrin g={0:C}"></asp:BoundColumn >

2) Here you go:
http://support.microsoft.com/default...en-us%3B326339

best regards
Sundar Raghavendran
----------------------------------------------------------------------------------------------
"daz_oldham " <Da************ **@gmail.com> wrote in message
news:11******** **************@ i40g2000cwc.goo glegroups.com.. .
I am populating my datagrid 'by hand' by that I mean that i am not
using the wizard!

What I would like to know, is if I can format my colums - for example
if I have a column that is returning 100.0500, how would I get it to
display £100.05.

Also, is it possible to create "total rows" to total up the values of a
given column?

Many thanks

Darren

[daz_oldham]

I got this working Sundar (formatting as currency) but for some reason
it only worked when I set the cell to be a template cell.

Thanks again

Daz

daz_oldham wrote:

Thanks very much for that Sundar.

I'm back at home now, but I will have a look at that in the morning.

Regards

Darren

Sundar Raghavendran MCP wrote:

Darren,

1) you will have to set the culture info on web.config to uk and setthe
DataFormatstrin g property of the bound column in the datagrid.

On web.config file, add the following
<globalizatio n requestEncoding ="utf-8" responseEncodin g="utf-8"
culture="en-gb" />
and on the webform add this foll. line:
<asp:BoundColum n DataField="Pric e" HeaderText="Pri ce in GBP"
DataFormatStrin g={0:C}"></asp:BoundColumn >

2) Here you go:
http://support.microsoft.com/default...en-us%3B326339

best regards
Sundar Raghavendran
----------------------------------------------------------------------------------------------
"daz_oldham " <Da************ **@gmail.com> wrote in message
news:11******** **************@ i40g2000cwc.goo glegroups.com.. .
I am populating my datagrid 'by hand' by that I mean that i am not
using the wizard!

What I would like to know, is if I can format my colums - for example
if I have a column that is returning 100.0500, how would I get it to
display £100.05.

Also, is it possible to create "total rows" to total up the values of a
given column?

Many thanks

Darren