初學者做網站

protected void Page_Load(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=mydata;User Id=sa;Password=1234");
conn.Open();
/*
SqlCommand cmd = new SqlCommand("Insert into Item_Detail(Deadline)values(@paradl)",conn);
cmd.Parameters.Add("@paradl", SqlDbType.NVarChar).Value = DateTime.Now.AddDays(10).ToString("yyyy-MM-dd HH:mm");
cmd.ExecuteNonQuery();

cmd.Cancel();
cmd.Dispose();
*/

SqlDataAdapter ad = new SqlDataAdapter("Select Deadline From Item_Detail Where Item_ID='233'", conn);
DataTable dt = new DataTable();
ad.Fill(dt);

以for迴圈去改變然後取得最終多筆資料的剩餘時間

for (int i = 0; i < dt.Rows.Count; i++)
{
String c = null;
DateTime a, b;
a = Convert.ToDateTime(dt.Rows[i]["Deadline"]);
b = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm"));
c = DataDiff(a, b);
dt.Rows[i]["Deadline"] = c;
}

}
protected string DataDiff(DateTime time1,DateTime time2)
{
string datadiff = null;
TimeSpan ts1 = new TimeSpan(time1.Ticks);
TimeSpan ts2 = new TimeSpan(time2.Ticks);
TimeSpan ts = ts1.Subtract(ts2).Duration();
datadiff = ts.Days.ToString() + "天" + ts.Hours.ToString() + "小時" + ts.Minutes.ToString() + "分";
return datadiff;
}