Connecting Tech Pros Worldwide Help | Site Map

How to query a website from a form

  #1  
Old November 12th, 2005, 05:22 PM
Wim Verhavert
Guest
 
Posts: n/a
Hi all,

For gathering certain information in building my database, I'm depending
on the things I found on the web, especially one website (let's call it
www.mywebsite.com). Is there a way to query this site (it has fill in
boxes on the page and a search button) depending on values in my form
and getting the results back in my form? This (general) question is
keeping me out of my sleep for weeks now....

Any tip is appreciated....

Kind regards,

Wim

  #2  
Old November 12th, 2005, 05:23 PM
TC
Guest
 
Posts: n/a

re: How to query a website from a form


Try the microsoft webbrowser control. Drop one onto your form, then you can
use the .Navigate method to go to that website. Then you can use the methods
& properties of the HTML Document Object Model (which are exposed through
the webbrowser control) to retrieve data from the HTML that the website sent
you.

HTH,
TC


"Wim Verhavert" <wim_verhavert@yahoo.com> wrote in message
news:1070560814.112262@seven.kulnet.kuleuven.ac.be ...[color=blue]
> Hi all,
>
> For gathering certain information in building my database, I'm depending
> on the things I found on the web, especially one website (let's call it
> www.mywebsite.com). Is there a way to query this site (it has fill in
> boxes on the page and a search button) depending on values in my form
> and getting the results back in my form? This (general) question is
> keeping me out of my sleep for weeks now....
>
> Any tip is appreciated....
>
> Kind regards,
>
> Wim
>[/color]


  #3  
Old November 12th, 2005, 05:23 PM
Wim Verhavert
Guest
 
Posts: n/a

re: How to query a website from a form


Is there also a way of automatically filling in the form on that
website? That the program doesn't automatically outputs the data to my
form is not so big a problem.

Thanks anyway!

Regards,
WV

TC wrote:[color=blue]
> Try the microsoft webbrowser control. Drop one onto your form, then you can
> use the .Navigate method to go to that website. Then you can use the methods
> & properties of the HTML Document Object Model (which are exposed through
> the webbrowser control) to retrieve data from the HTML that the website sent
> you.
>
> HTH,
> TC
>
>
> "Wim Verhavert" <wim_verhavert@yahoo.com> wrote in message
> news:1070560814.112262@seven.kulnet.kuleuven.ac.be ...
>[color=green]
>>Hi all,
>>
>>For gathering certain information in building my database, I'm depending
>>on the things I found on the web, especially one website (let's call it
>>www.mywebsite.com). Is there a way to query this site (it has fill in
>>boxes on the page and a search button) depending on values in my form
>>and getting the results back in my form? This (general) question is
>>keeping me out of my sleep for weeks now....
>>
>>Any tip is appreciated....
>>
>>Kind regards,
>>
>>Wim
>>[/color]
>
>
>[/color]

  #4  
Old November 12th, 2005, 05:25 PM
TC
Guest
 
Posts: n/a

re: How to query a website from a form


Yes, you just use the objects, methods & properties of the Document Object
Model, which is exposed by the webbrowser control. This is similar in
principle (but different in detail) to programming in VBA. For example,
you'd use the Submit method of the relevant named form of the Document
object, to send the form.

Wim, I haven't done this for some time, & the details are no longer clear in
my mind. So you'll have to do some research! Check out the web for
information on "webbrowser control" and "HTML Document Object Model".

HTH,
TC


