String was not recognized as a valid DateTime

Posted by Mandlaa under ASP.NET on 6/13/2013 | Points: 10 | Views : 2015 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I am inserting date value to database,My table column datatype is date

SqlParameter validUntil = new SqlParameter("@ValidUntil", SqlDbType.Date);
//validUntil.Value = TextBox2.Text.ToString();
validUntil.Value = Convert.ToDateTime(TextBox2.Text.ToString());
cmd.Parameters.Add(validUntil);
At the time of inserting getting Error like this:::String was not recognized as a valid DateTime in asp.net

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Allemahesh on: 6/13/2013 [Member] [MVP] Silver | Points: 25

0	You can use this : DateTime date = DateTime.ParseExact(TextBox2.Text.ToString(), "dd/MM/yyyy", null); validUntil.Value = date; Hope this will help you. Mandlaa, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts