1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Accessing a web page but storing data locally

Discussion in 'Web Development' started by BerbBrown, Dec 14, 2010.

  1. BerbBrown

    BerbBrown New Member

    Joined:
    Dec 14, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Hi Everyone

    I hope you can help.

    We have a requirement to retrieve web pages from a central source such as a .com or .co.uk domain. The problem we have is that the data which would populate the webpage/form needs to be retrieve locally perhaps within a database such as SQL Server.

    The data CANNOT be stored centrally online due to data protection.

    Technology/Platform not a real issue at this point.

    Example
    Office has an internal network with an SQL Server/local database. User would access a website where a webpage containing a form would be retrieved and data would be retrieved from the internal SQL Server/local database and integrated and then displayed via a web browser.

    Is this possible?

    Many thanks in advance.

    BB
     
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,287
    Likes Received:
    364
    Trophy Points:
    83
    I think Yes. You can try something like this.

    Let us say you have server.com as your main server.

    Now it has some files. These files does nothing but fetches few of the files from other server say localserver1.com/somefile1 ...
     
  3. BerbBrown

    BerbBrown New Member

    Joined:
    Dec 14, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Thank you for your reply.

    My initial idea:

    We would need to sub-class Internet Explorer so that can control the document layer. We would retrieve a web page from the .com/co.uk website securely.

    We would using perhaps the Web Browser component, access the individual fields within the web page and populate these with data that has been retrieved locally from the resident SQL Server.

    This approach would require a .NET app to be installed which would both retrieve the web page and then retrieve the data and then integrate both before displaying to the browser window.

    Would this be possible?
     
  4. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,287
    Likes Received:
    364
    Trophy Points:
    83
    What you are talking about is not web based access but more like an application based access.
     
  5. BerbBrown

    BerbBrown New Member

    Joined:
    Dec 14, 2010
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Thank you for the reply once again.

    I agree. The problem we have is the customer wishes to centralise the interface, the input forms etc. This would help with updates and support. There are potentially 1000's of users.

    I guess it can only be either an online solution (website) or an application solution (installed on a workstation).

    Any other ideas?

    Many thanks once again.

    BB
     
  6. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,287
    Likes Received:
    364
    Trophy Points:
    83
    I think web based is fine because installing on 1000s of users PC is a whole lot a headache and updates are more headache.
     

Share This Page