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

Lucas Ngobeni

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

4 Replies

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

Pramod Thakur10y ago
Accepted answer
First you have to bind two dropdown, one for month and another for year.

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("" + er.Message);
}
}

Please mark as answer if it is useful to you..
0
Lucas Ngobeni10y ago
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("" + er.Message);
}
}
Thanks in advance

0
Pramod Thakur10y ago
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.
0
ali tuncer10y ago
select YEAR(CallDate),Month(CallDate),DATENAME(Month, CallDate) AS 'Month Name'

from MCALLERS
will display year, month number,month name like 2016 3 March
0