我的aspx页面上有2个TXT,点击用JS弹出日期控件。日期的格式为'2010-5-10' string start = data_begin.Text.ToString();
string end = data_end.Text.ToString();
string sql = "select * OdrItems where [Time] between '" + start + "' and '" + end + "'";start=2010-5-10
end=2010-5-11
为什么从数据库查不出数据?求高人解答
string end = data_end.Text.ToString();
string sql = "select * OdrItems where [Time] between '" + start + "' and '" + end + "'";start=2010-5-10
end=2010-5-11
为什么从数据库查不出数据?求高人解答
string sql = "select * OdrItems where [Time] >='" + start + "' and [Time] <='" + end+ "'";
试试
查询分析器执行
呵呵 如梦哥威武
我感觉这里是不需要强制转换下
试试这个string sql = "select * OdrItems where [Time] between cast('" + start + "' as datetime) and cast('" + end + "' as datetime)";
days = Now.Year & "-" & Now.Month & "-" & Now.Day
SQL = "Select count(ID) from A_Dingdan where datediff(day,A_Dingdan.A_Time,'" & days & "')=0"
把这2格个值作为参数带入。string sql = "select * OdrItems where [Time] between @start and @end";
SqlCommand cmd=new SqlCommand(sql,con);
cmd.Parameters.Add("@start",SqlDbtype.datetime).Value=DateTime.Parse(start);
cmd.Parameters.Add("@end",SqlDbtype.datetime).Value=DateTime.Parse(end);代码手打,可能有点问题。
DateTime endTime = Convert.ToDateTime(data_end.Text.ToString()).AddDays(1);
这个就是正确的