Using Stored Procedures to Insert, Update, Delete

2 posts, 0 answers
  1. Mark
    Mark avatar
    13 posts
    Member since:
    Dec 2010

    Posted 23 May 2011 Link to this post

    I am looking for a way to implement the following with the DomainDataSource and GridView:

    I have one stored procedure, "GetAccounts" that takes an Int parameter for a Customer ID.  This will return all Accounts for a particular Customer.  I want to be able to add a row to the GridView that is bound to this DomainDtaSource and have a new Account record added.  I am attempting to do this using another stored procedure: "AddAccount" that also has the Customer ID as a parameter.

    Can you give me some general ideas on how to get this to work, i.e. reading the data through one stored proc and inserting, updating and deleting via others.

  2. Rossen Hristov
    Rossen Hristov avatar
    2478 posts

    Posted 25 May 2011 Link to this post

    Hi Mark,

    Since your question is really about WCF RIA Services and stored procedures and is not specifically connected with any Telerik control, my suggestion is to post it on the WCF RIA Services forums and I am sure that you will get a lot of feedback there.

    In other words, using RadDomainDataSource you can do this in absolutely the same way as you would do it with the stock WCF RIA DomainDataSource. There is no difference.

    Here is what I found after a quick Google search. Anyway, my suggestion is to ask the guys on the WCF RIA Services forums what is the best way to use WCF RIA Services with Stored Procedures.

    Thank you for your understanding.

    Best wishes,
    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. DevCraft banner
Back to Top