Solved

UltraWinGrid - How to display Date and Time in same column

Posted on 2008-06-10
2
5,047 Views
Last Modified: 2013-11-15
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
Comment
Question by:wayneburr
2 Comments
 
LVL 17

Accepted Solution

by:
ZeonFlash earned 500 total points
ID: 21756472
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
 

Author Closing Comment

by:wayneburr
ID: 31465949
Added the solution to grdMaterialLookup_InitializeLayout and worked like a charm.  Thanks!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now