move the items by using the json

Question

hi,,, i have one small problem i am created a database student id and names after that i output based on the data base showing the names in the dropdown list1.my problem is that showing names should move to the another dropdownlist2 the total programe in json only

Nilesh Shah · Answer

JSON is not a programming language, so your statement to develop everything in "JSON only" is wrong. You may be doing that programming in JS - JavaScript please post what you have done till now, and what problem you are facing to move ahead, then someone can help you

chandra sekhar · Answer

Bind Dropdownlist json $(document).ready(function () { var Name=ddlObj.value; debugger; $.ajax({ url: "WebForm1.aspx/GetData", data: JSON.strngify({Names:Name}), dataType: "json", Type:'Post', contentType: "application/json; charset=utf-8", success: function chandra(data) { debugger: var jsdata = JSON.parse(data); BindDropdownlist(jsdata); var textval=jsdata.selectedIndex(); --------------------------}i am struct here textval=document.getElementById('TextBox1');------------} }, error: function (data) { alert("error found"); } }); }                         aspx.cs code 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.Data.SqlClient; using System.Collections.Generic; using System.Web.Services; using Newtonsoft.Json; using System.Web.Script.Serialization; namespace _2905json_passing { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { var data = BindDropdownlist(); DropDownList1.DataSource = data; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "Select name"); } public static string[] BindDropdownlist() { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString); DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter("Select Name from Customers", con); da.Fill(dt); return dt.AsEnumerable().Select(k => k[0] + "").ToArray(); } public static string Getdata(string Names) { if(BindDropdownlist().Contains(Names)) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString); SqlCommand cmd =new SqlCommand("select * from Customers" + Names ,con); SqlDataAdapter da=new SqlDataAdapter(cmd); DataTable dt=new DataTable(); da.Fill(dt); string jsdata=JsonConvert.SerializeObject(dt); return jsdata; } else return "Names are not showing"; } } }

move the items by using the json

Answers (2)