Fetch data using database in JSON form and populated with Dropdown lis

 first of create you asp.net application then attach the database

then create default.aspx page then define your code fetch the data in databse in Json format
using System.Web.Script.Services; using System.Collections.Generic; using System.Web.Script.Serialization; using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Web.Services; using System.Data.SqlClient; [WebMethod] [ScriptMethod(ResponseFormat = ResponseFormat.Json)] public static string str() { SqlConnection con = new SqlConnection("XXXXi"); //Your connection string SqlCommand cmd = new SqlCommand("XXXXX", con); // Add your query SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); List<contact> AddJson = new List<contact>(); string JsonFormat =""; Contact[] contacts ={} ; string[] arrayCreate = { }; loading load = new loading(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { AddJson.Add(new Contact { Name = ds.Tables[0].Rows[i]["username"].ToString() }); // AddJson.Add(JsonFormat); } return new JavaScriptSerializer().Serialize(AddJson.ToArray()); } }

then add your aspx page using jquery
<script type="text/javascript"> function getJsonData(){ $.ajax({ type:"Post", url:"default.aspx/GetJson", data: "{}", contentType: "application/json; charset=utf-8", success:function(msg){ var data = eval("(" + msg.d + ")"); var jsonp = msg.d; var lang =''; var obj = $.parseJSON(jsonp); console.log(obj); $.each(obj,function(){ for (var i = 0; i < obj.length; i++){ lang = this['Name']; } $("#username").append("<option>"+lang+"</option>"); }); } }); } </script>


Add  you jquery in header then call in function in body onload then work perfectelly