如何从日期范围到日期范围进行搜索 [英] How to search from date range to date range

问题描述

大家好，我有两个带有jquery日历开始日期"和结束日期"的文本框，我不确定如何使用这些日期在数据库中搜索这两个日期之间的字段并显示结果在数据网格视图中，不安静地确定从何处开始
如果有人可以帮助您，请

hi all, I have two textboxes with a jquery calendar "Start date" and "End date" im not sure on how to use those dates to search in the database for fields that are between those two dates and display the results back in a datagrid view, not quiet sure where to start with this
if anyone can help please do

推荐答案

尝试:

SELECT * FROM myTable WHERE mySearchDate BETWEEN '1990-01-01' AND '2012-01-01'

select * from table where startdate >='"+dateTimePicker1.Value.ToString("yyyy-MM-dd")+"'and enddate <='"+dateTimePicker2.Value.ToString("yyyy-MM-dd")+"'"; 

您可以使用jquery日历文本框代替datetimepicker
谢谢

In Place of datetimepicker you can use your jquery calender textbox
Thanks

请参阅

通过jQuery DatePicker在3分钟内实现ASP.NET控件 [ ^ ]

refer

ASP.NET Control from jQuery DatePicker in 3 Minutes[^]

这篇关于如何从日期范围到日期范围进行搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！