Consume Json Web Service in ASP.Net using C# and VB.Net

Question

hi I want to make restful webservice which fetch data from sql server database and give out in json format Please share some snippet on internet it is very complex i believe you make it very easy to understand and useful thanks

nauna · Accepted Answer

httpwwwcsharpcornercomarticlegeneratejsondatausingwebserviceandsqlserverstoredprocedure i want some thing like this but this tutorial is very complex and using store procedure i want sql statement in web service instead of store procedure

AnandM · Answer

Hi naunaI have created a sample which full fill your requirement you need to modify the code according to your needI have used Northwind Database Customers Table you can get Database from below linkInstall the Northwind and Pubs Sample Databases in SQL Server Express Refer below Sample CodeWebServiceasmxlt WebService Language34C34 CodeBehind34AppCodeWebServicecs34 Class34WebService34 gtWebServicecsusing SystemCollectionsGenericusing SystemWebServicesusing SystemDataSqlClientusing SystemConfigurationusing SystemWebScriptSerialization ltsummarygt Summary description for WebService ltsummarygtWebServiceNamespace  34httptempuriorg34WebServiceBindingConformsTo  WsiProfilesBasicProfile11 To allow this Web Service to be called from script using ASPNET AJAX uncomment the following line SystemWebScriptServicesScriptServicepublic class WebService  SystemWebServicesWebService    WebMe

Consume Json Web Service in ASP.Net using C# and VB.Net

Company

Explore

Follow us

Contact Us