Using DataBasics to execute a non-bo-bound stored procedure

StrataFrame Forum

Back

Using DataBasics to execute a non-bo-bound stored procedure

Author	Message
Philipp Guntermann	Philipp Guntermann posted 17 Years Ago HOT Topic Details Share Topic
Group: Forum Members Posts: 141, Visits: 263	Hi, I am wondering if someone could provide a sample code as how I can use DataBasics.DataSources[""].ExecuteStoredProcedure(..) My sproc takes 2 varchar input parameters and returns an integer value: @HWID VARCHAR(250), @ComputerName VARCHAR(250), @iKassenId int OUTPUT i want to execute the sproc and get the Result integer. Thanks !
	Reply Like 0
Replies
Alex Luyando	Alex Luyando posted 16 Years Ago Post Details Share Post
Group: StrataFrame Users Posts: 112, Visits: 1.2K	Greg McGuffey (08/26/2008) I'm wondering if the problem is that you are using Return instead of Select. My understanding is that Return is used to return a status code, while you'd use Select to return a record set, which ExecuteScalar will then retrieve data from. How I wish I had read this about two hours earlier! LOL Very handy to know.. Thanks! ________________ _____/ Regards, ____/ al
	Reply Like 0
Greg McGuffey	Greg McGuffey posted 16 Years Ago Post Details Share Post
Group: Forum Members Posts: 2K, Visits: 6.6K	LOL! Glad you found a solution to your issue though!
	Reply Like 0

Merge into selected topic...

Merge into merge target...

Merge into a specific topic ID...

Threaded View

Using DataBasics to execute a non-bo-bound stored procedure

Philipp Guntermann - 17 Years Ago

i tried it like that and get a NULLREFERENCE exception: int...

Philipp Guntermann - 17 Years Ago

heres the complete code: private static int...

Philipp Guntermann - 17 Years Ago

Shorter Code, but same error: private static int...

Philipp Guntermann - 17 Years Ago

Hi Phillip, Does your procedure run fine (and returns a nice integer...

Michel Levy - 17 Years Ago

HI Michel, thanks for you reply. i dont know i it runs using a bo,...

Philipp Guntermann - 17 Years Ago

Philipp, Using a BOis for a maintenance purpose (All the business...

Michel Levy - 17 Years Ago

Your code looks good. What is in your stored procedure? I just made a...

Dustin Taylor - 17 Years Ago

Hi Dustin, this is my sproc: set ANSI_NULLS ON set...

Philipp Guntermann - 17 Years Ago

I'm wondering if the problem is that you are using Return instead of...

Greg McGuffey - 17 Years Ago

hi, thanks. that seems like it could be the problem. i wasnt aware of...

Philipp Guntermann - 17 Years Ago

[quote][b]Greg McGuffey (08/26/2008)[/b][hr]I'm wondering if the...

Alex Luyando - 16 Years Ago

LOL! Glad you found a solution to your issue though!

Greg McGuffey - 16 Years Ago

Yep, greg nailed it. Even though it is a scalar, you still want to...

Dustin Taylor - 17 Years Ago

Just letting you know it does indeed work now using SELECT instead of...

Philipp Guntermann - 17 Years Ago

Glad you got it working and that I was of help! :D

Greg McGuffey - 17 Years Ago

Reading This Topic

Login
Remember Me Reset Password Resend Validation Email Login