Change date format in C# when reading from database and setting to label

Question

I am trying to read a date field from database and set it to a label field. Im using the following code,

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ConnectionString);
con.Open();

SqlCommand cmd = new SqlCommand("select BirthDate from Student where Name=@name", con);
cmd.Parameters.AddWithValue("@name", "Mano");

SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);

lblName.Text = dt.Rows[0]["Date"].ToString();

But this displays the data value in label in the format 02-05-1991 00:00:00 but I want to display it in format dd-mm-yyyy as 05-02-1991. So I tried the following code:

lblName.Text = dt.Rows[0]["BirthDate"].ToString("dd-mm-yyyy");

But it shows this error:

No overload for method ToString takes 1 argument

How can I change the format?

Steve · Accepted Answer · 2016-10-08 13:56:26Z

1

You need to treat your date value as a DateTime and then call the overload of ToString from the DateTime structure that has the required formatting option.

Actually you are converting the row value to a string and a string knows nothing about how to format a date.

DateTime t = dt.Rows[0].Field<DateTime>("Date");
lblName.Text = t.ToString("dd-MM-yyyy");

Also pay attention to the correct format for the Months part. It is an uppercase M. The lowercase m is for minutes.

edited Oct 8, 2016 at 13:56

answered Oct 8, 2016 at 13:42

Steve

217k22 gold badges242 silver badges296 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Grant Winney · Accepted Answer · 2016-10-08 13:43:16Z

0

Assuming BirthDate represents a valid DateTime, convert it before calling ToString().

lblName.Text = Convert.ToDateTime(dt.Rows[0]["BirthDate"]).ToString("dd-mm-yyyy");

You're currently calling the ToString() method on the object class, not the DateTime class, so there's no overload that allows for a date formatter.

answered Oct 8, 2016 at 13:43

Grant Winney

66.6k13 gold badges120 silver badges167 bronze badges

2 Comments

Mano Prathibhan C Over a year ago

Its working im using date format in SQL table..with value 05-02-1991 but in C# when i give format as dd-mm-yyyy it displays in label as 02-05-1991 does this means SQL stores date format as mm-dd-yyyy ??

Dour High Arch Over a year ago

No, it means the given format string is wrong, it should be dd-MM-yyyy as mm in DateTime formats mean minutes not months.

Collectives™ on Stack Overflow

Change date format in C# when reading from database and setting to label

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related