?
Solved

UltraWinGrid - How to display Date and Time in same column

Posted on 2008-06-10
2
Medium Priority
?
5,308 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 17

Accepted Solution

by:
ZeonFlash earned 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand column That will then direct you to their download page. From that p…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
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…

718 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