datagrid data conversion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a datagrid listing data from a database, and I am getting from the
database real value (it's actually represents a total of minutes).

What I want to do is Convert that number to a total of hours and minutes
like this:
on database: 70,5
on datagrid: 01:10:30

How can I do that conversion?
 
That did not helpme to much I must get the values and do the calcs and them
format the result....
 
Then create another datacolumn and do the computation in it. Unless your
computation is really complex then you should be able to do it with the
..Expression property
"Diogo Alves - Software Developer"
 
Well I have the total minutes, for example 130,5 I need to divide it 60 to
get the hours value (in this example is 2) and then the mod to get (in this
example 10)...

Could you give me a hint in how to do it?

Thanks for your help and patience
 
Lets say I have this:
515.38977050 in the total minute... I can't retrieve the value do the
operations and and it to the other column.... I just need to convert a double
to a time format... :(
 
In Sql Server, if you have the time in seconds, if you use this, it will
come in the grid formatted, otherwise I think you need to write some
formatting...

CONVERT(VARCHAR,DATEADD(s,ColumnName,'19000101'),8) AS 'Alias'
"Diogo Alves - Software Developer"
 
Back
Top