Architecture :: Download New Data From Remote To Local?
Apr 18, 2010
I have an off-line project. User uses a laptop to input data off line into local SQL server express. Once connected to domain (on line), local data will sync with remote SQL server using sync framework. (It is done, works fine)
One job left:
Since another user used another program to update some tables in remote SQL server, such as CUSTOMER, SHIPINFO, my off-line program need to update these new data once connect to domain.
Here is what I design in Pseudo code: (take CUSTOMER as example)
1) In remote SQL server, create a store procedure (sp_customer) to select all CUSTOMERS
2) In application, create a dataset (dst_customer) based on sp_customer
3) Insert all customers data which is in remote SQL server but not in local SQL server based on CUSTOMER_ID
We need to download multiple files from remote servers. It is a process that would take few hours to complete, since we are talking about images ~50kb each and more than 250.000 in total. Each images will downloaded, resized and then imported to SQL.DB, so we do not need to write files to the disk. Also the applications need to use network credentials, since it is behind ISA.
From your experience, what is the best method to implement this? Should we use WebClient or HttpSockets? Should we use Async methods or Threads ? How can we implement for example 5 simultaneously download to achieve better speed, since we may getting files from many different servers at once?
how to download a file , from sql server 2005 to local disk.
using asp.net and c# as my code behind, when i click on gridview column, a pop up windows should appear asking fr the path to save in local disk, when name is entered and save button is clicked, that particular file should get saved in disk.
I'm developing an ASP.NET Website locally using Web Developer Express Edition and publish my site via ftp to the remote host. Problem: Locally I'm using path settings to xml files etc. different from the remote paths. So each time before I publish my site I have to set the remote paths explicitely commenting out the specific lines of code.
can anyone point me to some differences hosting a website on some remote server VS running it locally on dev environment.The reason why i am asking is, If I run my website locally it works fine no exceptions, runs smooth. But when deployed on a remote hosting server. Its like a nightmare to me :(very often i get object Instance not set to instance of object..... I am ok with the error message, But the same situation should happen locally, thats what bothering me:D
So, I've been working on an app that extracts a picture from an ole field in an old access xp db, converts it to a jpg picture, and saves it to a folder to be presented to the user.
After tweaking some permissions on the local iis, the application works fine.
In the remote one however, the application doesn't extract the picture as expected.
I'm using two dlls on there, although I don't know why it wouldn't work.
I'm trying to download remote file using C# (ASP.NET). The problem is when I browse to the file download URL - it downloads perfectly. When I try the WebClient.DownloadData(url) I get "no data to show" response.
If I browse using the built-in VS2010 browser I still get this "error" message.
I am developing a website with ASP.NET pages that uses an SQL Server database with LINQ to SQL. I am using Visual Studio's Web Developer along with SQL Server 2008 (Developer Edition) database tables on my personal PC to develop this software. When ready, I intend to transfer the compiled web pages to a web hosting service with an SQL server database that is identical to the database on my PC.
I now have a version of my website deployed on a web hosting service at: [URL] and all of my database tables duplicated at the remote SQL server. However, this version of my website does not work with the database yet. I realize that I can have the VS Server Explorer connect to both databases, but I do not know if the web pages on my PC can use both databases interactively.
I am asking how I can develop my website to use the local SQL Server database and then have the deployed pages use the remote SQL Server database with LINQ to SQL. Do I need to create one version that works with the local database and another deployable version that works with the remote database? What should I do?
I'm just wondering what the best practice is for managing web.config connection strings and SMTP settings when working locally in VS2008 and deploying to a remote server?
I am not sure which approach I should use. I have a web application that needs to get/receive data from a third party application that is in a secure remote network. The data needs to be secure during transport. The data layers cannot be exposed and the databases will not talk to each other. The data will be received from remote application on demand, or will get at scheduled intervals.
I have looked at WCF, but not sure if this will work. Can a WCF service be used to receive data as needed from a remote sender or service? Is this a secure way of doing it? I have also looked at SFTP using some XML/XSLT, but I don't think this is the right way to go. In addition, some data may be transported from my web application to the remote application (mostly reports at first). What protocols are used to transfer data between HIPAA compliant applications?
i want to download file from other website to on my location and i used code below
Dim wc As New System.Net.WebClient wc.DownloadFile(pathUrl, fileName)
PathUrl,fileName both are correct m 100% sure.
after execution of these 2 line my browser progress-bar goes in to wait state like something is retrieving.but file not download any where.what should i do next?
I want to populate members of a local computer group on a webpage and allow the user to add / remove users of that remote computer from a group say Administrators or Remote Users Group.
The application pool will be running with a user who is admin on all remove systems.
Is it possible to connect to a Remote Desktop from my ASP.net (I easily done it in .net windows application with a 4 line code and"Windows Terminal Service Control")application, If so can you guide me through it. Many thanks in advance.NB:I want to achieve it without using ActiveX control that work in IE, because with that every client would have to use IE and install the control.
Does anyone have links to good tutorial on how to programatically (using vb) connect to a remote site to download and save xml files to local server? Thank you very much. The remote site is using REST and queues but I do not think that should matter or?
how to create a Web service that returns a JSON(or JSONP). That also should be able to work for cross-domain access aswell as for a local call.. help to get this working or for a few links for further reading about this
I've made a small web site (MVC2, VS 2010) with some image gallery functionality. When testing locally the images download very very slowly, as if I had dial up internet connection. For example if I try http://my_local_website/myimage.jpg it will be slow. However, if I try (via web browser) C:mywebsite_foldermyimage.jpg it will load instantly.Not sure if this is an issue of my local IIS7 or what, but I would like to fix it before going live.
i want my application to provide a web ui for remote access, but i do not host that web page in IIS, because i do not want everyone install IIS on their home PC.
i spend some reading the asp.net pipeline, but still not figure how to load the .aspx file in my code.
On remote server i have shared folder. If there any way to download file from this shared folder on local machine? Without using ftp. Server dont have iis or something like this,just have shared folder.
downloading latest Zip file from a FTP location and UnZIP it by saving to a particular location using VB.NET GipStream or some other method. I prefer not to use any 3rd party controls.
