C# & return value from stored procedure
I'm not sure if i'm posting in the right place or it should be C#. Apologies for that .. i'm using the new Visual Web Developer 2005 Express with C# language.
My problem is that i'm trying to get the return value from my stored procedure..
Code:
protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand oSqlComm = new SqlCommand();
SqlConnection oSqlConn = new SqlConnection();
oSqlConn.ConnectionString = SqlDataSource1.ConnectionString;
oSqlComm.Connection = oSqlConn;
oSqlConn.Open();
oSqlComm.CommandText = "check_refnumber";
oSqlComm.CommandType = CommandType.StoredProcedure;
oSqlComm.Parameters.AddWithValue("@p_year_1", DateTime.Now.ToString("yy"));
oSqlComm.Parameters.AddWithValue("@p_month_2", DateTime.Now.ToString("MM"));
oSqlComm.Parameters.AddWithValue("@out", ParameterDirection.Output);
oSqlComm.ExecuteNonQuery();
// Response.Write ("test");
//Response.Write (oSqlComm.Parameters["@out"].Value);
TextBox1.Text = oSqlComm.Parameters["@out"].Value.ToString();
}
code for the stored procedure is as follow
Code:
ALTER PROCEDURE check_refnumber
(
@p_year_1 int,
@p_month_2 int,
@out int OUTPUT
)
AS
BEGIN
SET @out = (SELECT max(p_num) FROM Temporary where p_year = @p_year_1 AND p_month = @p_month_2)
END
i'm trying to return the max value of p_num from my table to textbox1 or to any integer variable.
the only value i'm getting back is "output"
any help would be appreciated
thanks..
[1742 byte] By [shobapond] at [2007-12-16] 