ixjngtv

2008-06-13

顯示近七天資料

  • 2179
  • 0

顯示近七天資料

             string.Format("Select * from *** where timestamp Between '{0}' and '{1}'", DateTime.Now.AddDays(-6).Date.ToString("yyyy/MM/dd"), DateTime.Now.Date.ToString("yyyy/MM/dd"));
             GridView1.DataSource = obj_DataBase.QueryDB(s, "").Tables[0];
             GridView1.DataBind();