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

[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

[Cor]

Hi Jobi,

Have a look what this can do for you
http://msdn.microsoft.com/library/de...ormattopic.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

grid.

[jobi]

Hey, you know my mentor :))

May the force be with you ..
"One Handed Man [ OHM# ]" <OneHandedMan{at}BTInternet{dot}com> wrote in
message news:#p**************@TK2MSFTNGP10.phx.gbl...

Jobi, Do you know One Kenobi ?

lol

OHM

jobi wrote:

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

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

[jobi]

Thanks for the info.

I'll try it out.

jobi
"Cor" <no*@non.com> wrote in message
news:eW**************@TK2MSFTNGP11.phx.gbl...

Hi Jobi,

Have a look what this can do for you
http://msdn.microsoft.com/library/de...us/cpref/html/
frlrfsystemwindowsformsdatagridtextboxcolumnclassf ormattopic.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

grid.