StrataFrame Forum

Trouble with Stored procedure Parameter

http://forum.strataframe.net/Topic25399.aspx

By Ger Cannoll - 12/14/2009

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
By Edhy Rijo - 12/14/2009

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.
By Ger Cannoll - 12/14/2009

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.
By Edhy Rijo - 12/14/2009

Gerard O Carroll (12/14/2009)
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.




Hi Gerard,



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