How to Bind ul li tag using jquery in asp.net C#

rajeev kumar

9y8.1k.NET

have written this code but not getting result as i want. data is not showing in ul li but when running webservice getting all data as it is in db. please help me

javascript code is

$.ajax({

type: "POST",

url: "userControls/Wsc_comn.asmx/BindCategory",

data: "{}",

dataType: "json",

contentType: "application/json; charset=utf-8",

async: true,

success: OnSuccess,

error: OnError

});

function OnSuccess(data) {

$.each(data, function(key, value) {

$("#tablet").append("

" + value.Product_name + "

");

});

}

function OnError(data) {

}

c# code

[WebMethod]

[ScriptMethod(UseHttpGet = false, ResponseFormat = ResponseFormat.Json)]

public string BindCategory()

{

string qry = "select *from products where Product_type='TABLETS'";

DataTable dt = dllmain.ExecuteselectQry_returns_datatable(qry);

foreach (DataRow row in dt.Rows)

{

string urls = row["attachment_url"].ToString();

string catname = row["Product_name"].ToString();

}

return dllgetinfo.getdatatabletojson(dt);

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
Accepted answer
As your service return data in JSON string format. So you need convert jSON string JSON object and loop over it. Follow below code:
function OnSuccess(data) {
    var objdata = $.parseJSON(data.d);
    $.each(objdata, function(key, value) {
        $("#tablet").append("
+ value.attachment_url + "'>" + value.Product_name + "
");
    });
}
Note: If it doesn't work with data.d then use data only.
Chetan Ranpariya9y ago
Hi Rajeev,

In your code Anchor tag in LI tag is not closed. This will result in mis-formatted HTML and will not render properly.

Can you try chaging code as following in one line?
$("#tablet").append("
+ this.attachment_url + "'>" + value.Product_name + "
");
This should resolve your issue.
If not, please check following things in your code.
1. What is the use of foreach loop which is looping thru dt.Rows? It does not do any operation. That foreach loop can be removed.
2. You said that you are sure that the web service returns data. Can you share how this looks like?

If you provide this information it will be easier to understand what is not right with the code and faster to provide you the solution.

Thanks and regards,
Chetan Ranpariya