Trouble with Stored procedure Parameter

StrataFrame Forum

Back

Trouble with Stored procedure Parameter

Author	Message
Ger Cannoll	Ger Cannoll posted 15 Years Ago Topic Details Share Topic
Group: StrataFrame Users Posts: 430, Visits: 507	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
	Reply Like 0
Edhy Rijo	E Edhy Rijo posted 15 Years Ago Post Details Share Post
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	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. Edhy Rijo
	Reply Like 0
Ger Cannoll	Ger Cannoll posted 15 Years Ago Post Details Share Post
Group: StrataFrame Users Posts: 430, Visits: 507	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.
	Reply Like 0
Edhy Rijo	E Edhy Rijo posted 15 Years Ago Post Details Share Post
E Group: StrataFrame Users Posts: 2.4K, Visits: 23K	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 Glad the sample worked for you, I use SP a lot now. Edhy Rijo
	Reply Like 0