1. 利用 System.Data.Linq.SqlClient.SqlMethods类
SqlMethods.DateDiffDay(StartDate, EndDate)
2. 利用 System.TimeSpan类
DateTime dt = Convert.ToDateTime("2009-09-13").Date;
DateTime de = DateTime.Now.Date;
System.TimeSpan ts = dt.Subtract(de);
lblDate.Text = "天" + ts.Days.ToString() + "小时" + ts.Hours.ToString()
+ "秒数" + ts.Minutes.ToString() + "毫秒" + ts.Seconds.ToString();
转载于:https://www.cnblogs.com/myoungho/archive/2009/09/12/1565467.html