I have this code to upload .xls files to sql server and am wondering what I need to change in order to upload comma delimited .dat files.
Dim connString As String = ConfigurationManager.ConnectionStrings("xls").ConnectionString
'Declare Variables - Edit these based on your particular situation
Dim sSQLTable As String = "tempContainer"
Dim sExcelFileName As String
[code]....
Is it possible to upload .obj files ( 3D models ) to an sql server database?
View 1 Replies"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance nameis correct and that SQL Server
is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "This error display in myI do all type of changes in my sql server, which i find in google, but now my site can't display proper.
I have deployed my software on a server,In my software there is a tool which reads an excel file and displays the content in a gridView.
It's working fine on my stand-alone PC, how can I do it on the web?
Should I upload my excel files on server and then read it or directly read it from the user's PC?
i write a FileServer Project (For uploading Files and give them to users), it is webapplication, i want to upload files to another server ( i mean another computer), i have its address : (172.16.10.30), so what should i do?
View 7 Repliesi've got some problem reading excel files to store into sqlserver database. currently my code has a fileupload control and a button for me to save the excel file into a folder and read the data inside the excel file and write it into the sql database. The code works only if the excel sheet name is Sheet1.xlsx, however i tried upload a diff file named ImportUserFile.xlsx and it gave me the exception below. 'ImportUserFile$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. i have also tried other file names and it seemed only Sheet1.xlsx works.
[Code]....
Let me first describe the actual need first.
I have a java application runnning on my pda ( a Windows Mobile device). I want to upload a text file from my device to a server using gprs connection.Currently I have a jboss server, and a client application in VC++ that uses the Wininet api.This VC++ client application establishes the gprs connection and also uses the http method of wininet api for file uploading. I am having difficulty using the http post method for uploading files to the jboss server. I want to use Http "PUT" method at client side.
So I want to create a application at server( I want to use IIS now instead of jboss),that would accept the byte stream from my VC++ client application and create a file at a folder on the server.
I'm new in ASP.NET , I finished one website by ASP.NET with Visual basic (2008), It's contains 2 files (Default.aspx & Thanks.aspx). The Default.aspx is main page. Now I want to upload them on server. I already have space on one server.
I did publish web site then the Visual Created one folder is PrecompiledWeb contain other folder with the same project name inside it these files (App_LocalResources , bin ,images , Default , PrecompiledApp , Thanks and web) , I uploaded these files on the server in www folder. but it's is not working if I will enter in the web browser my website name. How I can config the website to work when I will enter my website name like this(www.xxxxx.com).
[Code]....
and i found it, here http://forums.asp.net/p/1480079/3451771.aspxi can fairly easily code for a general dbase (name, address, etc..)my question here with this code is...where does my dbase info go?
my dbase info
dbase name = files
tablename = fileTable
column names = fileOne, fileTwo, fileThree
the file upload object is called "fileupload1" and this all goes with a "submit" button
also, that is pretty much for one file, what if the user is uploading more than one file? do i just add more if/then statements, one for each fileupload object?
I m creating a website on an FTP server (My application is a webbased and I m developing it in ASP.NET ).I want to ask whether FTP will allow users to upload files from their systems to the FTP server? We can easily upload files using HTTP using UPLOAD control provided by Visual Studio.How can this be done if m using File Transfer Protocol? Is there any control in ASP.NET that can provide uploads to an FTP site?
View 3 RepliesI was just wondering what the best approach would be for uploading/downloading files. My users want to have the ability to upload and download emails to various Orders but i'm not sure of a few things.
Would I need a new table and reference it to my Orders table? Or would I need to create a new table and add columns such as file location, and upload the files to a particular server? Also since I am working on a Windows machine, i'm not really sure how to connect to my server to allow me to upload/download files (not sure if that makes sense).
I have an ASPX Page that contains a fileuploader, I want to know how can I upload multiple files together to server and also create a new folder on Server and then upload these files into this new folder!
View 4 RepliesI am using FCK Editor (version 2.6.3.22451) in my asp.net 3.5 application.
While using upload option in the insert image modal popup, is it possible to upload the file to an external server, e.g. outside my virtual directory (anyhow, for example using FTP credentials).
I am developing a intranet application in C#.
I am developing a application where files can be uploaded to staging area. and after saving to staging area a email confirmation is send.
After browzing for the file from local drive ,user gives a email id and click upload button ,then file should be saved to staging area. and then aconfirmation email should be sent to email id entered. we are using Exchange server to send emails.
i have an aspx page which has a fileuploader and a button
initially i have to browse the file and after browsing the file i have to check the extension if the extension is xsl or xslx then only i have to enable the submit button
once the submit button is enabled i have to insert this data into the table
and i have to display the number of succesfully inserted rows and no of unsuccessfull insertions .
success and failure is dependent on the mismatch of the datatype between the excel sheet and the database column
i am coding in c# but am unable to upload.
I have requirement that User can Upload the Excel Sheet Data to sql server Database at once.
View 16 RepliesI am working on document management system. finding guide / code for Storing and Retrieving doc/pdf/xls files in SQL Server 2005.
View 1 RepliesI have a requirement to upload large files using dotnet using ftp. Any opensource programs available?
View 5 RepliesIs there any control out there that will allow a user to upload multiple files at a time to a web server?
View 3 Repliesi have some files, and i need to upload these files into sql server 2008 by using filestream. lets take table name as custfiles,columns are fileid,filename,filepath,filesize.
1.how to create table using filestream?
2.how to insert file (record) into table from .net environment?
3.how to retrive that file from .net environment?
I am working on an Entertainment Website, my client wants to save videos in the database, i am a bit aware of silverlight, that it can be done through microsoft's silverlight platform.
how to accomplish my goal, i am using ASP.Net with C# and LINQ and backend in MS-SQL Server 2008.
I have 15 .dtsx files that were edited in SQL Server 2008 BUi and I need to deploy them all to dev server that has SQL Server 2008?
How do I go about deploying all 15 at the same time?
I'd like to allow users to upload a .pdf file via the file upload control (if that's the best method), save the file to the db and then retrieve it so they can click on a link and open the .pdf they've uploaded. I've been looking for a tutorial on how to do this but keep running into methods of saving the file directly on the server in a directory, not in SQL server (using Linq and VB by the way)
View 4 Replieshow can we write a code for displaying a files and folders of server directory using Grid View in asp.net?
View 3 RepliesIm using a file uploader to upoad files to a folder used for upload.But the problem is this folder is a linux folder. I have made it a shared folder so that I can access from windows by samba. So, file transfer is successful when I'm using os but when I try to upload something from my websites uploader to this folder, this process is not successful. I have given all permissions to this folder.Don't know whats the problem.I have used both type of slashes for directory but still it is not successful.
View 4 Replies