Get data from database by month .

Saqi

in table one record already saved like formate 01/06/2012

now

i want get all data which is related by this date but i want search this record by just month formate not total date how can?

exp:
month_cbx = my combobox which is already enterd month numbers 1 to 12...

" String.formate(select * from tablename where date=@date(MM),month_cbx.text");

plz explain this

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anil Kumar14y ago
Your welcome
Saqi14y ago
thanks Anil
i got it .... actulay i was need convert combobox into integer..
Saqi14y ago
thanks look this
i tried your code but have some error of invalid date format.
first of all the datatype of my date column in table is DATETIME..
secondly does not matter about year .. i want just pick month of stored date.
date is 01/06/2012.. now plz write complete query...
1 to 12 numbers already store in combobox..

                StringBuilder query = new StringBuilder();
               query.Append("select * from mytable ");
                query.Append(" Where numero=@numero And ");
    query.Append(String.Format(" Month(date)={0}",comboBox1.Text));
Anil Kumar14y ago
If you want to filter your record on month then result set would be for that month of any year. Ex. June2012, June2011, June2010...etc. And you will not get the result for a particular date which doesn't meet your requirement " i want get all data which is related by this date" .

If you consider some by default year then it is possible or you have to take input for year also.

So get the input for year OR consider current year/any year as a default year and then write your query with
MONTH(date)= AND YEAR(date) =