Automatic Upload Of Data To A Webserver Database?

Feb 4, 2010

I have a question what's the best way to accomplish the following task:

- I have an ASP.NET application with SQL server database (hosted externally at any provider)

- There are a few dedicated client computers anywhere in the world and these client computers shall run a periodic automatic process to upload some data into the database of the webserver. So there is NO user in front of those computers to open a browser and run any kind of upload manually. (These automatic processes are not part of my question, they can be windows services or simply running applications on the desktop.)

My initial idea was to use FTP for this purpose, means: Those perodic processes on the specific clients create files and put these files via FTP in any defined folder of the web server.

But what follows then? Is it possible to have any eternally running process on the web server to process those uploaded files in the FTP folder and write their content into the database? As far as I understood until now an ASP.NET application has sessions and an application process but a session shuts down as soon as the associated client doesn't send a request for some time and even the application process shuts down when no user at all sends a request for a specific time. Isn't it? So in other words: When no user sends any requests via HTTP my application on the webserver is simply not running and therefore cannot process the FTP-uploaded files. (Or can I keep the application "artificially" alive to run a peridic lookup for new files ???)

The other option I had in mind is to program a piece of software running as a windows service which could pick up the FTP-uploaded files and process them. But I have to consider that possibly the hosting company does not allow to install any service programs on their servers aside from the ASP.NET application. So this is probably not a real option.

And now my third idea is to develop an ASP.NET web service which runs on the same web server as the ASP.NET application. The specific clients mentioned above would connect to this web service via HTTP, upload the data and the web service would immediately process the data and write them into the database.

At the moment only the last option seems to be the "most natural" (and perhaps even the only possible ?) way to me. Are there any other options and methods for my purpose? And if so, what is the recommended way?

View 6 Replies


Similar Messages:

How To Upload The MySql Database To WebServer

Feb 24, 2010

I am developing a webapplication in ASP.NET 2.0 and MySQL 5.0 Now I want to upload this application to My WebServer (The windows web hosting space which I have purchased).

But I am not much familiar with MySQL, and I Don't Know how can I Upload the database on web server. This database contains approx 14 Tables and 95 Stored procedures. Recently I have developed some small web applications in asp.net with access database, at that time uploading was simple(just upload the access file to App_Data folder) But I don't know how i can do this with MySQL.

View 1 Replies

Upload Image / Photo From Iphone To Webserver?

May 29, 2010

How do I upload Image/Photo from my Iphone to webserver. At web server I am using ASP.net c#.

On Iphone i have image displayed on UIImage Control and that image I am getting from database from BLOB datatype column.

how do I save that image bytes to application folder and then send image file to webserver.

View 1 Replies

Architecture :: File Upload To DB Server From Webserver

Dec 2, 2010

I have this scenario. I have an application running in a webserver (in DMZ). End users upload documents to the webserver. right now all the documents get stored in the webserver itself. I would like to store all the docs in the database server.

What is the best way to store the documents, move it from webserver to db server after they uplocaded or directly upload to the db server ?.

And, if I have to upload directly to the db server could someone help me how to mangae the connection to the db server and credentials..?

View 3 Replies

Configuration :: Adding A User To Upload VWD Projects To My Webserver

Jul 28, 2010

I need to be able to create and manage users and what sites they can access in IIS. For instance, I dont want user A touching user B's site.

I do not want to enable users to log in to the webserver via remote desktop.

View 5 Replies

Web Forms :: Automatic Insert Data To Database Only On Particular Time Not In Pageload

Sep 17, 2010

Actually i need to transfer data from one table to another table in mysql with codition of Time.for example i need to transfer data at 10.00am when user login at 10.00am it must be insert into another data table.. if anybody know time control
please reply me..C#

View 2 Replies

How To Automate Database Updates At Webserver

Mar 30, 2010

I am developing the online bidding system using asp.net where I need to close the auction if the auction time is get closed without any bid.

As in the following web site :
{URL}Please help me to resolve to this problem.

View 1 Replies

Automate Database Updates At Webserver?

Mar 30, 2010

I am developing the online bidding system using asp.net where I need to close the auction if the auction time is get closed without any bid.

As in the following web site : [URL]

View 1 Replies

Web Forms :: Automatic Read Excel File From Folder And Store In To Database

Mar 19, 2010

i dont know iam placing my query correct place or not but i need ur's help, Iam Reading and storing one single excel file Successfully But

tring Path = @"E:checkinkkk.xls";

View 5 Replies

Forms Data Controls :: File Upload To Database

Oct 25, 2010

I'm using a DetailsView control and have a FileUpload control in a TemplateField for uploading images to a database. However, I'm not sure how to take the image name e.g. Button.png as a value and enter it into the database.

View 7 Replies

Forms Data Controls :: Image Resize And Upload To Database?

Feb 4, 2011

I need to resize a photo selected by a user with a fileUpload control and upload to a database. What i can just do now is upload the image to a database table. Imjust trying to find out how to code the image resizing part and when i say resize, i mean the dimensions and file size.

This is my current code to upload to the database

[Code]....

View 3 Replies

Databases :: Project Using Vb.net With Sql And Sql.Data.dll As A Link To The Database Not Working After Upload?

Feb 13, 2010

I have a project using vb.net with mySql and mySql.Data.dll as a link to the database. Now when I test my website from local computer and with live server connection string all works fine. The thing is, when I upload my files to the server, it gives me an error Object reference not set to an instance of an object.I have copied the mySql.data.dll file to the bin folder of my domain and the query that gives the error is a basic insert statement that works from the local machine to the live database.

View 1 Replies

Forms Data Controls :: Upload Multiple Images Into A Database?

Dec 26, 2010

would like to know how to upload 6 images along with address, name and etc. into a database using a formview in ASP.Net using vb

View 3 Replies

Data Controls :: Upload OBJ Files (3D Models) To SQL Server Database?

May 7, 2015

Is it possible to upload .obj files ( 3D models ) to an sql server database?

View 1 Replies

Forms Data Controls :: How To Upload Images In To A Folder In Project And Save The URL In The Database

Jul 31, 2010

I want to upload images in to a folder in my project and save the URL in the database.

When you add a record into my database you provide title, date added and some other details and there it a file upload control which you browser to a image and it saves the image to a folder in my project, it all works, the record is added and the image is uploaded into the folder, but the problem I have is that there is no link from the record to the image, there is no URL path saved in the record. How do I save the image in the folder and save the URL of the image to the record?

I'm using details view to insert the records and using grid view to view the records.

View 10 Replies

DataSource Controls :: Inserting Excel Data Via File Upload Into Sql Server Database?

Apr 28, 2010

I have requirement that User can Upload the Excel Sheet Data to sql server Database at once.

View 16 Replies

Web Forms :: How To Upload File And Save It To Oracle Database And View The Upload File Using C#

Feb 8, 2011

how to upload and save files to oracle database, and view file using C# .net and can upload one or more files in one webform.

View 1 Replies

C# - How To Fetch Data From A Webserver Every Few Minutes

Jan 21, 2011

I need to fetch CSV file from a webserver every few minutes.

Here's what I am planning to do:

I will create a webservice "GetCSV.asmx" which will get CSV file from that webserver.

I will create another webservice "RegularCall.asmx" which will call "GetCSV.asmx" every few minutes.

Is my approach correct? Is there a better way of doing this?

I am using ASP.NET web application and JSON webservice for this.

NOTE: There will be NO user intervention and the solution I am looking for is similar to scheduling a task on the server.

View 3 Replies

Forms Data Controls :: Image Upload In Gridview - Save Multiple Record Into Database

Feb 18, 2010

I have another problem is that I have Placed a file upload control in Empty template of Gridview to have multiple record insert. I have used viewstate to save multiple record into database. But problem is that I am able to find the control but it not giving any value.I have following code.

[Code]....

in above code

[Code]....

View 2 Replies

Forms Data Controls :: Upload Book - Document And File That Must Be Stored In A Database Table

Nov 25, 2010

I need to upload book , document and file, that must be stored in a database table. For this I need code.

View 3 Replies

Forms Data Controls :: Upload Image To Database - Couldn't Find File Path

Sep 8, 2010

I'm trying to display images in a GridView (yes, still this...). [edit] Before I can come to that I have to upload some images to the database.

I've followed this tutorial for the "upload image to database" code (this worked fine for uploading images, but I don't know if the images were converted to byte):

[URL]

and I've followed this tutorial for the "display images in gridview" code (and "retrieve file" from the tutorial below).

[URL]

It doesn't quite work, the GridView shows but without images

Now I'm trying to change the "save file" code according to this tutorial:

[URL]

but I don't understand everything in it. When I try to upload an image I get an error on this line:

[Code]....

View 40 Replies

SQL Server :: Data Migration For Automatic Emails ?

Oct 22, 2010

We will be migrating SQL Server from 2000 to 2005 in near future,we have created the Jobs for automatic emails in sql server 2000.important points regarding data migration with jobs?

View 3 Replies

Databases :: Automatic Insert Data To Mysql Table?

Sep 3, 2010

Actually i need to transfer data from one table to another table in mysql with codition of Time.for example i need to transfer data at 10.00am when user login at 10.00am it must be insert into another data table.. if anybody know time control

View 2 Replies

C# - Enable Automatic Sorting Of IEnumerable Data In GridView?

Mar 31, 2010

How can I enable automatic sorting of my BLL which returns a list, CustomerList:List in a GridView? Customer is my own strongly typed class and CustomerList is a List of customers.I know one approach is to set the AllowSorting property to true in the GridView and handle the OnSorting event and calling a sorting method defined in my CustomerList class.

However I would like a solution which is automatic in the sense that I do not have to handle the OnSorting Event, it should be like how GridView handles automatic sorting for DataView, DataTable, and DataSet.Is there an Interface I need to implement on my CustomerList or Customer class that will enable that functionality?

View 2 Replies

Forms Data Controls :: Accessing 'Window Control Library' .dll From A .aspx Page On Webserver

Oct 18, 2010

Accessing 'Window Control Library' .dll from a .aspx page on webserver

View 2 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved