DateTime sys = System.DateTime.Now;
year = sys.Year;
DateTime next =sys.AddYears(1);
Next = next.Year;
string query = "select DISTINCT(App_Code),App_Name from Appraisal where year(App_Date)>='" + year + "' and YEAR(App_Date)<='" + Next + "'";
Next
year
string query = "select DISTINCT(App_Code),App_Name from Appraisal where datepart(yy,App_Date)>='" + year + "' and datepart(yy,App_Date)<='" + Next + "'";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)