<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>LINQ to XML : Join Xml Data</title><link>http://blogs.msdn.com/wriju/archive/2008/03/24/linq-to-xml-join-xml-data.aspx</link><description>Let’s say I have created two Xml files using LINQ to XML from Northwind database. I have taken two tables Category and Products and tried to join between two different files. Category XML &amp;lt;? xml version = " 1.0 " encoding = " utf-8 " ?&amp;gt; &amp;lt; categories</description><dc:language>en</dc:language><generator>CommunityServer 2.1 SP1 (Build: 61025.2)</generator><item><title>re: LINQ to XML : Join Xml Data</title><link>http://blogs.msdn.com/wriju/archive/2008/03/24/linq-to-xml-join-xml-data.aspx#8336485</link><pubDate>Tue, 25 Mar 2008 23:33:09 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8336485</guid><dc:creator>Mike1485</dc:creator><description>&lt;p&gt;Great postings&lt;/p&gt;
&lt;p&gt;just the right stuff&lt;/p&gt;
&lt;p&gt;keep it up&lt;/p&gt;</description></item><item><title>re: LINQ to XML : Join Xml Data</title><link>http://blogs.msdn.com/wriju/archive/2008/03/24/linq-to-xml-join-xml-data.aspx#8336486</link><pubDate>Tue, 25 Mar 2008 23:33:23 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8336486</guid><dc:creator>Mike1485</dc:creator><description>&lt;p&gt;Great postings&lt;/p&gt;
&lt;p&gt;just the right stuff&lt;/p&gt;
&lt;p&gt;keep it up&lt;/p&gt;</description></item><item><title>Community Convergence XLIII</title><link>http://blogs.msdn.com/wriju/archive/2008/03/24/linq-to-xml-join-xml-data.aspx#8420882</link><pubDate>Thu, 24 Apr 2008 09:08:15 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8420882</guid><dc:creator>Charlie Calvert's Community Blog</dc:creator><description>&lt;p&gt;Welcome to the forty-third issue of Community Convergence. The last few weeks have been consumed by the&lt;/p&gt;
</description></item><item><title>re: LINQ to XML : Join Xml Data</title><link>http://blogs.msdn.com/wriju/archive/2008/03/24/linq-to-xml-join-xml-data.aspx#8689855</link><pubDate>Fri, 04 Jul 2008 19:07:04 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8689855</guid><dc:creator>scotty</dc:creator><description>&lt;P&gt;How to remove the tag name from the output data?&lt;/P&gt;</description></item><item><title>re: LINQ to XML : Join Xml Data</title><link>http://blogs.msdn.com/wriju/archive/2008/03/24/linq-to-xml-join-xml-data.aspx#8692635</link><pubDate>Sat, 05 Jul 2008 08:08:44 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8692635</guid><dc:creator>wriju</dc:creator><description>&lt;p&gt;@Scotty&lt;/p&gt;
&lt;p&gt;Could you please elaborate?&lt;/p&gt;
&lt;p&gt;- Wriju&lt;/p&gt;
</description></item><item><title>re: LINQ to XML : Join Xml Data</title><link>http://blogs.msdn.com/wriju/archive/2008/03/24/linq-to-xml-join-xml-data.aspx#8692840</link><pubDate>Sat, 05 Jul 2008 10:57:54 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8692840</guid><dc:creator>Scotty</dc:creator><description>&lt;P&gt;As for your output data, how can I convert these data in html format as belows:&lt;/P&gt;
&lt;P&gt;e.g.&lt;/P&gt;
&lt;P&gt;CatagoryName &amp;nbsp; ProductID &amp;nbsp; ProductName&lt;/P&gt;
&lt;P&gt;============ &amp;nbsp; ========= &amp;nbsp; ===========&lt;/P&gt;
&lt;P&gt;Condiments &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;1 &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Chai&lt;/P&gt;
&lt;P&gt;Condiments &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;2 &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;Chang&lt;/P&gt;</description></item><item><title>re: LINQ to XML : Join Xml Data</title><link>http://blogs.msdn.com/wriju/archive/2008/03/24/linq-to-xml-join-xml-data.aspx#8692843</link><pubDate>Sat, 05 Jul 2008 11:00:23 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8692843</guid><dc:creator>Scotty</dc:creator><description>&lt;P&gt;Sorry, something missing, the output data including table tag in html format.&lt;/P&gt;</description></item><item><title>re: LINQ to XML : Join Xml Data</title><link>http://blogs.msdn.com/wriju/archive/2008/03/24/linq-to-xml-join-xml-data.aspx#8692845</link><pubDate>Sat, 05 Jul 2008 11:06:41 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8692845</guid><dc:creator>wriju</dc:creator><description>&lt;p&gt;@Scotty, &lt;/p&gt;
&lt;p&gt;Do you want to read values from Database and then show them in HTML? Or do you want to read data from XML file and then show them in HTML?&lt;/p&gt;
&lt;p&gt;Both ways, you can bind an IList object to any DataGrid, or manually do a foreach and then build your own formatted HTML table. &lt;/p&gt;
&lt;p&gt;- WRIJU&lt;/p&gt;
</description></item><item><title>re: LINQ to XML : Join Xml Data</title><link>http://blogs.msdn.com/wriju/archive/2008/03/24/linq-to-xml-join-xml-data.aspx#8696035</link><pubDate>Sun, 06 Jul 2008 14:08:29 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8696035</guid><dc:creator>Scotty</dc:creator><description>&lt;p&gt;Read data from XML file, the scenario same as your example, the output is formed to html style with table output. &lt;/p&gt;
&lt;p&gt;Have your above code can be applied on VWD2008, I want to use visual web developer 2008 express edition.&lt;/p&gt;
&lt;p&gt;Thanks.&lt;/p&gt;</description></item><item><title>re: LINQ to XML : Join Xml Data</title><link>http://blogs.msdn.com/wriju/archive/2008/03/24/linq-to-xml-join-xml-data.aspx#8777457</link><pubDate>Sun, 27 Jul 2008 08:23:45 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:8777457</guid><dc:creator>Jason33</dc:creator><description>&lt;p&gt;I am newbie for the C#, I try to test your LINQ to XML codes, everything is find, since I am using VWD, how can I display the result on the web browser using label text or text box, I tried it before, it only just show one line only!&lt;/p&gt;
&lt;p&gt;e.g.&lt;/p&gt;
&lt;p&gt;I use &lt;/p&gt;
&lt;p&gt;label1.text = k.ToString()&lt;/p&gt;
&lt;p&gt;instead of&lt;/p&gt;
&lt;p&gt;Console.WriteLine(k);&lt;/p&gt;
&lt;p&gt;so, how can I show a list result on webpage.&lt;/p&gt;</description></item></channel></rss>