"Wim Verhavert" <wim_verhavert@yahoo.com> wrote in message
news:1070615295.353038@seven.kulnet.kuleuven.ac.be ...[color=blue]
> Is there also a way of automatically filling in the form on that
> website? That the program doesn't automatically outputs the data to my
> form is not so big a problem.
>
> Thanks anyway!
>
> Regards,
> WV
>
> TC wrote:[color=green]
> > Try the microsoft webbrowser control. Drop one onto your form, then you[/color][/color]
can[color=blue][color=green]
> > use the .Navigate method to go to that website. Then you can use the[/color][/color]
methods[color=blue][color=green]
> > & properties of the HTML Document Object Model (which are exposed[/color][/color]
through[color=blue][color=green]
> > the webbrowser control) to retrieve data from the HTML that the website[/color][/color]
sent[color=blue][color=green]
> > you.
> >
> > HTH,
> > TC
> >
> >
> > "Wim Verhavert" <wim_verhavert@yahoo.com> wrote in message
> > news:1070560814.112262@seven.kulnet.kuleuven.ac.be ...
> >[color=darkred]
> >>Hi all,
> >>
> >>For gathering certain information in building my database, I'm depending
> >>on the things I found on the web, especially one website (let's call it
> >>www.mywebsite.com). Is there a way to query this site (it has fill in
> >>boxes on the page and a search button) depending on values in my form
> >>and getting the results back in my form? This (general) question is
> >>keeping me out of my sleep for weeks now....
> >>
> >>Any tip is appreciated....
> >>
> >>Kind regards,
> >>
> >>Wim
> >>[/color]
> >
> >
> >[/color]
>[/color]


  #5  
Old November 12th, 2005, 05:31 PM
Wim Verhavert
Guest
 
Posts: n/a

re: How to query a website from a form


Thanks a lot for all the help!!! You put me in a good thinking path...

TC wrote:
[color=blue]
> Yes, you just use the objects, methods & properties of the Document Object
> Model, which is exposed by the webbrowser control. This is similar in
> principle (but different in detail) to programming in VBA. For example,
> you'd use the Submit method of the relevant named form of the Document
> object, to send the form.
>
> Wim, I haven't done this for some time, & the details are no longer clear in
> my mind. So you'll have to do some research! Check out the web for
> information on "webbrowser control" and "HTML Document Object Model".
>
> HTH,
> TC
>
>
> "Wim Verhavert" <wim_verhavert@yahoo.com> wrote in message
> news:1070615295.353038@seven.kulnet.kuleuven.ac.be ...
>[color=green]
>>Is there also a way of automatically filling in the form on that
>>website? That the program doesn't automatically outputs the data to my
>>form is not so big a problem.
>>
>>Thanks anyway!
>>
>>Regards,
>>WV
>>
>>TC wrote:
>>[color=darkred]
>>>Try the microsoft webbrowser control. Drop one onto your form, then you[/color][/color]
>
> can
>[color=green][color=darkred]
>>>use the .Navigate method to go to that website. Then you can use the[/color][/color]
>
> methods
>[color=green][color=darkred]
>>>& properties of the HTML Document Object Model (which are exposed[/color][/color]
>
> through
>[color=green][color=darkred]
>>>the webbrowser control) to retrieve data from the HTML that the website[/color][/color]
>
> sent
>[color=green][color=darkred]
>>>you.
>>>
>>>HTH,
>>>TC
>>>
>>>
>>>"Wim Verhavert" <wim_verhavert@yahoo.com> wrote in message
>>>news:1070560814.112262@seven.kulnet.kuleuven.ac .be...
>>>
>>>
>>>>Hi all,
>>>>
>>>>For gathering certain information in building my database, I'm depending
>>>>on the things I found on the web, especially one website (let's call it
>>>>www.mywebsite.com). Is there a way to query this site (it has fill in
>>>>boxes on the page and a search button) depending on values in my form
>>>>and getting the results back in my form? This (general) question is
>>>>keeping me out of my sleep for weeks now....
>>>>
>>>>Any tip is appreciated....
>>>>
>>>>Kind regards,
>>>>
>>>>Wim
>>>>
>>>
>>>
>>>[/color][/color]
>
>[/color]

Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help to paginate query result siridyal answers 8 August 24th, 2007 01:46 AM
classic asp - returning records from access in a random order InnoCreate answers 6 October 25th, 2006 04:05 PM
displaying images on a website from binary CLEAR-RCIC answers 3 January 27th, 2006 07:05 PM
form data will not post Nomen Nescio answers 4 July 17th, 2005 12:05 AM