Sage CRM

Welcome to the Sage CRM Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

How to execute a SQL statement/procedure using .net API

Posted By MichalPoncak over 10 years ago

I am importing my data using sql server import and export wizard and that doesnt trigger my triggers so i am looking for a way to call my sql procedure by allowing a user to click on a button which will then call a sql proc.

Any suggestions are welcome. Thanks.

0 1322397 over 10 years ago

Hi,

In reference to your post, below is the code snippet to execute SQL statement in .Net API.

var sQuery = new Sage.CRM.Data.QuerySelect();
sQuery.SQLCommand = “SQL Statement”;
sQuery.ExecuteReader();

Same can be used to execute stored procedure. Refer following link for more information on working with Stored Procedures

https://community.sagecrm.com/partner_community/b/hints_tips_and_tricks/archive/2009/02/26/working-with-a-stored-procedure-that-returns-a-result-set.aspx

Hope this helps!

Regards,
Dinesh
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage CRM

How to execute a SQL statement/procedure using .net API

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING