I have been asked to create a VB.net application which will download files from an https website to a location on our internal network. The files to be selected for download will be held and maintained in an Oracle database table. I will also need to include some error handling and generate emails if any errors occur. This my first VB.net project and I'm struggling on how I should do this.
I appreicate this isn't a one post answer but my initial questions are,
1. This application is going to be an .exe because it's referenced via a Scheduled Task on our server. I have been told that I should start the code in the Form Load event, is this the correct way? I have no .NET experience so would be good if someone with experience could advise.
2. My first port of call is to get the information from the Oracle database in regards to what files to download. I have been browsing and can see various references to web.config. I don't want to hardcode the connection parameters into the VB.net code so would like to use this web.config. But as I'm trying to find out how to do this all that is referenced in articles is ASP.net and not VB.net. Is web.config applicable to VB.net? If so I am not sure how from the VB.net code you reference this web.config?
3. The final step is downloading files from the secure website (https:\\…). What's the best way to do this? I have been reading about Web Control Library but again I really don't know what I'm doing so some advice would be helpful.
I appreciate this isn't a quick answer but some initial advice\suggestions would set me off on the right path so at least I know what I need to look for to create this project.
I appreicate this isn't a one post answer but my initial questions are,
1. This application is going to be an .exe because it's referenced via a Scheduled Task on our server. I have been told that I should start the code in the Form Load event, is this the correct way? I have no .NET experience so would be good if someone with experience could advise.
2. My first port of call is to get the information from the Oracle database in regards to what files to download. I have been browsing and can see various references to web.config. I don't want to hardcode the connection parameters into the VB.net code so would like to use this web.config. But as I'm trying to find out how to do this all that is referenced in articles is ASP.net and not VB.net. Is web.config applicable to VB.net? If so I am not sure how from the VB.net code you reference this web.config?
3. The final step is downloading files from the secure website (https:\\…). What's the best way to do this? I have been reading about Web Control Library but again I really don't know what I'm doing so some advice would be helpful.
I appreciate this isn't a quick answer but some initial advice\suggestions would set me off on the right path so at least I know what I need to look for to create this project.
