How to pass output value from Stored Procedure to asp.net 1.1 using C#

Hi Mahendra Here is the code:

SqlConnection con = new SqlConnection("<connectionString>")
con.Open();

SqlCommand com = new SqlCommand("<storeProcedureName>", con);
com.CommandType = CommandType.StoreProcedure;

com.Parameters.Add("<param1>", SqlDBType.Varchar);
com.Parameters[0].Direction = ParameterDirection.Output;

com.ExecuteNonProcedure()
Object val = com.Parameters[0].Value;

Hope this will helps you

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Hi Himanshu,


I'm using sql server 2000, probably 'com.ExecuteNonProcedure() will not support, i think, since i'm getting error there.
Even i have replace it to 'com.ExecuteReader()', but the value of 'val' is showing as 0.
please help me on this.

Thanks & Regards,
Mahendra

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator

Sorry, Mahendra its my mistake just replace it with com.ExecuteNonQuery()

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Mahendrabasutkar, if this helps please login to Mark As Answer. | Alert Moderator