«

I have a column in my database that stores total seconds. I want to
bind this colum to my datagrid. Is there a way to have the time show
as hours, minutes, and seconds without me having to build a custom
function to handle this.

The database column value is: 120 seconds

I want it to say "2 Minutes" or "0:02:00".

Any ideas?

Thanks!

you mean as in a setting? no. you have to handle the itemdatabound event and
do something like
DateTime time = DateTime.Parse(e.Item.Cells[index].text );
e.Item.Cells[index].text = Datelabel.Text = time.ToString("hh:mm:ss");
roughly


--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok
"Eric" <> wrote in message
news: m...
>I have a column in my database that stores total seconds. I want to
> bind this colum to my datagrid. Is there a way to have the time show
> as hours, minutes, and seconds without me having to build a custom
> function to handle this.
>
> The database column value is: 120 seconds
>
> I want it to say "2 Minutes" or "0:02:00".
>
> Any ideas?
>
> Thanks!