StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Trouble with Stored procedure Parameter

Trouble with Stored procedure Parameter

Ger Cannoll — Mon, 14 Dec 2009 17:49:36 GMT

I am trying to use a FillByStoredProcedure command

I have a command like: This.MyBO.FillByStoredProcdure("MyStoredProcedure","DontKnoWhatToPutHere"). I have he stored procedure set up in the database and that part of it is working fine. Just not sure of the syntax to set up the Parameter and give it a value.

I have tried to set up the parameter with :

System.Data.Common.DbParameter MyParam = new System.Data.Common.DbParameter

but it gives me a ...cannot create instance of an abstract class

RE: Trouble with Stored procedure Parameter

Edhy Rijo — Mon, 14 Dec 2009 17:49:36 GMT

[quote][b]Gerard O Carroll (12/14/2009)[/b][hr]Hi Edhy... I had looked there earlier but could only see an example in VB..have gone back now and converted it to c# and it sems to be working.. thnaks for your help.[/quote]

Hi Gerard,

Yeap, that is what I do all the time, when need something and found it in Google :P Glad the sample worked for you, I use SP a lot now.

RE: Trouble with Stored procedure Parameter

Ger Cannoll — Mon, 14 Dec 2009 17:25:35 GMT

Hi Edhy... I had looked there earlier but could only see an example in VB..have gone back now and converted it to c# and it sems to be working.. thnaks for your help.

RE: Trouble with Stored procedure Parameter

Edhy Rijo — Mon, 14 Dec 2009 16:55:21 GMT

Hi Gerard,

In the SF help file, do a search using "FillByStoredProcedure" without quotation, you will find a sample on how to use the FillByStoredProcedure.