How to create a JSON restful webservice in ASP.NET C# that connect to MS SQL Database and retrieve stored procedures values from the database?

Question

0.00/5 (No votes)

See more:

How to create a JSON restful webservice in ASP.NET C# that connect to MS SQL Database and retrieve stored procedures values from the database?. I have all stored procedures, data access layers and business layer available in my project. But I do not know how to create restful web service and how to call stored procedures values.

This webservice will eventually be used to communicate with iPhone SDK. And results of this web service will be shown in iPhone application. This iPhone application will be installed on iphone , and it will interact web service to get database values.

Any help would be appreciated.

Thanks!

Posted 7-Dec-11 22:13pm

Waseem Fastian

Add a Solution

3 solutions

Solution 5

For communicating iphone with restful web service which uses json as data, the best library is restkit:

https://github.com/RestKit/RestKit[^]

Posted 16-Dec-12 3:42am

Ankit Kumar Gupta

Solution 6

Here's a pretty good walkthrough of creating your first JSON web service from scratch, loading and saving data from SQL Server, and even displaying it using JavaScript or on an iPhone:

[Creating a JSON Web Service]

I think that pretty much covers everything you were asking for !!!

Posted 4-Dec-13 4:49am

Mike Gledhill

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RaisKazi · Accepted Answer · 2011-12-07T23:18:00

Using .Net Framework 3.5 or above you can develop REST based Service. You may refer below links for more information on this.

http://msdn.microsoft.com/en-us/library/dd203052.aspx

http://msdn.microsoft.com/en-us/netframework/dd547388

http://msdn.microsoft.com/en-us/netframework/cc950529

For JSON and WCF REST Services.

http://dotnetninja.wordpress.com/2008/05/02/rest-service-with-wcf-and-json/

http://debugmode.net/2011/05/15/wcf-rest-service-with-josn-data/

However to develop REST Service, WCF support is not obligatory, you can develop REST Service even using simple HttpHandler or HttpModule.

Developing a REST Web Service using C# - A walkthrough

To call your SQL Server Stored Procedure you may use Ado.Net.

http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx

How to create a JSON restful webservice in ASP.NET C# that connect to MS SQL Database and retrieve stored procedures values from the database?

3 solutions

Solution 2

Solution 5

Solution 6

Add your solution here

Preview 0

How to create a JSON restful webservice in ASP.NET C# that connect to MS SQL Database and retrieve stored procedures values from the database?

3 solutions

Solution 2

Solution 5

Solution 6

Add your solution here

Preview 0

Existing Members

...or Join us