How to convert day month and year into month and year

Question

Hi Everyone

I have table called MCALLERS on my database that has column which called CallDate, datatype is datetime stored data as 2016-02-01 17:01:00.000

on my web Form I have dropdownlist which is populating month and year as March-2016.

how to convert datetime into month and year when I search data.I want to search data from database using Month and year as (March-2016). I'm sing C#.

Thanks in advance

what I have tried

select BusinessCallYN,CallID,NewNam,CallDate,CalledNo,CallExt,CallDuration,Amount,tmpNewNam from MCALLERS where UserName='"+txtEmail+"' and CallDate>='"+cmddropdownlist1+"' and CallDate<'"+cmddropdownlist1+"' and Amount>0 order by CallDate

Pramod Thakur · Answer

First you have to bind two dropdown one for month and another for year. 1 2 3 Jan Feb Mar 2016 2015 2014 try { string strConnString = WebConfigurationManager.ConnectionStrings[NKAccess].ConnectionString; DataTable dt = new DataTable(); using (SqlConnection con = new SqlConnection(strConnString)) { string strCallDate = month .SeletedValue.ToString()+/+ day .SeletedValue.ToString()+/+ year .SeletedValue.ToString(); DateTime CallDate= DateTime.Parse(strCallDate ); string strQuery = select * from MCALLERS where UserName=' + txtemailaddress.Text + ' and CallDate>=' + CallDate + ' and CallDate CallDate + ' and Amount>0 order by CallDate ; SqlCommand cmd = new SqlCommand(strQuery); using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; con.Open(); sda.SelectCommand = cmd; sda.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); /// /// RadioButton } } } catch (Exception er) { Response.Write( alert('Error Found Please Contact Your System Administrator');  + er.Message); } } Please mark as answer if it is useful to you..

Lucas Ngobeni · Answer

Dear Promond Thanks for the response Your answer is working perfect how to search the data from database using Year and month(March-2016) while on the database is stored as 2016-02-01 17:01:00.000. what must I put on the bold words. I'm using Dropdownlist to populate the data into Gridview please find the code below ddlMonth is my Dropdownlist GridView1 is my Gridview try { string strConnString = WebConfigurationManager.ConnectionStrings[NKAccess].ConnectionString; DataTable dt = new DataTable(); using (SqlConnection con = new SqlConnection(strConnString)) { string strQuery = select BusinessCallYNCallIDNewNamCallDateCalledNoCallExtCallDurationAmounttmpNewNam from MCALLERS where UserName=' + txtemailaddress.Text + ' and CallDate>=' + ddlMonth .SeletedValue.ToString() + ' and CallDate ddlMonth .SeletedValue.ToString()+ ' and Amount>0 order by CallDate ; SqlCommand cmd = new SqlCommand(strQuery); using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; con.Open(); sda.SelectCommand = cmd; sda.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); /// /// RadioButton } } } catch (Exception er) { Response.Write( alert('Error Found Please Contact Your System Administrator');  + er.Message); } } Thanks in advance

Pramod Thakur · Answer

Hi You can do it on SQL. Here is a query. SELECT DATENAME(MONTH GETDATE()) +'-' + CONVERT(VARCHAR(4)YEAR(GETDATE())) AS 'MONTH NAME' Please mark as answer if it is helpful.

ali tuncer · Answer

select YEAR(CallDate)Month(CallDate)DATENAME(Month CallDate) AS 'Month Name' from MCALLERS will display year month numbermonth name like 2016 3 March

How to convert day, month and year into month and year