How to convert date In Select Btn ??

Question

Hi Programmers Label2.Text = reader.GetString(25); Label2 above is Date 25 is arrangement in TBL

Tapan Patel · Answer

As you have specific date format, you need to parse it in that way. Please try below. DateTime dt=DateTime.ParseExact(reader.GetString(25), "yyyy-MM-dd" ,cultureinfomation);

Jisny Av · Answer

Hi, Try this Label2.Text = reader.GetString(25); string str = DateTime.Now.Month + "/" + Convert.ToInt16(Label2.Text) + "/" + DateTime.Now.Year; DateTime dt = Convert.ToDateTime(str); Label2.Text = dt.ToString("dd/MMM/yyyy");

Vishal Jadav · Answer

Hi, Don't convert the date-time and just put the result value as it is and check the value. Thanks.

Rajeesh Menoth · Answer

Hi, Try this code : while (reader.Read()) { Label2.Text = reader.GetString(26); } Put a break point and check what value getting in the following line.. Label2.Text = reader.GetString(25);

Abdalla Elawad · Answer

PLS SEE BELOW

Abdalla Elawad · Answer

I will Check anything Please see the Editing Raws and Arrangement of column in TBL

Vasanth Natarajan · Answer

pls check every column has null or not null, i think that 25th column values is null from DB. so, Pls Check the DB Value for 25th column it should not be null or Char values

Abdalla Elawad · Answer

thank You , below the code

Vishal Jadav · Answer

Hi, Can you please provide the code ? Thanks...

Vasanth Natarajan · Answer

hi Try This.... while (reader.Read()) { TextBox3.Text = Convert.ToDateTime(reader[ "DateField" ]).ToString("yyyy-MM-dd"); }

Abdalla Elawad · Answer

Not Run

Vinay Singh · Answer

If your date format in table is 2015-08-21. then why you are trying to convert 25 as date

Rajeesh Menoth · Answer

Hi, Your reader.GetString(25); return empty value. So you need to check it's empty or not before assign to datetime. Try this code : DateTime dt = Convert.ToDateTime(reader.GetString(25) == "" ? "01/01/0001" : reader.GetString(25)); or Label2.Text = reader.GetString(25); if (! string .IsNullOrWhiteSpace(Label2.Text)) { DateTime dt = Convert.ToDateTime(reader.GetString(25)); }

Vasanth Natarajan · Answer

try this.. DateTime? dt = null; if (Label2.Text.ToString() == "") { dt= null; Label3.Text= ""; } else { dt= Convert.ToDateTime(reader.GetString(25)); Label3.Text= String.Format("{0:yyyy-MM-dd}", dt); }

Abdalla Elawad · Answer

reader doesn't return data like below label2.Text=reader.Getstring (25); Show error on Exec

Abdalla Elawad · Answer

This Date Format in TBL "2015-08-21"

Vinay Singh · Answer

Hi Please let me know what the format of date you need

Abdalla Elawad · Answer

No Run Also Error

Vinay Singh · Answer

Hi As i can understand 25 is a no and you want to convert it into date, to display in label control. Here you have to pass the month or you provide the format of date which you want to display on label control. DateTime dt = Convert.ToDateTime(reader.GetString(25)+"/01/0001"); Label2.Text= dt.ToString("dd/MM/yyyy");

Abdalla Elawad · Answer

This message display when exe cute your Code

Midhun Tp · Answer

Hi, Try this - DateTime dt = Convert.ToDateTime(reader.GetString(25)); Label2.Text= dt.ToString("dd/MM/yyyy");

Esakki Muthu · Answer

Hi Abdalla, Try the below code, Convert.ToDateTime(MyReader["OutBoundDate"]).ToString("dd/MM/yyyy");

Rajeesh Menoth · Answer

Hi, What value getting on " reader.GetString(25) " ? Is returning any datetime or string value ?

How to convert date In Select Btn ??

Answers (23)