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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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