I my SQL Datareader I am loading the date data into text box.
Here is my code
txtActOpenDate. Text = MyDataReader("A ctOpenDt").ToSt ring()
txtActOpenDate. Text is displaying the date and time.
How to display the date alone here.
Thanks for your advice.
Gary 3 1389
Cast your value to a date or datetime type and tell it the format to
display.
Ctype(MyDataRea der("ActOpenDt" ), DateTime).ToSho rtDateString
If the data value can be null use
String.Format(" {0:d}",MyDataRe ader("ActOpenDt ").ToString )
null values get returned as an empty string. The little "d" tells the
system to format as short date value.
Enjoy,
Yogs www.stellarodyssey.com
"Gary Smith" <GS******@yahoo .com> wrote in message
news:Oj******** ******@TK2MSFTN GP12.phx.gbl... I my SQL Datareader I am loading the date data into text box.
Here is my code
txtActOpenDate. Text = MyDataReader("A ctOpenDt").ToSt ring()
txtActOpenDate. Text is displaying the date and time. How to display the date alone here. Thanks for your advice. Gary
It would be easier to modify your sql query. Try CONVERT or DATEPART
functions.
Hope this helps,
"Gary Smith" <GS******@yahoo .com> wrote in message
news:Oj******** ******@TK2MSFTN GP12.phx.gbl... I my SQL Datareader I am loading the date data into text box.
Here is my code
txtActOpenDate. Text = MyDataReader("A ctOpenDt").ToSt ring()
txtActOpenDate. Text is displaying the date and time. How to display the date alone here. Thanks for your advice. Gary
You're almost there:
txtActOpenDate. Text = MyDataReader("A ctOpenDt").ToSt ring("mm/dd/yyyy")
--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"Gary Smith" <GS******@yahoo .com> wrote in message
news:Oj******** ******@TK2MSFTN GP12.phx.gbl... I my SQL Datareader I am loading the date data into text box.
Here is my code
txtActOpenDate. Text = MyDataReader("A ctOpenDt").ToSt ring()
txtActOpenDate. Text is displaying the date and time. How to display the date alone here. Thanks for your advice. Gary
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: sunny076 |
last post by:
Hi,
I am trying to convert from Julian to Gregorian data in C#. I was
exploring teh JulianCalendar and Gregorian calendar classes but still
not sure how I can do it. For example, the Julian date is 100033 and I
know that it is 2/2/2000 in Gregorian.
I would appreciate if anyone can help point me out.
|
by: ree32 |
last post by:
I am having problems with Date Strings when using VS.net method of
converting an XML document to a dataset.
I need the the date nodes to be of date type. As I am loading the
Dataset to a datagrid, and I using the sort facility to sort by date.
Currently the dates are being treated as strings.
|
by: Dana Shields |
last post by:
I am attempting to upsize from access to SQL Server. I'm trying to convert
my queries to SQL Server views; however, I'm having a lot of difficulty with
the syntax differences.
For instance, a query with select mid(tblTable.FieldName,1,10)should look
something like select substring(tblTable.FieldName,1,10).
This is really the simplest of examples. I've tried using the SQL Server
Import tool, but it takes the queries and changes them...
|
by: John Ortt |
last post by:
Hi All,
I have a database in Access 97 which works fine but our company is
converting from NT4 to XP Pro and in the process changing Office 97 for
Office 2003. I have tried to convert the 97 database into Access 2003 but
the Autoexec macro falls over on the query below. I have tried running it
separayely and the computer just hangs.
I realise there is a lot of code below, but I'm hoping somebody may know
what they are looking for...
|
by: Robert |
last post by:
I have a series of web applications (configured as separate applications) on
a server.
There is a main application at the root and then several virtual directories
that are independant applications.
I am testing an upgrade of all of the sites and have converted the main root
site...although not necessarily fixed any issues.
I move on instead and converted one of the virtual roots that is a seperate
| |
by: savigliano |
last post by:
hello, i am doing a date comparation and i have reallize that the data
i have in my database (general date format) it is causing me problems,
and because i don´t need the time data i would like to convert all the
general date data into short date format, so i would like to delete the
time part of the data, it is any way i can do that ????
Thank you in advance and sorry for my english
carlos
|
by: marc |
last post by:
hi
im trying to convert Date() into a unix timestamp so i can stick the
result into a mysql db, please help!
|
by: zshenk |
last post by:
I need help converting dates. Currently, I have several tables and
databases that use the format 1/20/2007. I have a table right now
that uses the 20070120 format, and I was hoping that someone could
help me convert this. Thanks!
|
by: Jef Driesen |
last post by:
How can I convert a date string to a number (e.g. a time_t value or a tm
struct)? I know about the strptime function, but then I have to know the
format string. And that is a problem.
I'm trying to autoformat the contents of text entries in a GUI. For
numbers, I'm converting the text representation to the appropriate type
(using atoi, atof, ...) and converting the result back to text with the
correct format (using sprintf). But this does...
|
by: rob41 |
last post by:
I'm in the process of converting numerous queries from access 07 to sql server 05 to improve runtime performance. Below is a sample of code and the error I'm getting.
INSERT INTO
( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , )
SELECT ., ., ., LTrim(.) AS Expr1, LTrim(.) AS , LTrim(.) AS , LTrim(.) AS , LTrim(.) AS , LTrim(.) AS , LTrim(.) AS , LTrim(.) AS , LTrim(.) AS ,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |