StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Parameters collection for FillByStoredProcedure

Parameters collection for FillByStoredProcedure

Bill Cunnien — Mon, 28 Apr 2008 17:44:01 GMT

How do I pass multiple parameters to the FillByStoredProcedure method?

RE: Parameters collection for FillByStoredProcedure

Trent L. Taylor — Mon, 28 Apr 2008 17:44:01 GMT

No problem...glad you got it going :)

RE: Parameters collection for FillByStoredProcedure

Bill Cunnien — Mon, 28 Apr 2008 17:21:56 GMT

I did try this once:

SqlParameter mPLType = new SqlParameter("@pltype", pPLType);
SqlParameter mOrderIndex = new SqlParameter("@orderindex", pOrderIndex);
FillByStoredProcedure("spx_GetOrderItemList", mPLType, mOrderIndex);

It did not work...well, I didn't think it did. It's a good thing to set the DataSourceKey on the BO, too. :D It tends to misbehave when that is missing. Once I put that back in, then both your code and my code works just fine. Sorry for the oversight. :blush:

Thanks for helping!
Bill

RE: Parameters collection for FillByStoredProcedure

Trent L. Taylor — Mon, 28 Apr 2008 17:11:59 GMT

You have to supply a DbParameter. If you are using SQL Server, then it would look something like this:

[codesnippet]Me.FillByStoredProcedure("MyStoredSproc", New SqlParameter("@parm1", MyValue), New SqlParameter("@parm2", MySecondValue))[/codesnippet]

RE: Parameters collection for FillByStoredProcedure

Bill Cunnien — Mon, 28 Apr 2008 17:06:18 GMT

One of the data retrieval methods is MicroFour.StrataFrame.Business.BusinessLayer.FillByStoredProcedure(string, params System.Data.Common.DbParameter[]). How do I pass a parameters collection? Sorry, if I am not making myself clear. Here is the code offending code in my BO:

public void FillByOrderIndex(int pPLType, int pOrderIndex)
{
FillByStoredProcedure("spx_GetOrderItemList", pPLType, pOrderIndex);
}

RE: Parameters collection for FillByStoredProcedure

Trent L. Taylor — Mon, 28 Apr 2008 16:56:18 GMT

It is a ParamArray so you can just pass as many parms as you want or create an Object array....whichever works best for you:

[codesnippet]MyBo.FillByStoredProcedure(Parm1, Parm2, Parm3)[/codesnippet]

[codesnippet]MyBo.FillByStoredProcedure(New Object() {Parm1, Parm2, Parm3))[/codesnippet]