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:
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
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
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
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
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
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
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
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
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
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
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
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
May 7, 2015
Is it possible to upload .obj files ( 3D models ) to an sql server database?
View 1 Replies
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
Apr 28, 2010
I have requirement that User can Upload the Excel Sheet Data to sql server Database at once.
View 16 Replies
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
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
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
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
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
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
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
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
Oct 18, 2010
Accessing 'Window Control Library' .dll from a .aspx page on webserver
View 2 Replies