Formatting fields in a datatable

[Rotsey]

Hi,

I have written a custom multi column listbox control that I pass a
datatable to.

the issue is that if there are date fields then these may
be in the wrong format or any other field formatting

So when I create the control I pass a object that defines
the label, width and format of each column.

How do I use the format field (which is a string) to generically
format a any field the in the datatable.

mystring = dr.ToString(myheader.Format];

Something like that is what I want to do.

But ToString doesn't support format

any ideas
rotsey.

 

[Marc Gravell]

Well, you could check if dr supports IFormattable; this has a
ToString(string format, IFormatProvider formatProvider)

Marc

 

[Rotsey]

Sorry dr is a DatatRow object

I don't think it does.

Any other ideas?

 

[Marc Gravell]

Sorry dr is a DatatRow object
precisely: hence, dr is the value of the i'th column, i.e. the
value you want to format... so if your column is a date, then this is
a boxed DateTime - which *does* implement IFormattable:

object val = dr;
IFormattable fVal = val as IFormattable;
string sVal = fVal == null ? Convert.ToString(val)
: fVal.ToString(format, CultureInfo.CurrentCulture);

Marc

 

[Rotsey]

ok thanks

Sorry dr is a DatatRow object

precisely: hence, dr is the value of the i'th column, i.e. the value
you want to format... so if your column is a date, then this is a boxed
DateTime - which *does* implement IFormattable:

object val = dr;
IFormattable fVal = val as IFormattable;
string sVal = fVal == null ? Convert.ToString(val)
: fVal.ToString(format, CultureInfo.CurrentCulture);

Marc