Databases :: How To Construct An Excel File Connection String With Full Path
Jan 14, 2011
I am trying to write a page to read the Excel file provided by the user. I know I can't use the FileUpload to get the full path of the file from the client PC. This give me the problem when I write the connection string for the Excel file:
[Code]....
Without the full path, I can't replace the Data Source by a variable and I definitely can't assume all users will have their Excel files named Book1.xls located in C:Doc all the time.
I have an Async File Uploader control inside a Repeater which is inside an update panel. Now,I am uploading the file into ftp,so I am not uploading the video file,using SaveAs() method. For uploading the file in ftp,I have this UploadFile method which takes these four parameter:FileName, UploadPath, FTPUser, FTPPassword.Now this FileName,I have to send the full file path. My UploadComplete event looks like this:
<pre lang="cs">protected void AsyncVideoUpload_UploadedComplete(object sender, AjaxControlToolkit.AsyncFileUploadEventArgs e) {//VideoPath is a session variable VideoPath = string.Empty; if (AsyncVideoUpload.HasFile) { // string filepath = AsyncVideoUpload.PostedFile.FileName; string filepath = e.filename;//above two captures only the file name,but I want the total path,like c:/MyDocuments/... UploadFile(filepath, "ftp://172.20.117.102","test","Value*12"); VideoPath = AsyncVideoUpload.PostedFile.FileName; } }</pre>
I would like to use HTML input file type in my aspx page to allow user to browse for a excel file and then read the content of the excel sheet programmatically.If I want to read the excel sheet I need the full path of the file to connect to the excel sheet using asp.net.I do not understand how can I get the full path of the file.I know I can get the filename using postedFile.FileName property.But I need the full path of the file.
in my case. iam replacing some data in document and saving in client side. so itz automaticaly saving in thw client side(normally in the Temp folder). i want to get that full path from the client side.
I wrote some code to upload files to amazon S3, if I put a full file path manually It successfully uploads the file from my computer. What I'm trying to do is use a file upload control and store the full path in a variable so that I can use it for my amazon method. Ive read everywhere it seems that the browser won't let you get the full file path for security reasons.
How can I get the full file path? Should I just store the files on my webserver and point my amazon method to the server path, and then use the file upload control to tell it what the filename is?
I have a VS 2008 web application that I need to capture the full file path (directories and file name) from the selected file. So user selects a file and then clicks on one of the buttons which transfers control to my code for processing. So how do I get the file path? I can get the file name, but not the path.
I have a form where users can store some data for archived documents. All documents are ONLY in PDF format.
There are 2 things I would like to do:
1. there is a "file path" text box on the form. I would like to open a "browse file dialog" box when user clicks the textbox and then the user browses for the file (file is on the users local machine) and selects it. The full file path should be saved to the textbox as string (e.g. "c:archive2010document11122011.pdf"). Also I would like to "limit" the file browser dialog to only show PDF format files...
2. add a code behind command to open the file from the saved path+name (see 1.) in the user's default PDF viewer (Acrobat or Foxit)
I am trying to select one image file from desktop with file upload control. but i am not able to get the full path of the image if it is selected from desktop. i am getting full path if the file is selected from any other place but its showing error for the desktop.
am a newbie to programming so please bare with me!I introduced a file upload control on one of my pages. There is a button click event for the upload which triggers not only the upload but also an insert into a table in my database.Every aspect of the button click event for this upload is working as expected; however I do have a couple of queries because the results are not quite as I would like them. I am using asp.net 3.5 and C# in code behind page.
I have a simple table with 3 columns in my database: Username, PhotoTitle and PhotoUrl. In the button click event I grab the PhotoUrl like such -string photoUrl = FileUpload1.PostedFile.Filename; (I am using the photo url from my images folder in the application to show photos in Gridviews etc. I prefer this to storing the actual image in the database for the moment until i am a bit more experienced since i don't know much about varbinary dbtype.). When the button is clicked for the upload, the details of the photo are saved in the database table, but it's the full path of the file on my laptop which is store (C:/Documents/.../filename.jpg) opposed to "Filename.jpg" for example, which i obviously would prefer because in the application photos are displayed using the"~/images/Filename.jpg" path. How can I save the file name with the extension alone in my table (without the full path)?
The second problem is basically regarding the actual photos being uploaded. They are"saved as" inside folder for the solution as anticipated, but only on the laptop harddrive, which means that I have to manually drag each photo uploaded into the images folder within Solution Explorer, from a Windows Explorer window, in order to be able to display them in Gridviews etc (with the "~/images/Filename.jpg" call in the .aspx code). This is not acceptable of course since the site users would expect to see their photo after the upload, and they would not be able to drag the file into the ~/images/ folder. How can I get round this second slight problem; i.e. is there a way to upload photos directly in the folder so that they show directly on the solution explorer?I hope my explanations of those two little problems I have didn't confuse you all?
I have a query which gets values from two tables which are in different databases.How can I write a SINGLE Connection String which connects to two databases? By the way I am using SQL Server Database
I am connecting to Oracle database from .net using OLEDB.
My Connection string :
[Code]....
I am using above ConnectionString to communicate with database. To make it work, I have to store password (don't want to do that) in session and use it every time I need to talk to db.
1) Is there any other connection string without username and password with oledb?
2) I use "Integrated Security" for MSSQL. How can I use the same with OLEDB - Oracle database?
just for my testing purpose i know i can define both the connection's outside in a single web config file by different name's and access them in my front end according to it but what if i want to have seprate for both connection's web.config situation is like this see image so i want to access my connections from second web config file how i can do that.
But it shows me an errormessage when I run this query:
string query = "Select * from [IO_Definition$]";
IO_Definition is the name of the spreadsheet in my excel file. I also added the excel file to the App_Data folder of the website.
The error is:
The Microsoft Jet database engine could not find the object 'IO_Definition$'. Make sure the object exists and that you spell its name and the path name correctly.
The thing is, when I write the absolute path of the excel file in the connectionString it does work. Is there anyway I can make it work without writing the absolute path?
I only made 1 other dynamic page before, without users. I do remember I setup a read-only user to the database and that was the user used in the connection string, simple.
In managing multiple users, does asp.net's membership & roles automatically switch up the databases connection string upon login? Do you setup hypothetical "groups" of user access permissions in your database (mysql) then associate that user to that group in membership & roles?
I'm just looking for a general idea of what to expect before I start reading.
