Format string problem

[Jota]

Hi...

I have a radgridview linked to a datasource.

One of the columns (a decimal column) takes the data from an integer value in the database... this value represents a time, but I can´t change the type in the database.

I want to show the value in a HH:MM:SS format.
To do that in other situations I just set a string.Format this way:
string.format("{0:00}:{1:00}:{2:00}", value/3600, (value%3600)/60,(value%3600)%60)

Is there a way to apply this custom format to the column?

I´ve tried using a date format in the FormatString property of the columm this way: {0:hh.mm.ss} but then the columm shows data like this "hh.Valuemm.ss" (Value is the integer in the column, like 4 or whatever).

Any help will be welcomed

Thanks in advance

[Emanuel Varga]

Hello,

I have a proposal for you, it's not a very clean one but it will do what you need,
You should handle the CellFormatting event and just format the displayed text in the cell
Something like this:

void radGridView1_CellFormatting(object sender, CellFormattingEventArgs e)
{
    if (e.Column.FieldName != "Time")
    {
        return;
    }

    e.CellElement.Text = GetText(e.CellElement.Value);
}

private string GetText(object value)
{
    if (value == null || string.IsNullOrEmpty(value.ToString()) || !(value is int))
    {
        return null;
    }
    var intValue = Convert.ToInt32(value);
    var seconds = intValue % 100;
    var minutes = (intValue / 100) % 100;
    var hours = (intValue / 10000) % 100;
    return string.Format("{0,2:00}:{1,2:00}:{2,2:00}", hours, minutes, seconds);
}

Hope this helps, if you have any other questions or comments, please let me know,

Best Regards,
Emanuel Varga

Telerik WinForms MVP

[Jota]

Thanks a lot Emanuel... that made the trick...

[Ivan Petrov]

Hello Jota,

Thank you for writing.

The solution Emanuel has provided is the best approach for this scenario.

If you have other questions, do not hesitate to write back. 

Best wishes,
Ivan Petrov
the Telerik team