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 T P · 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 ?