Filter GridView based on Year DropDownList selection using C# and VB.Net in ASP.Net

kankon says:

YEAR(datestart) = YEAR(GETDATE())

You are passing GETDATE() as hard coded value. So it will check with current year. You need to pass @datestart variable inplace of GETDATE().

ALTER PROCEDURE [dbo].[GetDetails]
    @id INT = NULL      
    ,@idnamev nvarchar(MAX) = NULL
    ,@namevacation nvarchar(MAX) = NULL
    ,@idcivilv nvarchar(MAX) = NULL
    ,@infovacation nvarchar(MAX) = NULL
    ,@datestart datetime = NULL
    ,@dateend datetime = NULL
    ,@vacationdata datetime = NULL
    ,@el3malv nvarchar(MAX) = NULL
    ,@datesp10 nvarchar(MAX) = NULL
    ,@eldarajah nvarchar(MAX) = NULL
    ,@totalva nvarchar(MAX) = NULL
    ,@jop nvarchar(MAX) = NULL
    ,@name nvarchar(MAX) = NULL
    ,@ContentType nvarchar(MAX) = NULL
    ,@backupmyfile varbinary(MAX) = NULL
AS
BEGIN
	SELECT Id, idnamev, namevacation, idcivilv, infovacation, datestart, dateend,vacationdata,el3malv,datesp10,eldarajah,totalva,jop,name,ContentType,backupmyfile
	FROM Table_vacation
	WHERE (YEAR(datestart) = YEAR(@datestart) OR ISNULL(@datestart,'') = '')
	AND (datestart = @datestart OR ISNULL(@datestart,'') = '')
	AND (namevacation = @namevacation OR ISNULL(@namevacation,'') = '')
END

dharmendr says:

protected void GetReport(object sender, EventArgs e) {     string conString = ConfigurationManager.ConnectionStrings("conString").ConnectionString;     using (SqlConnection con = new SqlConnection(conString))     {         SqlCommand cmd = new SqlCommand();         cmd.CommandText = "GetDetails";         cmd.CommandType = CommandType.StoredProcedure;         cmd.Connection = con;         con.Open();         if (int.Parse(ddlYear.SelectedItem.Value) == 0)             cmd.Parameters.AddWithValue("@Year", (object)DBNull.Value);         else             cmd.Parameters.AddWithValue("@Year", this.ddlYear.SelectedItem.Text);         if (int.Parse(ddlDepartment.SelectedItem.Value) == 0)             cmd.Parameters.AddWithValue("@Department", (object)DBNull.Value);         else             cmd.Parameters.AddWithValue("@Department", this.ddlDepartment.SelectedItem.Text);         SqlDataAdapter sda = new SqlDataAdapter(cmd);         DataSet ds = new DataSet();         sda.Fill(ds);         this.gvDetails.DataSource = ds;         this.gvDetails.DataBind();     } }

 

 i found the problem , 

first string conString = ConfigurationManager.ConnectionStrings("conString").ConnectionString;

must be ["conString"]

i change from db date to  char (4)