i am having table in which date, company name and amount is stored
i have one dropdown in which i kept year
now i want to show data in gridview according to year selected from dropdownlist but how i can seperate date from year in date field
protected void ddlYear_SelectedIndexChanged(object sender, EventArgs e)
{
conn.Open();
qry = "Select Company_Name,Amount,DatePart(yy,date) as Year from S_Pro WHERE Date='" +ddlYear.SelectedValue+ "'";
SqlCommand cmd = new SqlCommand(qry, conn);
SqlDataReader dr = cmd.ExecuteReader();
//GridView1.DataSource = dr;
GridView1.DataBind();
conn.Close();
}