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?
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.
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..?
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#
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.
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.
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.
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.
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.
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:
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?
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
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?
