Hello All,

[Using DNN 5.2.2]

As you can see from the code below, I want to do a simple execute of a stored procedure.  The code below is not working, but the connection string looks OK.  I have two questions here, 

1) Any idea why the code is not executing?

2) what is the better way to execute an sproc from within DNN programming environment.  Should I be using something like sqlhelper.  But I cannot find such a helper.

Thanks a lot in advance,

Mark Breen

Ireland

 Hello Cathal,

You are right, I did forget to post the code I had mentioned as being below, apologies for that.  However, following your response I read, again, the wonderful site from Mr Washington and found exactly what i was looking for.  Below are two lines of code, that grab the encrypted Id for the page, and then run an sproc using that Id.  Hopefully this will be useful to some one else.

The code below works well for me now, and I am thrilled with it.  

However, I found the intellisense suggesting that I need to build a collection of parameters and only pass that collection. And when I tried to pass an individual param, as Michael does with the SurveyId, it also failed for me, because I was passing an Int.  After quite some time trying to figure out how to debug - with W2K8 - and failing, I eventually got it working by passing a string.  Does you know of any other examples of code where I can pass other data types, or in fact, pass a collection of params of various data types.

Thanks Cathal

Mark

        protected void LinkButton1_Click(object sender, EventArgs e)

        {

            string BoatId = Common.Utilities.UrlUtils.DecryptParameter(Request.QueryString["BoatId"]);

            lblSCRNum.Text = DotNetNuke.Data.DataProvider.Instance().ExecuteScalar("usp_MB_GetSCRNumber", BoatId).ToString();

        }

 Hello Cathal,

Would you have a line or two of the sample code for the param list?  If you have it handy it would be very useful and I will post my results back, if not, not to worry.

I will need to try the generics version, it looks neat also, but I need to study that a little, i have read it, but have not yet written it.

Will post here when have something to post,

Thanks Cathal,

Mark