string was not recognized as a valid datetime

Accepted answer

hi divya,

use DateTime.TryParseExact to convert string to datetime.

try..

string date = dgvCompanyExpences.SelectedRows[0].Cells[2].Value.ToString(); //"06/26/2012";
DateTime d;
CultureInfo enUS = new CultureInfo("en-US");
bool f = DateTime.TryParseExact(date, "MM/dd/yyyy", enUS, DateTimeStyles.None, out d);

In variable "d" you can get Converted DateTime.

hope this will help you.

divya14y ago

Thanku Trivedi,

I got the solution,thank u

your post saved me a bunch of time..

divya14y ago

Getting date format like "06/26/2012"

still iam getting the same problem,In database date is defined as datetime datatype..

Mahesh Chand14y ago

First check what is the value of dgvCompanyExpences.SelectedRows[0].Cells[2].Value.ToString().

Something like this

string str = dgvCompanyExpences.SelectedRows[0].Cells[2].Value.ToString();

Debug this and see if str looks like a string. This is the problem.