C#提取数据库中日期的年份与当前日期的年份的差值

发布网友发布时间：2024-10-16 22:58

共1个回答

热心网友时间：2024-11-21 07:34

string sql = "select birthday from 你的表 where 条件";
SqlConnection conn = new SqlConnection(“Data Source=数据库实例名;Initial Catalog=数据库;Integrated Security=True”);
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
try
{
conn.Open();
sda.Fill(ds);

}
catch (System.Data.SqlClient.SqlException ex)
{
throw new Exception(ex.Message);
}
finally
{
sda.Dispose();
cmd.Dispose();
conn.Close();
}

DateTime aa = (Convert.ToDateTime(ds.Tables[0].Rows[0]["birthday"].ToString())).ToString("yyyy-MM-dd");
DateTime bb = DateTime.Now.ToString("yyyy-MM-dd");
TimeSpan cc = bb- aa;
int 计算工龄= Convert.ToInt32(cc.TotalDays/365)