Query Ajax Call With JSONResult in ASP. NET MVC www. dotnetmentors. For this tutorial we will use Northwind database. If you do not have Northwind database you can download from here. You will have a Drop. Down. List filled with Northwind. Home of the Microsoft ASP. NET development community. Download Visual Studio, post to the forums, read ASP. NET blogs and learn about ASP. NET. includes April 2011 Tools Update ASP. NET MVC 3 is a framework for building scalable, standardsbased web applications using wellestablished design pattern. In this article, I will show you how to globalize and localize your application in MVC 4. Black Screen After Installing Nvidia Ubuntu Open. Asp.Net Mvc File Download Example' title='Asp.Net Mvc File Download Example' />Categories table. You may check for ways to bind MVC Drop. Down. List. On selection change of this Drop. Down. List. j. Query Ajax call will be made to controller. Controller will return JSONResult and success part of ajax call will display JSONResult. Follow below steps to implement j. Query AJAX call to MVC Controller and display JSON result. Create ASP. NET MVC application. Open your Visual Studio and create empty ASP. NET MVC application. Click on File New Project Web ASP. NET web application. From next window Select template Empty and from Add folders and core reference choose MVC. Name it as AJAXCalls and click Ok. Asp.Net Mvc File Download Example' title='Asp.Net Mvc File Download Example' />For more details check Getting Started with ASP. NET MVC. Add Product Model. We will use a model class to represent Product entity. Right click on Models folder and select Add Class name it as Product click Ok. Add below properties for Product model. AJAXCalls. Models. Product. public string Product. ID get set. Product. Name get set. Quantity. Per. Unit get set. Unit. Price get set. Units. In. Stock get set. Reorder. Level get set. For detail description see ASP. NET MVC model example. Add Home. Controller. In this step you will add simple controller. Right click on Controllers folder and select Add Controller. From Add Scaffold window select MVC 5 Controller Empty and click Add. Name it as Home. Controller. Open Home. Controller from Controllers folder and add Action method with name Show. Category. Products. For more details about Action method ASP. NET MVC Controller Action Method and Action Result. Add below code to Show. Asp.Net Mvc File Download Example' title='Asp.Net Mvc File Download Example' />Category. Products. Action. Result Show. Category. Products. Listlt elect. List. Item items new Listlt Select. List. Item. Addnew Select. List. Item. Text Select Category. Value 0. Selected true. Addnew Select. List. Item Text Beverages, Value 1. Addnew Select. List. Item Text Condiments, Value 2. Addnew Select. List. Item Text Confections, Value 3. Addnew Select. List. Item Text Dairy Products, Value 4. Addnew Select. List. Item Text GrainsCereals, Value 5. Addnew Select. List. Item Text MeatPoultry, Value 6. Addnew Select. List. Item Text Produce, Value 7. KAV KIS 2010 With Serial Keys'>KAV KIS 2010 With Serial Keys. Addnew Select. List. Item Text Seafood, Value 8. View. Bag. Category. Type items. return View. It adds Category details to View. Bag property. This property values will be shown in Category Type Drop. Down. List. Show. Category. Products View. In this step you will add a MVC View to display Category and Product details. Open Home. Controller from Controllers folder Go to Show. Category. Products action method right click and select Add View. It adds a View under Views Home folder with name Show. Category. Products. Now add a Drop. Down. List to display Categories and empty Table to show products depending on selected category. Add below html to Show. Category. Products. View. Bag. Title j. Query Ajax Call example in ASP. NET MVC dotnetmentors. Query Ajax Call example in ASP. NET MVC. dotnetmentors. Html. Begin. FormCategory. Chosen, Home. Form. Method. Get. lt table cellspacing2 cellpadding2. Category Type. lt td. Html. Drop. Down. ListCategory. Type. Products classtbl. Products. lt thead. Product. IDlt th. Product. Namelt th. Quantity. Per. Unitlt th. Unit. Pricelt th. Units. In. Stocklt th. Reorder. Levellt th. Products. font family verdana,arial,sans serif. Action method to return JSONOpen Home. Controller and action method which accepts Category ID as input parameter, create list of products whose Category. ID is equal to input parameter and return it as JSON result. If you have data in Data. Table or Dataset you can convert datatable to JSON string. Add below Action method to Home. Controller. public Json. Result Get. Productsstring id. Listlt Product products new Listlt Product. FormatSELECT Product. ID, Product. Name, Quantity. Per. Unit,Unit. Price,Units. In. Stock,Reorder. Level. FROM Northwind. Products WHERE Category. ID 0,id. using Sql. Connection con new Sql. Connectionyour connection string. Sql. Command cmd new Sql. Commandquery, con. Open. Sql. Data. Reader reader cmd. Execute. Reader. Read. Add. new Product. Product. ID reader. Get. Value0. To. String. Product. Name reader. Get. String1. Quantity. Per. Unit reader. Get. String2. Unit. Price reader. Get. Value3. To. String. Units. In. Stock reader. Get. Value4. To. String. Reorder. Level reader. Get. Value5. To. String. Jsonproducts, Json. Request. Behavior. Allow. Get. It creates a list of Products model and return as JSON. Query AJAX call to MVC controller. In this step you will add code for Category. Type Drop. Down. List change event. This will create AJAX helper to call MVC controller. Below is the code which fires on change of Drop. Down. List, create AJAX call with required details, make a call to Get. Products controller. JSON result and display as Table object. Add it after lt style of above code which you added in step 4. Scriptsjquery 1. Category. Type. Products tbody tr. POST. url Url. ActionGet. Products. Type json. Category. Type. val. Product. ID lt td. Product. Name lt td. Quantity. Per. Unit lt td. Unit. Price lt td. Units. In. Stock lt td. Reorder. Level lt td. Products tbody. Query. JSONresponse. Text. Message r. Message. Stack. Trace r. Stack. Trace. alertException. Type r. Exception. Type. return false. On success it displays JSON string send by action method, manipulate it and display product details on View. Execute your application and browse to http localhost lt portnumber homeShow. Category. Products. Select any value from Category. Type Drop. Down. List. It makes an AJAX call and fill Products table. It display below screen.