System Error when trying to call Stored Procedure from code

[Jenny C.]

Hi

I am fairly new to .NET, and I am having a hard time to call a stored procedure from C# code in a windows application
I have tested my connection (and login) several time and it is OK. If I try to do a query it works, but when I try to call a stored procedure i get the message "System Error". My code is shown below
Any idea what could be the problem
A million thanks

Jenn
------------------------

this.connString = ConfigurationSe ttings.AppSetti ngs["connString "]
this.con = new SqlConnection(t his.connString)

this.procedureN ame = "MyStoredProcNa me"
this.cmd = new SqlCommand(this .procedureName, this.con)
this.cmd.Comman dType = CommandType.Sto redProcedure

SqlParameter param
param = this.cmd.Parame ters.Add("@MyPa rameter", SqlDbType.Int)
param.Direction = ParameterDirect ion.Output;
this.con.Open()
this.cmd.Execut eNonQuery()
this.con.Close( );

[Ignacio Machin \( .NET/ C# MVP \)]

Hi Jenny,

Is you stored procedure declared correctly:

CREATE PROC MyStoredProcNam e
(
@MyParameter INT OUTPUT
)
AS
-- the code

if it does, can you wrap the ExecuteNonQuery () call in a try/catch block and
see that the Exception.Messa ge says?

Cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Jenny C." <an*******@disc ussions.microso ft.com> wrote in message
news:11******** *************** ***********@mic rosoft.com...

Hi,

I am fairly new to .NET, and I am having a hard time to call a stored procedure from C# code in a windows application. I have tested my connection (and login) several time and it is OK. If I try to do a query it works, but when I try to call a stored procedure i get
the message "System Error". My code is shown below. Any idea what could be the problem?
A million thanks!

Jenny
-------------------------
this.connString = ConfigurationSe ttings.AppSetti ngs["connString "];
this.con = new SqlConnection(t his.connString) ;

this.procedureN ame = "MyStoredProcNa me";
this.cmd = new SqlCommand(this .procedureName, this.con);
this.cmd.Comman dType = CommandType.Sto redProcedure;

SqlParameter param;
param = this.cmd.Parame ters.Add("@MyPa rameter", SqlDbType.Int);
param.Direction = ParameterDirect ion.Output;
this.con.Open() ;
this.cmd.Execut eNonQuery();
this.con.Close( );