Geek asks and answers

SQL Server 2008 R2 Missing Option

My System.Data.SqlClientreports that I forgot to pass the parameter.

Well, I scratched my head over this.

I am using SQL Server 2008 R2 with Asp.Net MVC2 in VS2008.

Here is the screen.

enter image description here

What did I miss?

EDIT

Here is the header of the stored procedure

ALTER  PROCEDURE [dbo].[ClientMst_AUTO](@Params VARCHAR(50),@result   xml output)
as
BEGIN
+3
source share
2 answers

The code looks good at first glance - the only thing I can see that can explain this behavior: you have defined your parameter @resultas ParameterDirection.InputOutput- but you are not giving any value to this parameter from the input side ...

Try adding this line before adding parm2to the collection cmd.Parameters:

parm2.Value = string.Empty;

Will anything change?

: ParameterDirection.Output ( InputOutput) - ?

+2

@result , parm2.Direction ParameterDirection.Output.

0

More articles:


All Articles