62,016
社区成员
发帖
与我相关
我的任务
分享
public string dateDiff(DateTime DateTime1, DateTime DateTime2)
{
string dateDiff = "";
try
{
TimeSpan ts1 = new TimeSpan(DateTime1.Ticks);
TimeSpan ts2 = new TimeSpan(DateTime2.Ticks);
TimeSpan ts = ts1.Subtract(ts2).Duration();
dateDiff = ts.Days.ToString() + "Days" +
ts.Hours.ToString() + ":"
+ ts.Minutes.ToString() + ":"
+ ts.Seconds.ToString() + "."
+ ts.Milliseconds.ToString() ;
}
catch
{
}
return dateDiff;
}
Stopwatch stopwatch = new Stopwatch();
stopwatch.Start();
for (int i = 0; i < count; i++)
{
SqlHelper.ExecuteNonQuery(SqlHelper.SqlConnection, CommandType.Text, "insert into passport(PassportKey) values('" + Guid.NewGuid() + "')"); //看看insert所花费的时间
}
stopwatch.Stop();
return stopwatch.ElapsedMilliseconds; //返回时间