SQL Stored Procedures

ajaybabuCh

Hi

I am executing the stored procedures from Navision through ADO.

If the stored procedure returns some boolean value or some other value

then How to get the return value of the stored procedure from Navision.

Regards
Ajay

ajaybabuCh

can anybody give an idea on this

Waldo

Well, I've never done this before, but it should be the same as you do it in .NET . 8-[

Isn't it possible like this?

Sub Page_Load(Sender As Object, E As EventArgs) 


Dim myConnection As SqlConnection = _ 
New SqlConnection(ConfigurationSettings.AppSettings("DSN"))

Dim MyCommand as SQLCommand = New SQLCommand("spReturnarticleId", MyConnection)

MyCommand.CommandType = CommandType.StoredProcedure


myConnection.Open()


'Execute the Stored Procedure, return the value and increment it by 1

Dim count As Int32 = CInt(myCommand.ExecuteScalar()) + 1

dim strID as string = cstr(count)


'Set the value of a textbox

text1.text = strId


'Set the Value of a message to test what value is returned

Message.InnerHtml = strId

myConnection.Close()

End Sub

Phenno

ajaybabuCh wrote:

can anybody give an idea on this

search on mibuso or dynamicsuser.net (sorry for advertisings...), I have posted some examples for retreiving values of storage procedures...

Waldo

Phenno wrote:

ajaybabuCh wrote:

can anybody give an idea on this

search on mibuso or dynamicsuser.net (sorry for advertisings...), I have posted some examples for retreiving values of storage procedures...

Ah, OK ... :oops:

Phenno

Waldo wrote:

Phenno wrote:

ajaybabuCh wrote:

can anybody give an idea on this

search on mibuso or dynamicsuser.net (sorry for advertisings...), I have posted some examples for retreiving values of storage procedures...

Ah, OK ... :oops:

hhehhh... no need for ooops

http://www.mibuso.com/forum/viewtopic.p ... +parameter

kriki

[Topic moved from Navision forum to SQL General forum]