billy_111 0 Newbie Poster

Hi,
I have the following RSS feed:-

http://www.schok.co.uk/lottery/lottery.xml

It displays a number of feeds, but i am particularly looking at the fifth feed, which says "The Main UK Lottery Draw Numbers for 27-12-2008". What i need to do is obtain the winning numbers from the feed and check them against a database of numbers which users of my website have inserted. But i do no know how to go about doing this.

So far i have got what is shown below:-

<asp:DataList ID="DataList1" runat="server" DataSourceID="XmlDataSource1" 
            CellPadding="4" ForeColor="#333333" Height="78px" Width="225px">
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <AlternatingItemStyle BackColor="White" />
            <ItemStyle BackColor="#E3EAEB" />
            <SelectedItemStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <ItemTemplate>
                <%#XPath ("description")%><br/><br/>
            </ItemTemplate>
        </asp:DataList>
        <asp:XmlDataSource ID="XmlDataSource1" runat="server" 
            DataFile="http://www.schok.co.uk/lottery/lottery.xml" 
            XPath="rss/channel/item[position()&lt;=6]"></asp:XmlDataSource>

The first problem here is that it shows all 6 feeds, and i only want it show the fifth feed. Then the major problem is how would i be able to read ONLY the numbers and check them or even insert them into an Access database..?

Thank You
Regards
Billy

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.