Getting a Return Value from a Stored Procedure

StrataFrame Forum

Back

Home
»
.NET Forums
»
General .NET Discussion
»
Getting a Return Value from a Stored Procedure

Getting a Return Value from a Stored Procedure

Author	Message
Terry Bottorff	Terry Bottorff posted 15 Years Ago HOT Topic Details Share Topic
Group: Forum Members Posts: 448, Visits: 12K	I have the following Stored Proc (I am not sure it is correct). I just am trying to see if there are any duplicates in the table. CREATE PROCEDURE [dbo].[sp_CountSRStockforDups] -- Add the parameters for the stored procedure here @myRowCount int = 0 OUTPUT AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for procedure here select stock, count(stock) as pen from dbo.SRstocks where stock > 0 group by stock having (count(stock)) > 1 select @myRowCount = @@ROWCOUNT return @myRowCount END I know I have 2 records that repeat but with the following code it returns zero(0).? Dim nret As Integer = 1000 Dim cmd As New SqlCommand("sp_CountSRStockforDups") cmd.CommandType = Data.CommandType.StoredProcedure ' OutPut Parameter cmd.Parameters.Add("@myRowCount", Data.SqlDbType.Int).Direction = Data.ParameterDirection.Output nret = CType(cmd.Parameters("@myRowCount").Value, Integer) Please understand I am not sure any of this is correct except the attached picture seems to indicate that my stored proc is working but any help would be appreciated. TIA Attachments countingstk.png (190 views, 6.00 KB)
	Reply Like 2
Reply
Edhy Rijo	E Edhy Rijo posted 15 Years Ago Post Details Share Post
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	Charles R Hankey (11/29/2010) (... reading that over it probably doesn't make any sense unless you've been playing with TVPs but for anybody who has, the TVP as empty table if no param is passed came as a surprise to me and somebody may find it useful ) Hi Charles, I have not worked with a TVP yet. I have a consultant "Uri Dimant" which is a MS SQL MVP which helps me with those deep needs and even though he is pretty good explaining this type of things with MS-SQL, sometimes I don't have the luxury to pay to much of attention to details. He has created some complex stored procedures to deal with millions of records and re-factored those couple of times to take advantage of new functionality of MS-SQL 2008 R2. In case you or anyone needs serious help with any MS-SQL problem, feel free to contact him. Edhy Rijo
	Reply Like 2

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Threaded View

Getting a Return Value from a Stored Procedure

Terry Bottorff - 15 Years Ago

Hi Terry. Haven't you forgotten to execute the query? Guess your...

Ivan George Borges - 15 Years Ago

Actually I am running the code in the click of a button and so when I...

Terry Bottorff - 15 Years Ago

I think I found it. MicroFour.StrataFrame.Data. DataBasics...

Terry Bottorff - 15 Years Ago

You're welcome. :cool:

Ivan George Borges - 15 Years Ago

Hi Terry, Your approach is correct but I prefer to have all data...

Edhy Rijo - 15 Years Ago

Terry, I agree with Edhy. It is never good Mojo to put your query...

Trent L. Taylor - 15 Years Ago

Hey Edhy - It's Monday and I have SET STUPID ON but could you clarify...

Charles R Hankey - 15 Years Ago

Hi Charles, SET STUPID OFF (on my side :P ) Yes you are right, this...

Edhy Rijo - 15 Years Ago

>> cmd.CommandText= String .Format(...

Charles R Hankey - 15 Years Ago

Hi Charles, I had to do the test this time, since it is not...

Edhy Rijo - 15 Years Ago

This looks good. Also, if you pass a comma separated list of fields to...

Charles R Hankey - 15 Years Ago

[quote][b]Charles R Hankey (11/29/2010)[/b][hr]This looks good. Also,...

Edhy Rijo - 15 Years Ago

I think your idea of an array for multiple fields is very good,...

Charles R Hankey - 15 Years Ago

[quote][b]Charles R Hankey (11/29/2010)[/b][hr](... reading that over...

Edhy Rijo - 15 Years Ago

Hi Edhy. This might sound like a silly question but I 'Asumed' that a...

Ger Cannoll - 15 Years Ago

[quote][b]Gerard O Carroll (11/30/2010)[/b][hr]This might sound like a...

Edhy Rijo - 15 Years Ago

Oh if my learning curve was not straight up enough. Now it has a curve...

Terry Bottorff - 15 Years Ago

Hi Terry, Sorry for the confusion, bizTransationItems is one of my...

Edhy Rijo - 15 Years Ago

Thank you so much. That makes sense. Zowie this stuff is cool.

Terry Bottorff - 15 Years Ago

I did find the Primary Key problem and I was able to change that but...

Terry Bottorff - 15 Years Ago

[quote][b]Terry Bottorff (11/29/2010)[/b][hr]...but now with All of...

Edhy Rijo - 15 Years Ago

Is there some where I can find a basic subclass of the BO that has...

Terry Bottorff - 15 Years Ago

Hi Terry, Yes, there are some sample code in the forums, probably...

Edhy Rijo - 15 Years Ago

So let me get this straight. I create a BO (say BaseBO) and I don't...

Terry Bottorff - 15 Years Ago

Yeap you are now in the right track, so go for it. Also for your...

Edhy Rijo - 15 Years Ago

Reading This Topic

Login
Remember Me Reset Password Resend Validation Email Login

Getting a Return Value from a Stored Procedure

Getting a Return Value from a Stored Procedure

Merge Selected

Threaded View

Similar Topics

Reading This Topic

Login

Explore

Messages

Mentions

Search