取前三天的资料,如2007-08-13 00:00:00 到 2007-08-16 23:59:29 ?

if(!this.IsPostBack)
{
if(DateTime.Now.DayOfWeek==System.DayOfWeek.Monday)
{
this.tb_time.Text=DateTime.Now.AddDays(-2).ToString( "yyyy-MM-dd ");
}
else
{
this.tb_time.Text=DateTime.Now.AddDays(-1).ToString( "yyyy-MM-dd ");
}
}


请教如果取2007-08-13 00:00:00 到 2007-08-16 23:59:29的资料怎么修改.谢!

where PlanStartTime> ' "+this.tb_time.Text.Substring(0,10)+ " 00:00:00 "+ " ' and PlanStartTime < ' "+this.tb_time.Text.Substring(0,10)+ " 23:59:59 "+ " ' order by dbo.nb_JiaBanLog.FormNumber ");

[解决办法]
你都写出来了
[解决办法]
Datediff(d,convert(varchar,PlanStartTime,120),GETDATE()) <=3
[解决办法]
if(!this.IsPostBack)
{
if(DateTime.Now.DayOfWeek==System.DayOfWeek.Monday)
{
this.tb_time.Text=DateTime.Now.AddDays(-2).ToString( "yyyy-MM-dd ");
}
else
{
this.tb_time.Text=DateTime.Now.AddDays(-1).ToString( "yyyy-MM-dd ");
}
}

-------------------------
上面一段可以不要的．GETDATE()　这个可以获取当前数据库服务器的时间
[解决办法]
用SQL语句处理比较好
[解决办法]
不需用任何的按钮.

＝＝＝＝＝＝＝＝＝

绑定代码放到 Page_Load 里面
[解决办法]
select * from 表 where Datediff(d,convert(varchar(10),PlanStartTime,120),GETDATE()) <=3
order by dbo.nb_JiaBanLog.FormNumber