getting erorr Procedure 'up_reason' expects parameter '@EmployeeNominationID', which

[preeti13]

i am trying to dispaly a datagrid but getting the erorr please any one help me with this.

private void Page_Load(object sender, System.EventArgs e)
        {
            // Put user code to initialize the page here
         SqlConnection oConn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["oConn"]);
 
            SqlDataAdapter da=new SqlDataAdapter("up_reason", oConn);
 
            DataSet ds=new DataSet(); 
 
            da.SelectCommand.CommandType=CommandType.StoredProcedure;
            string employeenominationid;
            employeenominationid=Request.QueryString ["employeenominationid"];
 
            SqlParameter obj=new SqlParameter("@EmployeeNominationid",SqlDbType.Int);
                obj.Value=employeenominationid;
 
 
            oConn.Open();
            da.SelectCommand.ExecuteNonQuery();
            oConn.Close();
 
            da.Fill(ds) ;
 
            this.garidreason .DataSource=ds;
            this.DataBind();
 
            da.Dispose(); 
}
 
 
 

and my store procedure is like this

CREATE  PROCEDURE dbo.up_reason
 @EmployeeNominationID int
--set @employeenominationid='1'
AS
select dbo.employeenominations.nomineefirstname,dbo.employeenominations.nomineelastname,dbo.reason.reason
 FROM    dbo.EmployeeNominations INNER JOIN
         dbo.Reason ON dbo.EmployeeNominations.EmployeeNominationid = dbo.Reason.Employeenominationid
where dbo.reason.employeenominationid=@EmployeeNominationid
GO
 
 
 

[bakpao]

The problem is the stored procedure is missing the parameter @EmployeeNominationID. Although you have created that parameter, you have not attached it to the command.

obj.Value=employeenominationid;
 
 da.SelectCommand.Parameters.Add(obj);
 
oConn.Open();