C#時(shí)間差計(jì)算與數(shù)據(jù)庫操作結(jié)合

在C#中可以使用DateTime類來計(jì)算時(shí)間差，并結(jié)合數(shù)據(jù)庫操作來存儲時(shí)間差數(shù)據(jù)。以下是一個(gè)示例代碼：

using System;
using System.Data.SqlClient;

class Program
{
    static void Main()
    {
        DateTime startTime = DateTime.Now;
        
        // 進(jìn)行一些操作...
        
        DateTime endTime = DateTime.Now;
        
        TimeSpan timeDiff = endTime - startTime;
        
        // 將時(shí)間差存儲到數(shù)據(jù)庫中
        string connectionString = "Data Source=myServerAddress;Initial Catalog=myDatabase;User Id=myUsername;Password=myPassword;";
        
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            connection.Open();
            
            string query = "INSERT INTO TimeDiffTable (TimeDifference) VALUES (@timeDiff)";
            
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                command.Parameters.AddWithValue("@timeDiff", timeDiff.TotalSeconds);
                
                command.ExecuteNonQuery();
            }
        }
        
        Console.WriteLine("Time difference: " + timeDiff);
    }
}

在這個(gè)示例中，首先獲取開始時(shí)間和結(jié)束時(shí)間，然后計(jì)算時(shí)間差并將其存儲到數(shù)據(jù)庫中。在存儲時(shí)間差時(shí)，我們將時(shí)間差轉(zhuǎn)換為總秒數(shù)以便在數(shù)據(jù)庫中存儲。最后輸出時(shí)間差值。

請確保替換示例中的數(shù)據(jù)庫連接字符串和表名等信息以適應(yīng)您的實(shí)際情況。