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

Hi,Thanks 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.

How to Bind datalist in Client side using Jquery and Ajax

Answers (6)