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
