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
DataFormatstring property of the bound column in the datagrid.

On web.config file, add the following
<globalization requestEncoding="utf-8" responseEncoding="utf-8"
culture="en-gb" />
and on the webform add this foll. line:
<asp:BoundColumn DataField="Price" HeaderText="Price in GBP"
DataFormatString={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.googlegr oups.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
DataFormatstring property of the bound column in the datagrid.

On web.config file, add the following
<globalization requestEncoding="utf-8" responseEncoding="utf-8"
culture="en-gb" />
and on the webform add this foll. line:
<asp:BoundColumn DataField="Price" HeaderText="Price in GBP"
DataFormatString={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.googlegr oups.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
DataFormatstring property of the bound column in the datagrid.

On web.config file, add the following
<globalization requestEncoding="utf-8" responseEncoding="utf-8"
culture="en-gb" />
and on the webform add this foll. line:
<asp:BoundColumn DataField="Price" HeaderText="Price in GBP"
DataFormatString={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.googlegr oups.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