C#

XmlNode sizeNode = xmlnode.SelectSingleNode("torrent:contentLength");

private void button1_Click(object sender, EventArgs e)
    {
        var xmlDoc = new XmlDocument();
        xmlDoc.Load("movies.xml");

        var xmlNode = xmlDoc.SelectSingleNode("//rss/channel");
        var i = 0;
        foreach (XmlNode xmlnode in xmlNode)
        {

            XmlNode titleNode = xmlnode.SelectSingleNode("title");
            XmlNode categoryNode = xmlnode.SelectSingleNode("category");
            XmlNode dateNode = xmlnode.SelectSingleNode("pubDate");
            XmlNode sizeNode = xmlnode.SelectSingleNode("torrent:contentLength");

            if ((titleNode != null) && (dateNode != null) &&
                (categoryNode != null) && (sizeNode != null) )
            {
                DgvMain.Rows.Add();
                DgvMain.Rows[i].Cells[1].Value = titleNode.InnerText;
                DgvMain.Rows[i].Cells[2].Value = categoryNode.InnerText;
                DgvMain.Rows[i].Cells[3].Value = dateNode.InnerText;
                DgvMain.Rows[i].Cells[4].Value = sizeNode.InnerText;
                i++;
            }

        }

  <?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:torrent="http://xmlns.ezrss.it/0.1/">
<channel>
    <title>movies torrents RSS feed - KickassTorrents</title>
    <link>http://kickass.to/</link>
    <description>movies torrents RSS feed</description>
    <item>
        <title>Al Murray My Gaff My Rules 2003 Xvid Mp3.avi</title>

        <category>Movies</category>
      <author>http://kickass.to/user/Stull/</author>        <link>http://kickass.to/al-murray-my-gaff-my-rules-2003-xvid-mp3-avi-t10314315.html</link>
        <guid>http://kickass.to/al-murray-my-gaff-my-rules-2003-xvid-mp3-avi-t10314315.html</guid>
        <pubDate>Sat, 07 Mar 2015 00:27:56 +0000</pubDate>
        <torrent:contentLength>548352170</torrent:contentLength>
        <torrent:infoHash>EDBA9CB0942265440B3A0AC6FD70B39CD4384E54</torrent:infoHash>
        <torrent:magnetURI><![CDATA[magnet:?xt=urn:btih:EDBA9CB0942265440B3A0AC6FD70B39CD4384E54&dn=al+murray+my+gaff+my+rules+2003+xvid+mp3+avi&tr=udp%3A%2F%2Ftracker.leechers-paradise.org%3A6969%2Fannounce&tr=udp%3A%2F%2Fopen.demonii.com%3A1337]]></torrent:magnetURI>
        <torrent:seeds>1</torrent:seeds>
        <torrent:peers>1</torrent:peers>
        <torrent:verified>0</torrent:verified>
        <torrent:fileName>al.murray.my.gaff.my.rules.2003.xvid.mp3.avi.torrent</torrent:fileName>
        <enclosure url="http://torcache.net/torrent/EDBA9CB0942265440B3A0AC6FD70B39CD4384E54.torrent?title=[kickass.to]al.murray.my.gaff.my.rules.2003.xvid.mp3.avi" length="548352170" type="application/x-bittorrent" />
    </item>

namespace ProjectLab1
{
    class Program
    {
        static void Main(string[] args)
        {
            //Connection string needed to talk to Omnymbus
            string conString = "Driver={MySQL ODBC 5.3 ANSI Driver};"
                + "Server=devry.edupe.net;Port=4300;"
                + "Database=Inventory_XXXX;"
                + "uid=XXXX;pwd=DeVry_Student";
            OdbcConnection connection = new OdbcConnection(conString);
            connection.Open();
            //Get all data
            //string theQuery = "SELECT * FROM item";
            string theQuery = "SELECT * FROM item i, inventory v where i.invent_id=v.invent_id";
            OdbcDataAdapter DataAdapter = new OdbcDataAdapter(theQuery, connection);
            DataSet theData = new DataSet();
            DataAdapter.Fill(theData, "item");
            DataTable theTable = theData.Tables[0];

            Console.Write("ITEM".PadRight(30));
            Console.Write("QUANT".PadLeft(10));
            Console.Write("SIZE".PadLeft(10));
            Console.Write("COLOR".PadLeft(10));
            Console.Write("PRICE\n".PadLeft(10));//the "\n" moves cursor to next line
            Console.WriteLine("-".PadLeft(70, '-'));// "WriteLine" places cursor next line

            // Loop through all data results
            foreach (DataRow dataRow in theTable.Rows)
            {
                Console.Write(dataRow["invent_desc"].ToString().PadRight(30));
                Console.Write(dataRow["qoh"].ToString().PadLeft(10));
                Console.Write(dataRow["itemsize"].ToString().PadLeft(10));
                Console.Write(dataRow["color"].ToString().PadLeft(10));
                Console.WriteLine(((decimal)dataRow["curr_price"]).ToString("C").PadLeft(10));

            }

            {



                StreamWriter file = new StreamWriter(@"C:\Users\redfaction\Desktop\Data\" + strFileName);
                file.WriteLine(sb.ToString());
                File.Close();
                connection.Close(); // Close connection

                //Have program pause to keep from closing console window



            }
        }
    }
}