Runtime DataGrid formating

[Tina]

I have a datagrid where I specified {0:###,###,###} at design time. However
sometimes I am putting percentages in the grid instead of money and I want
to change the formating to {##%}. I've looked over the docs on such things
as the dataformatstring porperty of the boundColumn but still can't figure
out how to do it in code.

Thank,
T

 

[Joseph Lee]

This is what I did, it is not very good, but will allow you to do
processing.

Example:
On the aspx/ascx page, I would like to retrieve the the date for the the
particular record
so i call a function coded in the aspx.cs/ascx.cs which is GetDate, I will
pass in the record in the datagrid

<%# GetDate(Container.DataItem) %>

On the aspx.cs/ascx.cs, I will process the dataItem, which return the short
date for my datagrid

public string GetDate(Object obj)
{
string topicDate = ((DataRowView)obj)["topicDate"].ToString();
return Convert.ToDateTime(topicDate).ToShortDateString();
}

-----------------------------------------------------------------

If you would like a better and much more professional way, this article
might help

http://openmymind.net/databinding/index.html

Joey

 

[Tina]

Ouch, pretty ugly but thank you for the help. The article is also very
good.
T

This is what I did, it is not very good, but will allow you to do
processing.

Example:
On the aspx/ascx page, I would like to retrieve the the date for the the
particular record
so i call a function coded in the aspx.cs/ascx.cs which is GetDate, I will
pass in the record in the datagrid

<%# GetDate(Container.DataItem) %>

On the aspx.cs/ascx.cs, I will process the dataItem, which return the
short date for my datagrid

public string GetDate(Object obj)
{
string topicDate = ((DataRowView)obj)["topicDate"].ToString();
return Convert.ToDateTime(topicDate).ToShortDateString();
}

-----------------------------------------------------------------

If you would like a better and much more professional way, this article
might help

http://openmymind.net/databinding/index.html

Joey

I have a datagrid where I specified {0:###,###,###} at design time.
However sometimes I am putting percentages in the grid instead of money
and I want to change the formating to {##%}. I've looked over the docs on
such things as the dataformatstring porperty of the boundColumn but still
can't figure out how to do it in code.

Thank,
T

 

[Tina]

Joseph,
I found a way to do it without having to put code manually into the .aspx
file.
In the ItemDataBound event just do:
myString = e.item.Cells(x).text 'the number without editing mask
myInteger = val(myString)
e.item.cells(x).text = myInteger.tostring("##%")

Works great!
T

This is what I did, it is not very good, but will allow you to do
processing.

Example:
On the aspx/ascx page, I would like to retrieve the the date for the the
particular record
so i call a function coded in the aspx.cs/ascx.cs which is GetDate, I will
pass in the record in the datagrid

<%# GetDate(Container.DataItem) %>

On the aspx.cs/ascx.cs, I will process the dataItem, which return the
short date for my datagrid

public string GetDate(Object obj)
{
string topicDate = ((DataRowView)obj)["topicDate"].ToString();
return Convert.ToDateTime(topicDate).ToShortDateString();
}

-----------------------------------------------------------------

If you would like a better and much more professional way, this article
might help

http://openmymind.net/databinding/index.html

Joey

I have a datagrid where I specified {0:###,###,###} at design time.
However sometimes I am putting percentages in the grid instead of money
and I want to change the formating to {##%}. I've looked over the docs on
such things as the dataformatstring porperty of the boundColumn but still
can't figure out how to do it in code.

Thank,
T