DateTime data displaying

[Thad]

I am getting data from a SQL Server 7 table and binding it to a grid.
I have a field that is supposed to represent a date, and two fields
that are supposed to represent time.

When I look at the grid the date value is just the date (because I
guess I didn't enter a time, but just a date), but the time value only
displays the date and not the time, but when I look at that column in
the Admin it shows that data there with today's date (date I entered
the time value).

What am I missing here? I just want the time value to be displayed and
kept in the time column, and the date to be the only value in the date
column.

Do I have to do formatting commands on my Select statement to load the
data, and on my update and insert statements? I haven't tried that
yet, I'm hoping I don't have to, that seems excessive. I'm used to
just date, just time, or datetime. Anyway, thanks for any replies in
advance.

Thad

 

[W.G. Ryan eMVP]

You can set a DataGridTableStyle then format the columsn via the
DataGridColumnStyles. If you need to do it with Textboxes or other controls
you can use the Format Event and the Parse event.
http://msdn.microsoft.com/library/d...SystemWindowsFormsBindingClassFormatTopic.asp

HTH,

Bill