• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5440
  • Last Modified:

UltraWinGrid - How to display Date and Time in same column

I'm using NetAdvantage 2006 Volumne 2 CLR 2.0.

I have a grid that I manually update the datasource with a stored Procedure.  I have a Column that is  defined as date/time and also defined as type date/time in the grid layout.  What I need is the Data nd Time to display in the column.  the values show as date-time in the datarows in SQL Server.
Can this be accomplished and How.

Thanks
Mlookup-Date.jpg
0
wayneburr
Asked:
wayneburr
1 Solution
 
ZeonFlashCommented:
Change the "Format" property of the date column to use the format string you desire;  probably something along the lines of "MM/dd/yyyy hh:mm:ss tt" in order to get "06/10/2008 9:57:23 PM".
UltraGrid1.DisplayLayout.Bands(0).Columns("DateColumn").Format = "MM/dd/yyyy hh:mm:ss tt"

Open in new window

0
 
wayneburrAuthor Commented:
Added the solution to grdMaterialLookup_InitializeLayout and worked like a charm.  Thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now