Please could somebody assist this Newbie that has to provide a solution in a hurry?

I need to know if it is possible to have a grid using stored procedures to select, add, update and delete in Silverlight 2.0. The sprocs are necessary due to our policy of maintaining business rules within the stored procedures (can then be maintained by non-developers).

 If it is possible to have (hopefully basic/simple) sample code for this or a sample app then I would be truly grateful.

 Thanks so much!

rbl,

I don't think you are going to be able to directly call stored procs from your Silverlight application.  However, you could use ADO.NET Data Services to perform your CRUD operations.  Check out the following resources:

http://www.codeproject.com/kb/silverlight/crud-op-in-silverlight.aspx 

http://michaelsync.net/2008/01/15/consuming-adonet-data-service-astoria-from-silverlight 

If this has answered your question, please click on "Mark as Answer" on this post.

Thanks,
Page Brooks, MCSD, MCAD
PageBrooks.com | RSS Feed

Thanks so much for this Page, Some great info here that will assist and your suggestion that it is not possible to use Stored procs helps me know that this is not something that is obviously feasible.

I am still hoping however that somebody out there knows a way of achieving this?

If anyone else knows that this is simply not possible then please reply this as well as it will confirm what Page is saying and I can stop barking up this tree.