Hi friends, am facing a small problem i think last two hours. I am trying on google but can't get proper solution yet.
Ajax and Jquery here is snippet code
$.ajax({
type: "Post",
url: "Default.aspx/_testing",
contentType: "application/json; charset=utf-8",
dataType:"json",
success: function (xml) {
$(xml).find('name').each(function () {
var sTitle = $(this).find('srno').text().fontcolor("Blue");
var bookname = $(this).find('bookname').text();
var sPublisher = $(this).find('publisher').text();
var newRow = $("<tr><td>Hi</td></tr>").css("border-width", "2px").css("border-style", "groove");
$("<li></li>").html(sTitle + " | " + bookname + "|" + sPublisher).appendTo("#dvContent ul").append("<tr><td>Hello baby</td></tr>").css("font-size", "17px").append("<a href='http://google.co.in' Target='_blank'>Download here </a>");
});
},
error: function () {
alert("An error occurred while processing XML file.");
}
});
and convert to datatable to xml:-
[System.Web.Services.WebMethod]
public static string _testing()
{
DataClassesDataContext db = new DataClassesDataContext();
DataTable dt = new DataTable("name");
dt.Columns.Add("srno");
dt.Columns.Add("bookname");
dt.Columns.Add("publisher");
DataRow row = null;
var temp= (from aa in db.testingTable_s.AsEnumerable() select new { sr=aa.srno,name=aa.Title,pub=aa.Publisher });
foreach (var item in temp)
{
row = dt.NewRow();
dt.Rows.Add(item.sr, item.name, item.pub);
}
string result;
using (StringWriter st = new StringWriter())
{
dt.WriteXml(st);
result = st.ToString();
}
return result;
}
and after converting datatable to xml code is looks like
<DocumentElement>
<name>
<srno>1</srno>
<bookname>.net</bookname>
<publisher>PB</publisher>
</name>
<name>
<srno>2</srno>
<bookname>Java</bookname>
<publisher>Head first</publisher>
</name>
<name>
<srno>3</srno>
<bookname>Jquery</bookname>
<publisher>Complete Reference</publisher>
</name>
</DocumentElement>
my problem is jqery can't search a
"name"