How to invoke custom stored procedures or views

Stefan Sturm asked on January 25, 2016 14:50

Hello,

i wrote a custom stored procedure in the Database objects application and actually i'm struggling to call it programmatically.

So how to invoke it?

Regards Stefan

Correct Answer

Martin Hejtmanek answered on January 25, 2016 16:22

Hi Stefan, here is how you can do that:

QueryDataParameters parameters = new QueryDataParameters();
parameters.Add("@ClassName", className);

DataSet ds = ConnectionHelper.ExecuteQuery("Proc_CMS_Class_GetXmlSchema", parameters, QueryTypeEnum.StoredProcedure);
4 votesVote for this answer Unmark Correct answer

   Please, sign in to be able to submit a new answer.