-
December 16th, 2012, 06:54 PM
#1
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
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
-
December 17th, 2012, 10:20 AM
#2
Re: How do I copy info from Wikipedia table to combo boxes? - Really annoying me..
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
-
December 17th, 2012, 03:29 PM
#3
Re: How do I copy info from Wikipedia table to combo boxes? - Really annoying me..
If ForEach goes thru them all, then just add a counter, and add one each time?
-
December 18th, 2012, 04:07 AM
#4
Re: How do I copy info from Wikipedia table to combo boxes? - Really annoying me..
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|