I have DatagridView on form.

My database has three fields.
- userId (bigint)
- userName (varchar)
- userDob (date)

Now, on Form I have comboBox, which lists Months (Jan, Feb, March and so on...). I want my program to work like this.

If I select any month on ComboBox, birthdays of clients related to that month should only be displayed in DatagridView. Help me how to do it.

Edited by Amiet_1

3 Years
Discussion Span
Last Post by djjeavons

add this to your query.

where userDob like '"+cbYear.Text+"-"+cbMonth.Text+"-%' order by userDob

example output: `where userDob like '2015-01-%' order by userDob`

the format of date is `yyyy-MM-dd`:

for `yyyy` represent 4 digit year.
    `MM` represent 2 digit month.
    `dd` represent 2 digit day.

Happy Programming and God Bless you.

Edited by JerrimePatient


If this is SQL Server then you could use the DATENAME method:

SELECT * FROM YourTable where DATENAME(month, YourDateField) = 'July'

In this way, you can select all records that match a month regardless of year which is what I believe you want.

Votes + Comments
May be this will solve my problem... I'll try this code ASAP
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.