how can i bind datalist using jqueryjsonweb service?

Question

Abhijit barua · Answer

i try like this... $(function () { $.ajax({ type: POST url: Default8.aspx/GetCustomers data: '{}' contentType: application/json; charset=utf-8 dataType: json success: OnSuccess failure: function (response) { alert(response.d); } error: function (response) { alert(response.d); } }); }); function OnSuccess(response) { var xmlDoc = $.parseXML(response.d); var xml = $(xmlDoc); var customers = xml.find(Table); var row = $([id*=DataList1] tr:last-child).clone(true); $([id*=DataList1] tr).not($([id*=DataList1] tr:first-child)).remove(); $.each(customers function () { var customer = $(this); $(td row).eq(0).html($(this).find(CustomerID).text()); $(td row).eq(1).html($(this).find(ContactName).text()); $(td row).eq(2).html($(this).find(City).text()); $([id*=DataList1]).append(row); row = $([id*=DataList1] tr:last-child).clone(false); }); } at .cs page [WebMethod] public static string GetCustomers() { //string query = SELECT top 10 CustomerID ContactName City FROM Customers; //SqlCommand cmd = new SqlCommand(query); //return GetData(cmd).GetXml(); SqlCommand cmd = new SqlCommand(cmdempdetails); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = cmdempdetails; return GetData(cmd).GetXml(); } private static DataSet GetData(SqlCommand cmd) { string strConnString = ConfigurationManager.ConnectionStrings[DynamicConnection].ConnectionString; using (SqlConnection con = new SqlConnection(strConnString)) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = cmd; using (DataSet ds = new DataSet()) { sda.Fill(ds); return ds; } } } } protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { this.BindDummyRow(); } } private void BindDummyRow() { DataTable dummy = new DataTable(); dummy.Columns.Add(CustomerID); dummy.Columns.Add(ContactName); dummy.Columns.Add(City); dummy.Rows.Add(); DataList1.DataSource = dummy; DataList1.DataBind(); } i get value at json. but not properly binding....i think i have problem at DataTable dummy = new DataTable(); dummy.Columns.Add(CustomerID); dummy.Columns.Add(ContactName); dummy.Columns.Add(City); dummy.Rows.Add(); DataList1.DataSource = dummy; DataList1.DataBind(); or var row = $([id*=DataList1] tr:last-child).clone(true); $([id*=DataList1] tr).not($([id*=DataList1] tr:first-child)).remove(); $.each(customers function () { var customer = $(this); $(td row).eq(0).html($(this).find(CustomerID).text()); $(td row).eq(1).html($(this).find(ContactName).text()); $(td row).eq(2).html($(this).find(City).text()); $([id*=DataList1]).append(row); row = $([id*=DataList1] tr:last-child).clone(false); }); i have not understand properly....plz help me.

Abhijit barua · Answer

thank you

Satyapriya Nayak · Answer

Hi Abhijit Please refer the below links http://www.aspdotnet-suresh.com/2012/03/bind-data-to-gridview-with-jquery-or.html http://www.mikesdotnetting.com/Article/104/Many-ways-to-communicate-with-your-database-using-jQuery-AJAX-and-ASP.NET http://weblogs.asp.net/ahmedmoosa/archive/2010/10/30/bind-gridview-using-jquery.aspx http://www.codeproject.com/Articles/106104/NET-Gridview-with-AJAX-and-REST-Web-Services Thanks

how can i bind datalist using jquery,json,web service?