Stored procedure returns value

[vasu2005]

Hi all,

I have to call a stored procedure from my VB.NET code , the procedure returns a value(int)

Dim param As OleDbParameter
cmd.Connection = cn 'cmd is oledbcommand object
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "searchitem"

param paramReturnValue = new oledbParameter()
paramReturnValue.ParameterName = "@return_value";
paramReturnValue.oledbType = SqlDbType.Int;
paramReturnValue.Direction = ParameterDirection.ReturnValue;

but I am getting an error on my 5th line that expression is not a method.

Can anyone tell me what is going wrong in my code.

Thanks,

-V

 

[dolfo35]

V,

This is what works for me, except I'm using SQL Server:

Dim prmName As SqlParameter = cmd.Parameters.Add("@Param1", SqlDbType.int)
prmName.Value = someNumber

So, I guess yours would be something like this (provided the differences between OleDB and SQL do not change things):

Dim prmName As OleDBParameter = cmd.Parameters.Add("@Param1", OleDbType.int)
prmName.Value = someNumber

Of course, "@Param1" has to match the parameter name in the stored procedure. Also, before these two lines of code, I've already created connection and commmand.

Hope this helps!
Rudy

 

[chrissie1]

param paramReturnValue = new oledbParameter()
paramReturnValue.ParameterName = "@return_value";
paramReturnValue.oledbType = SqlDbType.Int;
paramReturnValue.Direction = ParameterDirection.ReturnValue;

this seems odd??? it looks like C#????

and casting from an oledbtype to an sqldbtype seems odd aswell.

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting