Architecture :: How To Upload Data To Sql Server 2005 From Client PC
Mar 22, 2010
The Dumps data are in the Excel file. Now I want o upload the data to sql server 2005(which are in web server) from client pc (from browser). What will be the best way to do so?
I can know how to upload data from excel to sql server 2005 if both are in the same computer.
I'm going to create my own project, and i have some difficulties with technology selection. I will have client application(windows forms) and web service. Data exchange between clients will be only by using this web service. Data will be like image stream,so I don't know which technology to use. I started to look at WCF, but i don't know a lot about it.
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..?
Works a charm locally but as soon as i upload this to the live server (hosted by heart internet) i get:
Code:
Server Error in '/' Application.
Specified argument was out of the range of valid values.
Parameter name: i
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.
I am using Visual Studio 2008 and SQL Server 2005 as my back-end.I saw this topic is already introduced in StackOverflow but I have different question related to this topic.I just want to directly get the file from my server/hard-disk and save it in the database.
I want to send a file from MY LOCAL MACHINE (a pdf file) to a server running the web application. (to a pre-determined path on that server). Example .. the web application is a shopping cart. Customers can UPLOAD a pdf of their tax exempt status so it is on file at the servicing end. Will the VS control FileUpload accomplish this. I have seen where you can push a document from the SERVER to the client ... but not from the remote webuser client back to the servicing webserver application.
I have a webservice(Framework 3.5/VS 2008) that assembles data from 3 other webservices and puts it into SQL Server 2005. The data from these webservices is mutually exclusive. What is the recommended architecture for the same?
Basically I have to generate a rather large XPS document serverside and send this back to the client.
The issue I have whilst trying to do this is because the XPS document needs to be created on a STA thread, so either the response is sent back before the async operation is complete (in which case I can't attach the file using the transferfile method) OR I have to wait until the Async thread has completed and then I can send the file using the transferfile method (but this leaves the current page locked out for quite a while).
i am trying to create an aspx page where i can directly upload a file from the client to the server without user intervention. I would like to do something like when the user specifies the file path in the url, that particular file must be uploaded to the server.
The user can change the value after upload and what ever file he is specifying, it will be needed to be uploaded onto the server which is located at xxx.xxx.xxx.xxx
my sample code is:
[Code]....
this is just a trial to check if the csv file is being created on the server or not, and it is not being created.
i just want to copy the file on the client side to the server side and it has to be only by the aspx page in the format specified above.
What is Web services? What is Web services? How can I Transfer the data from server to client and client to server using XML. Need one simple Example program(C# web Application) ...
I used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
I have a async file upload control and I am doing client side validation for Image."OnClientuploadstarted" I am doing the client side validation.My validation is working fine but my problem is that the file upload control text box goes green (i.e file is loaded on the server) even if the validation fails which is I dont want.What I want is when the client side validation fails the file does not gets loaded on the server and the Async file upload textbox does not goes green.I have goggled but have not found a suitable solution.
i had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql
I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
I am looking for a way to integrate a web application with a client application that will sit on the users desktop. Our scenario looks like this user will click a link in the client server application that will launch an .ASPX and pass various parameters via a querystring. User will make form inputs on ASPX page and on that input, I need to be able to execute a .EXE on the client machine that will refresh the window in the client server application.
I have looked at some tutorials for using ActiveX for this, but they all seem out of date and the ones that I have been able run prompt the user with the Activex warning dialog, which I would like to avoid.
I have a scenario which I am looking at where large files which are about 30-40 MB are being FTPed to a server. I am looking at creating a .net screen with the FTP control to upload the file to a Unix server. I need to know how much of a performance hit it is to work with such large files, is it a feasible option in this scenario? I might have to create a .net component for the same and call from ASP application. Is it doable?
We need the a solution for our ASP.NET website. in which a user needs to activate his machine and next time if he visits the site then we need to check the machine is activated or not. if the machine is activated then we want to redirect the user on different page.
Is there any way by which we can get the client machine MAC address and store it our database?
I have found some solution in which this can be done but it works on on IE and some ActiveX setting needs to be done.We want this should work on atleast IE and FireFox.
The user can write articles and upload images related to that article. Let's say that there is a form that collect the article text and, under it, there is a FileUpload control for images. Here, I have a question. What if the user has uploaded some images and then he closed the browser, before submitting, cancelling the operation? the images have been uploaded to the server wasting space!
one solution I've figured out is to store "ImageInfo"s in a list, and store the list in the Session object. And when the user submit the article, the images in the list should be marked as "related" and then inserted. and in the Session_End event I should delete every image does not have the "related" mark.
I have an asp.net application running on a web farm that allows users to upload files and download them later via link to that file. Currently, I use Windows DFS to replicate the local IIS directory where the files are stored across the web farm servers. However, as this solution does not scale out, I want to implement a more scalable solution by partitioning the documents. Specifically, say I set up multiple file storage servers (Fs1, Fs2, Fs3, etc.) on the network. Further, let's say I change my upload page to save the uploaded file to one of the file storage servers on the local LAN (based on some logic). I assume so far I am safe with ASP.NET doing this much assuming I have the correct permission for the ASP.NET process ID. The question I have is withregards to download links. When a user gets served a download link to their document (e.g. http://www.testco.com/data/doc1.txt) is there a way for me to "intercept" that HTTP request and underneath the coversserve the doc1.txt from the file storage server (e.g. Fs2) it resides