yyyy-MM-dd HH:mm:ss:fff dateformat & datagrid

  • Thread starter Thread starter jobi
  • Start date Start date
J

jobi

Hi,

I've tried to get to this formatting stuff once, a while ago.

I still didn't figure out how to format a date-column in a (data)-grid.
I have a dynamic query that returns a # of columns.
When it contains datetime-columns, I want these columns formatted like
SQLServer-datetimeformat 121.
I don't want the query to return datetime-columns converted to strings
because they are used for calculations

I want to hide some columns from the grid. Should I do this by setting the
with to zero ?

I am also looking for an "autowith"-activation for all columns of that grid.

Thanks,

Jobi
 
Hi Jobi,

Have a look what this can do for you
http://msdn.microsoft.com/library/d...ormsdatagridtextboxcolumnclassformattopic.asp

And have a look for datagridcolumnstyles and datagridstyles for the other
questions.

I think it will help you?

Cor
I still didn't figure out how to format a date-column in a (data)-grid.
I have a dynamic query that returns a # of columns.
When it contains datetime-columns, I want these columns formatted like
SQLServer-datetimeformat 121.
I don't want the query to return datetime-columns converted to strings
because they are used for calculations

I want to hide some columns from the grid. Should I do this by setting the
with to zero ?

I am also looking for an "autowith"-activation for all columns of that
Click to expand...
grid.
 
Jobi, Do you know One Kenobi ?

lol

OHM
Hi,

I've tried to get to this formatting stuff once, a while ago.

I still didn't figure out how to format a date-column in a
(data)-grid.
I have a dynamic query that returns a # of columns.
When it contains datetime-columns, I want these columns formatted like
SQLServer-datetimeformat 121.
I don't want the query to return datetime-columns converted to strings
because they are used for calculations

I want to hide some columns from the grid. Should I do this by
setting the with to zero ?

I am also looking for an "autowith"-activation for all columns of
that grid.

Thanks,

Jobi
Click to expand...

Regards - OHM# OneHandedMan{at}BTInternet{dot}com
 
Back
Top