Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Help with a Project

Help with a Project

Scheduled Pinned Locked Moved The Lounge
databasehelptutorial
8 Posts 6 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Offline
    K Offline
    Kevin Guarino
    wrote on last edited by
    #1

    Hello out there I need help with a project. Retrieving information from a text file that is in a website. For example: Steve Smith, a runner, would like to retrieve his race results, stored as text files, from a number of different websites. The results gathered would pertain to him only,not all participants, and need to be stored in a database for future reference.

    S C B 3 Replies Last reply
    0
    • K Kevin Guarino

      Hello out there I need help with a project. Retrieving information from a text file that is in a website. For example: Steve Smith, a runner, would like to retrieve his race results, stored as text files, from a number of different websites. The results gathered would pertain to him only,not all participants, and need to be stored in a database for future reference.

      S Offline
      S Offline
      ScottSingleton
      wrote on last edited by
      #2

      With .NET this really is ungodly simple. I'm not sure what type of help you're looking for. in VB.Net you can download a file from the web: Dim myWebClient As New WebClient() myWebClient.DownloadFile(StrSourceURL, strDestinationLocation) myWebClient.Dispose() Parse the file using a Regular Expression. Extract the values from the Regex statement, pump to SQL Server. poof! Magic :)

      I A K 3 Replies Last reply
      0
      • K Kevin Guarino

        Hello out there I need help with a project. Retrieving information from a text file that is in a website. For example: Steve Smith, a runner, would like to retrieve his race results, stored as text files, from a number of different websites. The results gathered would pertain to him only,not all participants, and need to be stored in a database for future reference.

        C Offline
        C Offline
        Christian Graus
        wrote on last edited by
        #3

        I take it from your inability to read the 'no programming questions in the lounge' above that this is a VB.NET question ? Ask in the VB.NET forum in future. Christian I have several lifelong friends that are New Yorkers but I have always gravitated toward the weirdo's. - Richard Stringer

        1 Reply Last reply
        0
        • S ScottSingleton

          With .NET this really is ungodly simple. I'm not sure what type of help you're looking for. in VB.Net you can download a file from the web: Dim myWebClient As New WebClient() myWebClient.DownloadFile(StrSourceURL, strDestinationLocation) myWebClient.Dispose() Parse the file using a Regular Expression. Extract the values from the Regex statement, pump to SQL Server. poof! Magic :)

          I Offline
          I Offline
          Ivor S Sargoytchev
          wrote on last edited by
          #4

          Answering programming questions in the lounge is just as bad as asking them.

          1 Reply Last reply
          0
          • K Kevin Guarino

            Hello out there I need help with a project. Retrieving information from a text file that is in a website. For example: Steve Smith, a runner, would like to retrieve his race results, stored as text files, from a number of different websites. The results gathered would pertain to him only,not all participants, and need to be stored in a database for future reference.

            B Offline
            B Offline
            brianwelsch
            wrote on last edited by
            #5

            for(int i=0; i<NumberOfWebsites; i++) { // Enter URL into address bar and hit ENTER // CTRL+F 'Steve Smith' ENTER // Add result to database through some UI. } HTH. BW


            "Get up and open your eyes. Don't let yourself ever fall down.
            Get through it and learn how to fly. I know you will find a way...
            Today"
            -Days of the New

            K 1 Reply Last reply
            0
            • S ScottSingleton

              With .NET this really is ungodly simple. I'm not sure what type of help you're looking for. in VB.Net you can download a file from the web: Dim myWebClient As New WebClient() myWebClient.DownloadFile(StrSourceURL, strDestinationLocation) myWebClient.Dispose() Parse the file using a Regular Expression. Extract the values from the Regex statement, pump to SQL Server. poof! Magic :)

              A Offline
              A Offline
              Andy Brummer
              wrote on last edited by
              #6

              lastmang0 said: I'm not sure what type of help you're looking for. He wants help with his homework.:sigh:


              I can imagine the sinking feeling one would have after ordering my book, only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon

              1 Reply Last reply
              0
              • B brianwelsch

                for(int i=0; i<NumberOfWebsites; i++) { // Enter URL into address bar and hit ENTER // CTRL+F 'Steve Smith' ENTER // Add result to database through some UI. } HTH. BW


                "Get up and open your eyes. Don't let yourself ever fall down.
                Get through it and learn how to fly. I know you will find a way...
                Today"
                -Days of the New

                K Offline
                K Offline
                Kevin Guarino
                wrote on last edited by
                #7

                Thank You for the help. Can this process be automated through the use of some sort of spidering program?

                1 Reply Last reply
                0
                • S ScottSingleton

                  With .NET this really is ungodly simple. I'm not sure what type of help you're looking for. in VB.Net you can download a file from the web: Dim myWebClient As New WebClient() myWebClient.DownloadFile(StrSourceURL, strDestinationLocation) myWebClient.Dispose() Parse the file using a Regular Expression. Extract the values from the Regex statement, pump to SQL Server. poof! Magic :)

                  K Offline
                  K Offline
                  Kevin Guarino
                  wrote on last edited by
                  #8

                  Thank You for the help. Are you describing the method through which this process can be automated through a website, and have the information stored on a database for future reference.

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups