how can i bind datalist using jquery,json,web 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?

Answers (3)