How to get date time value from data row

Hi,

I am trying to get the date of birth of employees from data row of the
datatable but getting the exception " String was not recognized as a
valid DateTime".

Please help me to get the value of type date time from data row.

 



The following is the my code.

 



List employeeList = new List();

foreach (DataRow dr in dt.Rows)

{

DateTime t = DateTime.Now;

employeeObject.EmployeeID = Convert.ToInt64(dr["empId"]);

employeeObject.EmployeeFirstName = Convert.ToString(dr["empFirstName"]);

employeeObject.EmployeeMiddleName = Convert.ToString(dr["empMiddleName"]);

employeeObject.EmployeeLastName = Convert.ToString(dr["emptLastName"]);

employeeObject.EmployeeGenderStr = Convert.ToString(dr["empGender"]);

employeeObject.EmployeeDateOfBirth = Convert.ToDateTime(dr["empDOB"]);

//employeeObject.EmployeeDateOfBirth =
DateTime.ParseExact(dr["empDOB"].ToString().Replace(";", " "), "m/d/yyyy
hh:mm:ss", CultureInfo.InvariantCulture);//
DateTime.Parse(dr["empDOB"].ToString());

// employeeObject.EmployeeDateOfBirth =
Convert.ToDateTime(dr["empDOB"].ToString().Replace(";", " "),
System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat);
;

employeeObject.EmployeeContactno = Convert.ToDouble(dr["empContactNo"]);

employeeObject.EmployeeEmailId = Convert.ToString(dr["empEmailId"]);

employeeObject.EmployeeAddress = Convert.ToString(dr["empAddress"]);

employeeObject.EmployeeDesignation = Convert.ToString(dr["empDesgnation"]);

employeeList.Add(employeeObject);