1-888-365-2779
+1-888-365-2779
Try Now
More in this section

Forums / Developing with Sitefinity / how to use Stored Procedure defined in oracle db in sitefinity user control

how to use Stored Procedure defined in oracle db in sitefinity user control

4 posts, 0 answered
  1. amar koli
    amar koli avatar
    19 posts
    Registered:
    19 Feb 2010
    16 Mar 2010
    Link to this post
    Hi,

    I have a user control page (.ascx) page, i want to add a datagrid in the page and use the output of the Stored Procedure to display it in the datagrid. what should i use in sitefinity or in the .ascx page, are there any functions/method to get this using the sitefinity code in the ascx page.

    please help,
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    16 Jun 2017
    16 Mar 2010
    Link to this post
    Hi amar koli,

    We do not expose API for managing stored procedures. You can use some queries to the database to return the correct values.

    Kind regards,
    Ivan Dimitrov
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  3. amar koli
    amar koli avatar
    19 posts
    Registered:
    19 Feb 2010
    16 Mar 2010
    Link to this post
    Hi ,

    Can you guide me to a sample code to do this and using the sitefinity connection to the database.
  4. Georgi
    Georgi avatar
    3583 posts
    Registered:
    28 Oct 2016
    16 Mar 2010
    Link to this post
    Hi amar koli,

    The Query that you should run is:

    Execute <StoredProcedure>;

    You can actually open another connection to the database, since we do not provide API for direct database operations. 

    Best wishes,
    Georgi
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Register for webinar
4 posts, 0 answered