Format date in asp.net

Question

3.00/5 (1 vote)

See more:

this Code Retrieve Date From SQL Database

C#

LblExpirydate.Text = dataReader(0).ToString()

output : 01/05/2013 12:00:00 AM

i want to change format to (01/05/2013)

Posted 29-Mar-13 23:06pm

hany1002

Add a Solution

Comments

Neetesh Agarwal 30-Mar-13 5:10am

You can try Substring()

Neetesh Agarwal 30-Mar-13 5:12am

dataReader(0).Substring(0,10)

6 solutions

Solution 1

C#

LblExpirydate.Text = dataReader(0).ToString("d")

Posted 29-Mar-13 23:17pm

S R JHALA

Comments

hany1002 30-Mar-13 5:23am

it return me this error in the same line (LblExpirydate.Text = dataReader(0).ToString("d"))

Error : Conversion From Sting "d" to 'integer' is not valid

connectionString = ConfigurationManager.ConnectionStrings("conString").ToString
connection = New SqlConnection(connectionString)
connection.Open()
command = New SqlCommand("SELECT Max(Expirydate) FROM Act WHERE Skey = '" & Request.QueryString("ID") & "'", connection)
dataReader = command.ExecuteReader
dataReader.Read()
LblExpirydate.Text = dataReader(0).ToString("d")
connection.Close()

sql database

ActID int Unchecked
Skey nvarchar(100) Checked
Expirydate date Checked

Solution 2

LblExpirydate.Text = dataReader(0).ToString("dd-MM-yyyy")

Posted 29-Mar-13 23:19pm

Gopinath_Rajan

Solution 3

it return me this error in the same line (LblExpirydate.Text = dataReader(0).ToString("d"))

Error : Conversion From Sting "d" to 'integer' is not valid

C#

connectionString = ConfigurationManager.ConnectionStrings("conString").ToString
        connection = New SqlConnection(connectionString)
        connection.Open()
        command = New SqlCommand("SELECT Max(Expirydate) FROM Act WHERE Skey = '" & Request.QueryString("ID") & "'", connection)
        dataReader = command.ExecuteReader
        dataReader.Read()
        LblExpirydate.Text = dataReader(0).ToString("d")
        connection.Close()

sql database

ActID int Unchecked
Skey nvarchar(100) Checked
Expirydate date Checked

Posted 29-Mar-13 23:23pm

hany1002

Comments

Neetesh Agarwal 30-Mar-13 5:24am

dataReader(0).Substring(0,10)

hany1002 30-Mar-13 5:28am

Same error

Notes :

sql database

ActID int Unchecked
Skey nvarchar(100) Checked
Expirydate date Checked

hany1002 30-Mar-13 5:29am

Error : Public member 'Substring' on type 'Date' not found.

Ayush Nautiyal 17-Oct-14 6:59am

how to convert 05/01/2014 to 5th Jan,14

Solution 4

Hi!!! try this
query

SQL

SELECT FORMAT ( GETDATE(), 'DD/MM/YYYY', 'en-US' ) AS DateConvert;

or use like this in asp.net c#

C#

string timeString = "30/03/2013 13:30:00.000";
IFormatProvider culture = new CultureInfo("en-US", true); 
DateTime dateVal = DateTime.ParseExact(timeString, "dd/MM/yyyy", culture);

Posted 29-Mar-13 23:29pm

Shubham Choudhary

Updated 29-Mar-13 23:33pm

v2

Comments

hany1002 30-Mar-13 5:45am

that is my code how can i change it

connectionString = ConfigurationManager.ConnectionStrings("conString").ToString
connection = New SqlConnection(connectionString)
connection.Open()
command = New SqlCommand("SELECT Max(Expirydate) FROM Act WHERE Skey = '" & Request.QueryString("ID") & "'", connection)
dataReader = command.ExecuteReader
dataReader.Read()
LblExpirydate.Text = dataReader(0).ToString("d")
connection.Close()

Solution 6

Use the query Select Convert(DateField,VarChar,103) from TableName

Posted 16-May-14 1:00am

Member 10505819

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

hany1002 · Accepted Answer · 2013-03-30T01:32:00

Solution 5

Solution :

C#

LblExpirydate.Text = String.Format("{0:dd/MM/yyyy}", dataReader(0))

Posted 30-Mar-13 1:32am

hany1002