command text, text box C#

If your different Textbox contains only value of Month and Year only then It is feasible. If you Textbox contains full Date then you also need to convert then Either that in a month or Year accordingly, Otherwise comparison will not be done.

Or as an alternate you could use DATEDIFF[^] function which will give timespan in days,month or year between two dates and furthermore you could compare whether it is between valid range or not.

Please vote and Accept Answer if it Helped.

I think taht better way is:
1. Create custom calendar control, with have property like "DateTime? Value {get; set;}" and no more use two textbox controls.
2. Create two DateTime objects: 1) startDate, 2) endDate = endDate.AddDay(1).AddSeconds(-1).
3. Use sql with parameterized query like 'select * from table where date between @fromDate and @endDate'.

Hi,


my recommendation is try to use the parameterized query and try to avoid sql functions to find the month and year. Try to give your input as single value.

Create from txtBox1 and txtYear1 the beginning date, from txtBox2 and txtYear2 the ending date (you have to use add 1 month to the second date and then subtract 1 - this is eom of the month) and then you can simplify the select statement to use it with the between clause.