Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Web Development (http://www.go4expert.com/forums/web-development-forum/)
-   -   Accessing a web page but storing data locally (http://www.go4expert.com/forums/accessing-web-page-storing-data-locally-t24175/)

BerbBrown 14Dec2010 16:35

Accessing a web page but storing data locally
 
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

shabbir 14Dec2010 16:55

Re: Accessing a web page but storing data locally
 
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 ...

BerbBrown 14Dec2010 17:02

Re: Accessing a web page but storing data locally
 
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?

shabbir 14Dec2010 19:41

Re: Accessing a web page but storing data locally
 
What you are talking about is not web based access but more like an application based access.

BerbBrown 14Dec2010 19:46

Re: Accessing a web page but storing data locally
 
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

shabbir 14Dec2010 21:47

Re: Accessing a web page but storing data locally
 
I think web based is fine because installing on 1000s of users PC is a whole lot a headache and updates are more headache.


All times are GMT +5.5. The time now is 21:27.