How do I copy info from Wikipedia table to combo boxes? - Really annoying me..

need to somehow copy the number of seasons and episodes in each season from a Wikipedia table into two combo boxes. One for seasons and the other for episodes. The apps supposed to allow the user to type in their favorirte show in the top input box.
Then fill the first combo box with the number of seasons and when the user selects one the relevant number of episodes are shown

http://www.vbdotnetforums.com/attach...e-untitled.png

My code so far is here

Public Class Form1
Dim Search As String
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
Search = TextBox1.Text
Search = Search.Replace(" ", "+")
Search = "http://www.google.com/search?btnI=I'm+Feeling+Lucky&q=" & Search & "episode+list+wikipedia"


If Asc(e.KeyChar) = 13 Then


WebBrowser1.Navigate(Search)
TextBox1.Text = Search




End If
End Sub
End Class

So far I've found out howto download the page source even manipulate the page a little but I don't know how to use this to get the number of seasons and episodes in each season into combo boxes. Any help would be great thanks

Code:

Imports System.Text.RegularExpressions

Public Class Form1
Dim sourcecode As String
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
sourcecode = ((New Net.WebClient).DownloadString("http://en.wikipedia.org/wiki/List_of_House_episodes#Series_overview_and_ratings"))

Dim Code As String
Dim Information As MatchCollection = Regex.Matches(sourcecode, "<td>(.*?)</td>", RegexOptions.None)
For Each Info In Information
Code = Regex.Replace(Info.ToString, "td>", "", RegexOptions.None)
Code = Regex.Replace(Code, "</td>", "", RegexOptions.None)
MsgBox(Code)
Next
End Sub
End Class

If ForEach goes thru them all, then just add a counter, and add one each time?

Web Scraping is not really allowed here, as activities such as that is against the AUP. I am closing this thread now. If you want me to re-open this thread, please feel free to send me a PM with your legal reasoning bebind this