查找两个日期之间的数据取决于当前日期 [英] To find data between two dates depend current date
问题描述
亲爱的所有人,
现在我想根据当前日期查找两个日期之间的一些数据.例如,在我的数据库中,我存储的一月(从)到三月(到)是冬天(季节),三月到六月是夏天,六月到九月是寒冷.现在我有一个dateTimepicker和一个组合框.如果选择7月18日表示是,夏季在组合框中显示,而2月15日则表示它是冬季等.欢迎您这样做.欢迎所有答复...
谢谢&问候
Dhinesh Kumar.V
在C#中,日历选择更改了事件
,请检查所选的日期范围,然后在下拉列表中选择值
如果(Calendar1.SelectedDate.Month> = 1 && Calendar1.SelectedDate.Month< = " ; else 如果(Calendar1.SelectedDate.Month> = 4 && Calendar1.SelectedDate.Month< = 6 ) dropdownlist.SelectedValue = " else 如果(Calendar1.SelectedDate.Month& == 7 && amp; Calendar1 .SelectedDate.Month& lt; = 9 ) dropdownlist.SelectedValue = "
更新的解决方案:
因此,您的意思是说您将决定日期和季节.因此,有一个包含3列SeasonName,StartDate,EndDate的表.然后,每当您在日历中选择一个值时,都从该表中查询名称.
选择 seasonName 来自 tbl 其中 @ dt 开始日期之间和结束日期
试试这个
// txt_date是文本框,您可以在其中从datatimepicker获取值 // 此处名为txt_date的文本框中的输入为"mm/dd/yyyy"格式 字符串 [] date = txt_date.Text.Split(' /'); 字符串 month = dd [ 0 ].ToString(); 字符串 date = dd [ 1 ].ToString(); 字符串 year = dd [ 2 ].ToString(); int m = Convert.ToInt32(month);
现在您可以获得月份,现在根据月份获得您的季节;
如果(m> = 1 || m< = 3 ) dropdownlist.SelectedValue = " ; 其他如果(m> = 4 || m => 6) dropdownlist.SelectedValue = " ; 其他如果(m> = 7 || m< = 9 ) dropdownlist.SelectedValue = " ;
>
Dear All,
Now i wanna to find some data between two dates depend upon current date. For example in my database i stored January(from) to March(to) is Winter(season), March to June is summer, June to September cold. Now i have one dateTimepicker and one Combobox. If am select july 18 means, Summer display at combobox, and feb 15 means it shows winter etc. how do this one... All replies are welcome...
Thanks & Regards
Dhinesh Kumar.V
in c#, calendar selectionchanged event
, check the selected date range and select the value in dropdown
If (Calendar1.SelectedDate.Month>=1 &&Calendar1.SelectedDate.Month<=3) dropdownlist.SelectedValue="Winter"; else If (Calendar1.SelectedDate.Month>=4 &&Calendar1.SelectedDate.Month<=6) dropdownlist.SelectedValue="Summer" else If (Calendar1.SelectedDate.Month>=7 &&Calendar1.SelectedDate.Month<=9) dropdownlist.SelectedValue="Cold"
Updated solution:
So you meant to say you will decide the date and the season. So have a table with 3 columns SeasonName, StartDate, EndDate. Then whenever you select a value in calendar, query the name from this table.
Select seasonName from tbl where @dt between startdate and Enddate
Try this one
//txt_date is textbox in which you get the value from datatimepicker //here the input in textbox named txt_date is in "mm/dd/yyyy" format string[] date = txt_date.Text.Split('/'); string month = dd[0].ToString(); string date = dd[1].ToString(); string year = dd[2].ToString(); int m = Convert.ToInt32(month);
Now you get the month, Now get your season according to month;
If (m>=1 || m<=3) dropdownlist.SelectedValue="Winter"; else If (m>=4 || m=>6) dropdownlist.SelectedValue="Summer"; else If (m>=7 || m<=9) dropdownlist.SelectedValue="Cold";
这篇关于查找两个日期之间的数据取决于当前日期的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!