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:

int iResult = 0;

System.Data.Common.DbParameter[] spParams = new System.Data.SqlClient.SqlParameter[2];

spParams[0].Value = "123123123";

spParams[1].Value = "Computer1";

iResult = (int)DataBasics.DataSources[""].ExecuteStoredProcedure("spK_KassenAnmeldung", DbCommandExecutionType.ExecuteScalar, spParams);

private static int KassenAnmeldung()

{

System.Data.Common.DbParameter[] spParams = new System.Data.SqlClient.SqlParameter[2];

spParams[0] = new System.Data.SqlClient.SqlParameter();

spParams[1] = new System.Data.SqlClient.SqlParameter();

spParams[0].ParameterName = "@HWID";

spParams[1].ParameterName = "@ComputerName";

spParams[0].Value = "123123123";

spParams[1].Value = "Computer1";

return (int)DataBasics.DataSources[""].ExecuteStoredProcedure("spK_KassenAnmeldung", DbCommandExecutionType.ExecuteScalar, spParams);

}

the stored procedure itself works. i tested it within sql management studio:

private static int KassenAnmeldung()

{

return (int)DataBasics.DataSources[""].ExecuteStoredProcedure("spK_KassenAnmeldung", DbCommandExecutionType.ExecuteScalar, new System.Data.SqlClient.SqlParameter("@HWID", "123123123"),new System.Data.SqlClient.SqlParameter("@ComputerName", "Computer9"));

}

For some reason the Object returned by executestoredprocedure has a value of NULL.

Executing the same sproc on the sql management studio with the same parameters returns a nice integer value.

i dont get it ?

Does your procedure run fine (and returns a nice integer value) when executed from within a BO?

And why not using a BO?
I've a lot of SP and Scalar functions on a SQL database, all in dbo schema, and I use any of my BOs (no one connecting on dbo schema) to run theses SP and functions (you need to grant exec in an intermediate SP, or execute as ..., and revert after execution)

thanks for you reply. i dont know i it runs using a bo, and for this particular function i dont really want to use a bo.

i dont quite understand what you mean by:

From the Help-Document, the ExecuteStoredProcedure function is capable of doing what i want. i dont understand why i would need to use a bo for it. ?

I just made a test that comes accross fine using the StrataFrame sample. Here is my SF code:

And here is the alter for my stored procedure:

this is my sproc:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

ALTER PROCEDURE [dbo].[spK_KassenAnmeldung]

@HWID VARCHAR(250),

@ComputerName VARCHAR(250)

DECLARE @iKassenId int

SET @iKassenId = ( SELECT TOP 1 ID FROM tbKassen WHERE

HWID = @HWID AND ComputerName = @ComputerName );

IF ( @iKassenId IS NULL )

BEGIN

DECLARE @iKassenNr int;

SET @iKassenNr = ( SELECT count(*) FROM tbKassen );

INSERT INTO tbKassen (Bezeichnung, Zyklus, HWID, ComputerName)

VALUES ('Kasse'+LTRIM(STR(@iKassenNr)) , 0, @HWID, @ComputerName);

SET @iKassenId = SCOPE_IDENTITY();

END

RETURN @iKassenId