I'm having trouble converting timespan and I not what to do now. My code is below and this is the error I get
Unable to cast object of type 'System.TimeSpan' to type 'System.IConvertible'.
DateTime dtStart = new DateTime(1949, 2, 1);
DateTime dtEnd = new DateTime(1996, 7, 28);
TimeSpan ts = dtEnd - dtStart;
##########The part where the problem is I believe########### DateTime randDate = Convert.ToDateTime(ts); //+ nTs;
DateTime dtOverall = DateTime.Now;
int age = dtOverall.Year - randDate.Year;
conn.Open();
string inQuery = "insert into Customer (CustID, Name, DateOfBirth, Age, Country,Salary) values (@CustID, @Name, @DateOfBirth, @Age, @Country, @Salary)";
SqlCommand commm = new SqlCommand(inQuery, conn);
Guid newGUID = Guid.NewGuid();
commm.Parameters.AddWithValue("@CustID", newGUID.ToString()); Go to the complete details ...