String was not recognized as a valid DateTime

Aamir Khan

14y1.5k.NET

Hi frnds,
i am getting the following error when i am updating the date in gridview
Error: String was not recognized as a valid DateTime

my code is as follows:
cmd.Parameters.Add("@waiverDate", SqlDbType.DateTime).Value = Convert.ToDateTime(((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1")).Text).ToShortDateString();

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aamir Khan14y ago
dear Friends, problem got solved by this code: IFormatProvider provider = new System.Globalization.CultureInfo("en-CA", true); string datetime = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox1")).Text.Trim(); cmd.Parameters.Add("@waiverDate", SqlDbType.DateTime).Value = DateTime.Parse(datetime,provider,System.Globalization.DateTimeStyles.NoCurrentDateDefault);
Aamir Khan14y ago
hi frnds, the problem is while i select date like till 11-06-2012 from my web form its getting update proper in table....but whn i do select bigger date from 12 like 13-04-2012 or 29-04-2012 then only i get the Format error...in database values are stored in this way 2012-11-06...what could be the reasons...pls let me know
Kunal Vaishya14y ago
Dear Make Sure that DateTime Formate is MM/dd/yyyy or Not because Sql Cant save another Formate
Suthish Nair14y ago
Do have a Control null check before converting to datetime.
Jignesh Trivedi14y ago
Hi Amir,

Try following code

string date = "12/07/2012";
DateTime d;
CultureInfo enUS = new CultureInfo("en-US");
bool f = DateTime.TryParseExact(date, "dd/MM/yyyy", enUS, DateTimeStyles.None, out d);
cmd.Parameters.AddWithValue("@waiverDate", d);
On base of your culture and format you can parse your date.
hope this will help you.