0

I am trying to search a dataset I have populated from several XML files for certain words in each column. The dataset table is "item" and the columns I want searched is "descritption". "description" are several articles from an rss feed. I want to search the articles for sports players names. For example in the article
"Jimmy Graham returns to a limited practice - Jimmy Graham | NO" I would like to search for "Jimmy Graham" and once found I want the entire article description to be displayed in a listbox. I am essentially searching for player names which the user enters in another listbox (addteamform.addplayerlistbox) for articles containing that player name, then displaying them in another listbox (mainform.articlelistbox). here is my code I am using to try to search the dataset/dataview for a specific name in an article. I am sure the code is all wrong for what I'm trying to do...

 Public Shared Sub searchPlayers()
        MainForm.articleListBox.DataBindings.Clear()

        Dim ds As DataSet = New DataSet

        ds.ReadXml("http://www.rotoworld.com/rss/feed.aspx?sport=nfl&ftype=news&count=12&format=rss")
        ds.ReadXml("http://rss.footballguys.com/bloggerrss.xml")
        ds.ReadXml("http://www.fantasyfootballstarters.com/podcast.xml")
        ds.ReadXml("http://cbssports.com/partners/feeds/rss/football_fantasy_news")
        ds.ReadXml("http://www.fantasysp.com/rss/nfl/columns/")
        ds.ReadXml("http://sports.yahoo.com/nfl/rss.xml")
        ds.ReadXml("http://feeds2.feedburner.com/fantasyfootballcom")

        Dim dv As New DataView
        dv.Table = ds.Tables("item")
        Dim drv As DataRowView 'Data Row View object to query DataView object

        'Filter based on a listbox value selected
        dv.RowFilter = "title" & CInt(addTeamForm.playerListBox.SelectedItem)

        'Retrieve my values returned in the result
        For Each drv In dv
            MainForm.articleListBox.Items.Add("title")
        Next





    End Sub
2
Contributors
1
Reply
2
Views
4 Years
Discussion Span
Last Post by G_Waddell
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.