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 BusinessCallYN,CallID,NewNam,CallDate,CalledNo,CallExt,CallDuration,Amount,tmpNewNam 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 number,month name like 2016 3 March

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

brunda k