DataSource Controls :: Save Uploaded File Path In Database
Apr 26, 2010how can we save the uploaded file path in to database and then retrieve it in gridview as a link so when user click on that it will open that file in browser.
View 8 Replieshow can we save the uploaded file path in to database and then retrieve it in gridview as a link so when user click on that it will open that file in browser.
View 8 RepliesI am running Windows Server 2008 Datacenter, ASP.NET 4, IIS 7 and getting the error :Access to the path <path> is denied when using the FileUpload control to save the uploaded file to this directory.I have given the directory in question full access to Network Service but that makes no difference.I have even given the directory full access to Everyone but it still gives the same error.Totally baffled by it
View 1 RepliesI want example upload pdf file and send name, title, filename, filepath to database and retrieve and display pdf from Upload Folder...
View 1 RepliesI have 1 fileupload control that I can upload file from it below is code :
int count = 0;
if (this.fuppdf.HasFile && !string.IsNullOrEmpty(this.txtarticle.Text))
{
string[] validext = { ".pdf" };
//string ext = System.IO.Path.GetExtension(fuppdf.PostedFile.FileName);
string ext = Path.GetExtension(fuppdf.PostedFile.FileName);
[code].....
and with below code I want save filename (uploaded filename) in database
SqlCommand _cmd = new SqlCommand("Fileuppdf", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
string data = Session["behcode"].ToString();
_cn.Open();
_cmd.Parameters.AddWithValue("@pdf", filename);
_cmd.Parameters.AddWithValue("@Behcode", data);
_cmd.Parameters.AddWithValue("@id", Convert.ToInt32(ViewState["Id"]));
but it make error in this line
_cmd.Parameters.AddWithValue("@pdf", filename);
error===>("The name 'filename' doesn't exist in the current context")
I know that I define filename in
foreach (string s in files)but I don't know how I can save it name in database
How To Save Video files into folder and save path only into database in asp.net using c#.
View 1 RepliesI want to save three images path in table also upload images in folder,how it is possible?[Using ajax file upload control]table columns are imagepath1,imagepath2,imagepath3. URL....
HTML
<asp:AjaxFileUpload ID="AjaxFileUpload1" runat="server" AllowedFileTypes="jpg,jpeg,png,gif"
MaximumNumberOfFiles="3" OnUploadComplete="File_Upload"
Width="500px" />
C#
protected void File_Upload(object sender, AjaxFileUploadEventArgs e)
[code]....
how i can save a file into my mysql database..
i want to save a file into database not the path..
i want to save one excel file in sql database in some column and same i want to retrive . for this i am using file upload control to upload a file.
i did follwoing
i defined one column in sql for storing the file with datatype. image
when i am inserting a document in this column "<Binary data>" this value is showing.
and when i trying to retrive this file.In the file "System.Byte[]" text is coming in a cell.
I am storing excel file in database
code to insert a Excel file in database:
Int32 File1Length = this.FileUpload1.PostedFile.ContentLength;
String File1Type = this.FileUpload1.PostedFile.ContentType;
Stream File1Stream;
File1Stream = this.FileUpload1.PostedFile.InputStream;
[Code]....
How to get the full path of the file that is selected using the fileuploader.
View 1 RepliesI 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.
View 2 RepliesI created a virtual directory in the Visual Web Developer, according to this post:
[URL]
I want the user to upload / download documents in the mvc app to that virtual directory. When a document is uploaded, I'm specifying the path to the document to be stored for later retrieval like so:
~/VirtualDirectoryName/FileContent.docx. But when I try to open that as a link in th app,using ResolveUrl, it appends the port number after localhost like so,[URL], I get a document not found, since it really should be, [URL].
i hv postback event executing after i am trying to upload a file to server to ask for conformation by the user. after postback fileupload control gets cleared and i am not able to get its value after postback. controls viewstateEnabled property is true. How do i assign a file path to fileupload control after postback.
View 2 Repliesin my new c#.net 3.5 ASP Website, user have the possibility to upload a picture.What solution is the best for saving this picture? Should I save it on my server in a folder and save the path in the database, or should I save the picture in the database?
View 3 RepliesI have a Document name column with varbinary(max) type column in my table
first time when i upload document i am storing doc as a byte array
Dim fs As Stream = Me.fileupload1.PostedFile.InputStream
Dim br As New BinaryReader(fs)
Dim bytes As Byte() = br.ReadBytes(fs.Length)
in my application i have remove atttachmentDoc button, i want to remove uploaded doc from db
so when i pass like this to my storedprocedue
Dim obj As New cls1
Dim bData() As Byte = New Byte(0) {}
bData=nothing
With obj
Dim dt As DataTable = Read_Doc()
If dt.Rows.Count > 0 Then
If Not IsDBNull(dt.Rows(0)("Document")) Then
.Document = bData
.Document_extension = ""
.Remove_Attachment(Me.Selected_ID)
End If
End If
End With
i got error
dbAccess.executeQuery: Procedure or function 'SP_DML1' expects parameter '@Document', which was not supplied.
I am working on the application that allows user to upload a file (from their local machine) and store the uploaded file in database.Then,the content of the file (such as ContentType,FileSize etc)can be view in a DetailsView control.
View 1 RepliesI am a new-bie in Asp.Net.I am working in a project where I need to store an attachment which will be uploaded by the user in radGrid into Sql server 2005 database.After storing this attachment, I have to retrieve this attcahment and show the same to the other users in radGrid so that they will be able to download the attachment and see that.How should I do that?what kind of datatype would it be?
View 2 RepliesI have a file uploader I would like to be able to have a folder added to the folder path on upload based on a textbox.text "MapPath("~/Uploads/" + Path.GetFileName(e.filename))"
I have Dim folder as String = textbox.text how do I add folder to MapPath("~/Uploads/"
it currently checks for .xml files how can I add more .doc .gif etc
Dim savePath As String = MapPath("~/Uploads/" + Path.GetFileName(e.filename)) 'Validation for file extension If Path.GetExtension(e.filename).Contains(".xml") Then Return End If
What is the best way to insert and retrieve images like :
In the database in binary form retrieve it with imagehandler, or
In the database by saving the path of the folder of the images and retrieve it, or
by saving the images directly to the folder and retrieve it...
i am using a sample code to save the data from the text boxes to a text file and i am saving it in to a directory. This one i hard coded to save the text file. Now i need to save it in a particular directory that user sets. Like i will opt him an option like preferences in menu there he can set a path to save his file and i would like to save the files in that path he created. And also if he changes the directory i would like to move all the files to that drive he opted. [URL]
View 5 RepliesI am following this article [URL]
The code from the article is:
[Code]....
After commenting the lines in bold..I can upload word files too...The article also has
GenerateBrochureLink method...which generates link..but when i click the link to download my word file.i get some zip file...with xml.
How can i download the word file which i have uploaded with the view brochure link in gridview.
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?
Here is what I am basically trying to accomplish I want to upload images to the server separated into categories and save the file path into the database. I have found plenty of documentation on saving to a file and the file path to a database. But, I haven't found anything that will allow me to seperate the images into categoies.
I have made three tables in the database
[code]....
What I am trying to do is create a gallery for our clients to browse and download different vesions of posters and ad cards.
I have a DB in which I store Video File Path. Now I want to show that video on my ASP page. especially demo with FlowPlayer.
View 1 Repliesi'm new to programming and i'm doing a project of ana e-store, i have a data gridview that brings data from a data base and it have to more templeate files one a textbox and the other one is a label. and i have a button outside the grivdview. what i need that when i press on this button it will take the values from the grid view and insert them into a new sql table.
[Code]....
and here is the VB code that i'm trying to use with no luck : [Code]....
how can i save text introduced in textboxes to a database in visual studio 2010? Data base is managed with sql management studio 2008..
View 3 Replies