getting the data type conversion error please help me

[preeti13]

i am tring to retrive the value form the data base but getting erorr i tried so many way but i didn't get the value i got the erorr like this: Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query. if any one know something about this then please help me my code is like this:

private void Page_Load(object sender, System.EventArgs e)
        {
 
 
            string employeenominationid;
            employeenominationid=Request.QueryString ["employeenominationid"];
 
 
         SqlConnection oConn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["oConn"]);
 
            SqlDataAdapter da=new SqlDataAdapter("usp_TestParameters",oConn);
 
            DataSet ds=new DataSet(); 
 
            da.SelectCommand.CommandType=CommandType.StoredProcedure;
 
            da.SelectCommand.Parameters.Add(new SqlParameter("@employeenominationid",employeenominationid));
 
 
 
            SqlParameter datecreated= new SqlParameter("@datecreated", SqlDbType.Int); 
            datecreated.Direction = ParameterDirection.Output; 
            da.SelectCommand.Parameters.Add(datecreated);
 
 
            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:

@employeenominationID int,
@Datecreated datetime OUTPUT
AS
SELECT  datepart(month,@datecreated)  FROM reason WHERE @employeeNominationID = @employeeNominationID
SELECT * FROM reason WHERE EmployeeNominationID = @EmployeeNominationID
RETURN @@ROWCOUNT
select @@RowCount
 
GO
 
 
 

[nateraaaa]

i am tring to retrive the value form the data base but getting erorr i tried so many way but i didn't get the value i got the erorr like this: Implicit conversion from data type datetime to int is not allowed. Use the CONVERT function to run this query. if any one know something about this then please help me my code is like this:

private void Page_Load(object sender, System.EventArgs e)
        {
 
 
            string employeenominationid;
            employeenominationid=Request.QueryString ["employeenominationid"];
 
 
         SqlConnection oConn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["oConn"]);
 
            SqlDataAdapter da=new SqlDataAdapter("usp_TestParameters",oConn);
 
            DataSet ds=new DataSet(); 
 
            da.SelectCommand.CommandType=CommandType.StoredProcedure;
 
            da.SelectCommand.Parameters.Add(new SqlParameter("@employeenominationid",employeenominationid));
 
 
 
            SqlParameter datecreated= new SqlParameter("@datecreated", SqlDbType.Int); 
            datecreated.Direction = ParameterDirection.Output; 
            da.SelectCommand.Parameters.Add(datecreated);
 
 
            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:

@employeenominationID int,
@Datecreated datetime OUTPUT
AS
SELECT  datepart(month,@datecreated)  FROM reason WHERE @employeeNominationID = @employeeNominationID
SELECT * FROM reason WHERE EmployeeNominationID = @EmployeeNominationID
RETURN @@ROWCOUNT
select @@RowCount
 
GO
 
 
 

In your stored proc you have Datecreated as a datetime datatype but in your page load event you are passing an int datatype to the stored proc. Change the following line in the page load event to :

SqlParameter datecreated= new SqlParameter("@datecreated", SqlDbType.DateTime); 

Now your error should be resolved.

Nathan

[preeti13]

thanks very much for help me .my problem is solved now