Post
Ask Question
Indhu Mathi

Indhu Mathi

  • NA
  • 60
  • 6k

unable to get particular data from xml using jquery

Jul 24 2017 7:24 AM
I need to find a particular data from jquery.here my code.But i don't know what was fault in thisI could not fetch data from jquery.Anyone help me to do this
 
Aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Products.aspx.cs" Inherits="jQuery1.Products" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js"></script>
<script src="patricularFetch.js" type="text/javascript"></script>
</head>
<body>
<form id="form1" runat="server">
<div>
Name:<input type="text" id="txtID" /><br />
Please click to load the products from server:<br /><br />
<input type="button" id="loadBtn" value="Load XML"/>
<br/><br/>
<div id="products"></div>
</div>
</form>
</body>
</html>
 
xml 
<?xml version="1.0" encoding="UTF-8"?>
<products>
<product>
<id>P-22345</id>
<name>LCD Television</name>
<price>$500</price>
<discount>5%</discount>
</product>
<product>
<id>P-13245</id>
<name>Mac Mini</name>
<price>$700</price>
<discount>2%</discount>
</product>
<product>
<id>P-52346</id>
<name>Home Theatre</name>
<price>$500</price>
<discount>1%</discount>
</product>
<product>
<id>P-78385</id>
<name>Laptop Computer</name>
<price>$1500</price>
<discount>5%</discount>
</product>
<product>
<id>P-78385</id>
<name>Desktop Computer</name>
<price>$1000</price>
<discount>7%</discount>
</product>
</products>
 
js 
 
$(document).ready(function() {
$('#loadBtn').click(function() {
$.ajax({
url:'Product_details.xml',
type:'get',
datatype:'xml',
error:function(jqxHR,textstatus,errorThrown){
Console.log('Error:',+errorThrown);},
success:function(xml){
xmlDoc = $.parseXML( xml );
$xml = $( xmlDoc );
if($xml.find("product").length>0&&$.trim("id").length>0)
{
var id = $.trim($("#txtID").val());
var product="Product: Contains('"+id+"')";
if(product.length>0)
{
console.log('AJAX Request is succeded.');
var productsTable = '';
productsTable += '<table id="productsTable" cellspacing="0" cellpadding="2" border="1">';
productsTable += '<thead><td>Id</td><td>Name</td><td>Price</td><td>Discount</td></thead>';
productsTable += '<tr>';
productsTable += '<td>'+$(xml).find(product).text()+'</td>';
productsTable += '<td>'+$(xml).find(product).next("name").text()+'</td>';
productsTable += '<td>'+$(xml).find(product).next("price").text()+'</td>';
productsTable += '<td>'+$(xml).find(product).next("discount").text()+'</td>';
productsTable += '</tr>';
productsTable += '</table>';
$("#products").append(productsTable);
}
else
{
$("#products").append("No elements found"+product);
}
}
},
});
});
});
 

Answers (1)