Return JSON data object from Web. Method Page. Method in ASP. Net using C and VB. Net. In this article I will explain with an example, how to return JSON data object from Web. Method Page. Method in ASP. Net using C and VB. There are many ways. A simple way involves using a BindingSource in conjunction with a DataTable, DataSet, View or custom implementation of list that. Net. In this example, the JSON data object will be populated from database and it will be returned by the Web. Arena Condensed Font. Method Page. Method to j. Query AJAX function. Database. Here I am making use of Microsofts Northwind Database. The download and install instructions are provided in the following article. HTML Markup. The following HTML Markup consists of an HTML. DIV with an HTML Table. The HTML table will be used for displaying the returned JSON data object from ASP. Net Web. Method Page. Method. lt dividdv. Customers    lt tableclasstbl. Customercellpadding2cellspacing0border1    lt tr        lt th            lt b lt u lt spanclassname lt span lt u lt b        lt th    lt tr    lt tr        lt td            lt b City lt b lt spanclasscity lt span lt br            lt b Postal Code lt b lt spanclasspostal lt span lt br            lt b Country lt b lt spanclasscountry lt span lt br            lt b Phone lt b lt spanclassphone lt span lt br            lt b Fax lt b lt spanclassfax lt span lt br        lt td    lt tr lt table lt div Namespaces. You will need to import the following namespaces. Cusing System. Data. Sql. Client using System. DataGridView%20with%20MySQL.jpg?itok=bp1sJPnf' alt='Update List Using Linq In Vb.Net' title='Update List Using Linq In Vb.Net' />Configuration using System. Web. Services VB. Net. Imports System. Data. Sql. Client. Imports System. Configuration. Imports System. Web. Services. The Property Class. The following property class is created to hold the data returned from database and it is returned to the Client Side script as a JSON object. Cpublicclass. Customer    publicstring Customer. Id get set     publicstring Contact. Name get set     publicstring City get set     publicstring Country get set     publicstring Postal. Code get set     publicstring Phone get set     publicstring Fax get set VB. Net. Public. Class. VB. Net Quick Guide Learn VB. Net Programming in simple and easy steps starting from Environment setup, Basic Syntax, Data Types, Type Conversion, Variables. Create a CVB. NET kiosk application that runs on Windows and displays modern Web content using WPF or WinForms and a Browser control based on Chromium. In this article, we will learn LINQ To XML using some How Do I kind of examples. Programming XML with LINQ to XML. This section details how to program with LINQ to XML independent of LanguageIntegrated Query. Because LINQ to XML provides a fully. This code first searches the selected Employee row using LINQ. After the row is found, the update operation is performed on it. In DataGrid, every Cell is in the form. Customer    Public. Property Customer. SBx9_eddmo/hqdefault.jpg' alt='Update List Using Linq In Vb.Net' title='Update List Using Linq In Vb.Net' />Id As. String    Public. Property Contact. Name As. String    Public. Property City As. String    Public. Property Country As. String    Public. Property Postal. Code As. String    Public. Property Phone As. String    Public. Property Fax As. String. End. Class. Web. Method Page. Method returning JSON data objectThe following Web. Method Page. Method will return JSON data object. When a call is made to the Web. Method Page. Method, it first fetches the records from the database and populates a Generic list of Customer class objects and then the list is returned as a JSON object back to the Client Side function. CWeb. Methodpublicstatic. Listlt Customer Get. Customers    string constr Configuration. Manager. Connection. Stringsconstr. Connection. String    using Sql. Connection con new. Sql. Connectionconstr            using Sql. Command cmd new. Sql. CommandSELECT TOP 1. FROM Customers                    cmd. Connection con            Listlt Customer customers new. Listlt Customer             con. Open            using Sql. Data. Reader sdr cmd. Execute. Reader                            while sdr. Read                                    customers. Addnew. Customer                                            Customer. Id sdrCustomer. Id. To. String,                        Contact. Name sdrContact. Name. To. String,                        City sdrCity. To. String,                        Country sdrCountry. To. String,                        Postal. Code sdrPostal. Code. To. String,                        Phone sdrPhone. To. String,                        Fax sdrFax. To. String,                                                            con. Close            return customers            VB. Netlt Web. Method Public. Shared. Function Get. Customers As ListOf Customer    Dim constr As. Isabella Malayalam Movie Song. String Configuration. Manager. Connection. Stringsconstr. Connection. String    Using con As. New. Sql. Connectionconstr        Using cmd As. New. Sql. CommandSELECT TOP 1. FROM Customers            cmd. Connection con            Dim customers As. New ListOf Customer            con. Open            Using sdr As. Sql. Data. Reader cmd. Execute. Reader                While sdr. Read                    customers. AddNew Customer With                     . Customer. Id sdrCustomer. Id. To. String,                     . Contact. Name sdrContact. Name. To. String,                     . City sdrCity. To. String,                     . Country sdrCountry. To. String,                     . Postal. Code sdrPostal. Code. To. String,                     . Phone sdrPhone. To. String,                      . Fax sdrFax. To. String                                     End. While            End. Using            con. Close            Return customers        End. Using    End. Using. End. Function. Client Side functionality. Inside the j. Query document ready event handler, an AJAX call is made to the Web. Method Page. Method. Inside the Success event handler, a loop is executed over the items of the received JSON object. Inside the loop, the HTML Table is cloned and the columns values are set to their respective fields using the CSS class names. POST,            url Default. Get. Customers,            data ,            content. Type applicationjson charsetutf 8,            data. Type json,            success On. Success,            failure function response                 alertresponse. On. Successresponse         var table dv. Customers table. Customers table. Contact. Name           . City           . Postal. Code           . Country           . Phone           . Fax            dv. Customers. appendtable. Customers table. Screenshot.