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 have a File Uploader in my ASP.NET application Using C#, we can upload any type like images, documents, pdf etc.
I m storing it in the Filesystem and having only the Name of the File in DB.My doubt is can we store the entire file, images in DB. State me Which is good practice and why we need to use it.
Either file System Storage or SQL DB Storage.
I 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 RepliesActually i am trying to storing the uploaded file into database but when i run this codes:
[Code]....
I got this error: " Incorrect syntax near the keyword 'File'.Incorrect syntax near the keyword 'File'. " can anybody tell me why this error came out?I tried toi change my connection string in web config,but it still showing the same error each time i run it in my local.
When inserting a binary file do you know what will be the correct content type for extensions like .txt or .gif or others not in your sample? Is there a list of correct content types?
View 1 Repliesi want to read the pdf file uploaded by the user and to display the content of the pdf file in asp.net webpage...(not the pdf file itself ).
View 3 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'd like to get both C# and VB.NET sugestion.
I have an ASP.NET FileUpload control, which allows only image type. I used RegularExpressionValidator like below.
<asp:FileUpload ID="fuPhoto" runat="server" TabIndex="40" />
<asp:RegularExpressionValidator ID="RegularExpressionValidator3"
runat="server" ControlToValidate="fuPhoto" Display="Dynamic"
ErrorMessage="* You can only upload .jpg, .gif or .png image types."
ValidationExpression="^.*.(jpg|JPG|jpeg|JPEG|gif|GIF|png|PNG)$">* You can only upload .jpg, .gif or .png image types.</asp:RegularExpressionValidator>
This method will only verify the file's extension, not its actual type. Once I receive the file, I want to examine its contents to determine what it really is, in this case image only.
How do I examine the file content being uploaded?
I have a simple upload page using the html file element. I choose a .pdf file to upload and when I inspect the Content type of the file when it goes to server the value is "application/msword" instead of "application/pdf"
View 1 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 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
I am fetching data from .xls file and storing it in to database. Then my users work on a single table where I stored all .xls data. But the problem is that it takes tooooo much time.. So, I want to use cache. But I never used this... Can any one tell me this example how can I use cache with database for increasing application speed?
View 2 RepliesI want to store Date as well as time in a label. The code that i am writing is Label1.Text = Datetime.Now.ToString();
I want to save this value in to the database. This is what i am writing
com.Parameters.Add ("@Dt ", SqlDbType.datetime).Value = label1.Text; // this is the problem.
In my application I've allowed users to upload Excel 2003 .xls files, and import them into a Gridview. This has been working fine using the following connection string:
[Code]....
Now my users are using Excel 2003, 2007 or 2010, I need to allow the newer file extensions (.XLSX) to be accessible too.
Therefore, within the connection string above I presume I could change the Excel version from 8.0 to 9.0 or 10.0 respectively, but is there much difference between Excel 2007 and Excel 2010 files?
If so, is it possible to 'detect' the Excel file version so that I can use the appropriate connection string to read the data from the files?
I'm having a bit of an issue uploading files to a database. I'll post snippets of my code below.
The table i'm uploading to has the following structure:
[Code]....
I can upload the file using my MVC application without any errors, however in the database the file stores in CoverFileContent as "0x0000000000000000......". All the other information relating to the file, e.g. MimeType, FileName, CoverID, etc uploads correctly. I took a wild guess that this wasn't correct so I downloaded the file (created a .net MVC file downloader). It seemed to download as the correct type of file, however I when I tried to open it, it told me I could not open it. I'll post some snippets of my code so people can see what I'm doing.
CoverController
[Code]....
CreateCover.aspx
[Code]....
I have inserted breakpoints to debug the code, however coming from more of a business background I'm not sure what I'm supposed to be looking for. It seems that the array is being populated with 00000000s so I'm thinking this is a problem regarding the intake of the file.
[URL] This is the tutorial I was originally following, which I got to work perfectly. However when I rewrote it to suit my own needs (using ado.net, etc) this problem seemed to occur.
i used your application multiple file upload like gmail that is fantastic.but what i want when it's uploaded in the folder it should show in gridview with file name just like gmail.
View 1 RepliesWEB FRAMEWORK: ASP.NET in C#
I've looked all over the web for something that would show me how to do this but can't find it. I have a page that uploads information about an individual including a resume in the form of a doc docx or pdf. I can upload the file okay but I do not know how to, on another page, To download the file that was loaded to that person's row in the database. Here is the upload code
[code]....
I have a website that occasionally needs to have a handful of the tables in its database updated. The updates come from another system that exports to comma delimited text files. I can then either FTP the text files to the web server, send them in through an admin upload page, or manually log in to Remote Desktop to download the text files. I have all my C# code written to parse the files, check the database contents, and decide what to do.
Should I code the sync logic to be part of a file upload page, protected in the admin section of the site or should I create a Windows Service that constantly looks for files to process in a particular directory that I can drop files in through FTP?
I have used Windows Services in the past and they have worked great, but if I ever have to make a change to the code it can take longer than it would if I just had to modify an ASPX.
Are their security benefits one way or another?
Performance benefits?
ASPX page wins the "ease of maintenance" category.
i m having 4 radio buttons on default2.aspx page on the same page i m using a database it's columns are uname and status whenever the user clicks on the radiobutton the status of that name should increment by 1(counter variable).
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
[code]....
i want to upload multiple files through file upload or file control at the same time i want to privew that file and also its size and description, only one click on browse file these above tasks must performed, and i can upload multiple files type like pdf,doc,zip and in last i want to store those all files in database binary or any any other data type which is reliable for storing such data. can any one tel me that how can i do this.
View 2 Replieshow can i store image into database and view it in grid view?
View 3 RepliesI am writing an application in which a remote url web site ( says url1 that is sender) sends xml data to another web site (says url2 that is receiver) by using .NET WebRequest. On the receiver url2 if I use .NET Page.Response and .NET Page.Request to store posted/received xml data into an external text file, then the data is stored. However, if I store the received data into database, I do not see the data is stored into the database.
trouble shoot the codes so I can store such remotely posted data into database on the receiver side url2.
I host both url1 site and url2 site in my computer using IIS like [URL]
1/ Receiver page's codes that store remotely posted xml data into database do not work:
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.ContentType = "text/xml";
StreamReader reader = new StreamReader(Page.Request.InputStream);
String xmlData= reader.ReadToEnd();
ProductNameSapce.ProductCollection.InsertReceivedProduct(xmlData).ToString(); // data is not stored ; the method is tested and works well with hard-coded data
reader.Close();
Page.Response.End();
}
2/ The version of the receiver page at url2 that stores into an external text file works:
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.ContentType = "text/xml";
StreamReader reader = new StreamReader ( Page.Request.InputStream );
String xmlData= reader.ReadToEnd ();
StreamWriter s;
s= File.CreateText ( Server.MapPath(".")+@""+ Guid.NewGuid () + ".txt" );
s.WriteLine ( xmlData); // data is stored in an external text file
s.Close ();
reader.Close();
Page.Response.End();
}
Friends have quick question for you.i want to know storing videos and images into database(binary data) or local hard drive is efficent. What way general websites stores them in their websites.
View 6 RepliesI am using C# and VS 2008 with access database. I have a nested gridview (2) with two access database tables. Date1 (takes System date) is the primary key in table1 and also present in table2 as foreign key. User data is stored in gridview 2 w.r.t to the date in gridview1. What i am tryin to do is to mail todays date (System date) data of Gridview 1 and data corresponding to it in Gridview 2 to a specific mail id.
View 8 RepliesHow to get the full path of the file that is selected using the fileuploader.
View 1 Replies