How to Bind datalist in Client side using Jquery and Ajax

Question

How to Bind datalist in Client side using Jquery and Ajax,I tried But i cant bind the datalsit.I get the values from server side but i cannot bind the values in the client side.Please Help

Thanks n Advance

Manas Mohapatra · Answer

Please check you are getting value properly. Follow below link that may help you: http://www.c-sharpcorner.com/blogs/get-data-from-xml-content-using-javascript

Manas Mohapatra · Answer

Please share code how are you trying to get values from server.

Vasanth Jack · Answer

This is server Code: [System.Web.Script.Services.ScriptMethod()] [System.Web.Services.WebMethod] public static string range(string Price1 string Price2) { string cs = ConfigurationManager.ConnectionStrings[str].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { string str = select * from tblproddetails where ProductPrice between @1 and @2; SqlCommand cmd = new SqlCommand(str con); cmd.Parameters.AddWithValue(@1 Price1); cmd.Parameters.AddWithValue(@2 Price2); SqlDataAdapter da = new SqlDataAdapter(cmd); //DataTable ds = new DataTable(); DataSet dss = new DataSet(); da.Fill(dss tblProddetails); con.Open(); con.Close(); return dss.GetXml(); //} }

Vasanth Jack · Answer

Thanks manas I get my values .There is no issue on it.I cannot bind the values in the datalist.May i know My code is Right or Wrong? Thanks in Advance

Vasanth Jack · Answer

HiThanks For reply Already Am using Webmethod to get the values from server.Here Is my code function succes(response) { var xmlDoc = $.parseXML(response.d); var xml = $(xmlDoc); var customers = xml.find(tblProddetails); debugger; var repeatColumns = parseInt( ); var rowCount = Math.ceil(customers.length / repeatColumns); var i = 0; while (i var row = $([id*=dlViewProd]).eq(0).clone(true); for (var j = 0; j var customer = $(customers[i]); if (customer.length == 0) { $(table:last row).remove(); } else { $(#img1 row).eq(j).html(customer.find(ProductImage).text()); $(#lblPrice row).eq(j).html(customer.find(ProductPrice).text()); $(#lnkId row).eq(j).html(customer.find(ProductName).text()); } i++; } $([id*=dlViewProd]).append(row); } $([id*=dlViewProd] ).eq(0).remove(); $([id*=dlViewProd]).show(); }

Bikesh Srivastava · Answer

Hi I think best you should create webmethod for get details from server side and consume webmethod on client side.