My asp.net app has file upload capability, I need to store uploaded files (ie. .tar, .zip, .doc, tif .. etc) into a dataset before they being stored into mysql db..
How to store uploaded files into a dataset?
My SQL stored procedure returns 3 different datasets as follows:
team_id name
1 Team1
2 Team2
...and more
location_id name
1 Dallas
2 New York
...and more
branch_id name
1 Austin
2 New Jersey
...and more
How do I put this data into one Dataset so that I can loop through the data and manipulate it?
I've a classified ads system on ASP.NET/c#/MS SQL, and I'm trying to figure out where to store the images that people upload when placing an ad. The ad itself is being stored in a SQL server database.
The images are now being stored in a subfolder of my webapp. It seems to work fine, however I only recently discovered a big problem. Everytime a user deletes an ad, the attached images are to be deleted as well including the folder they reside in. This leads to a restart of the asp.net application. I searched internet and found that restarting the web-app is actually intended behaviour when a subfolder is being deleted.
I can remove these images including the folders they are stored in?
I can acces them using a URL (the images need to be shown in the webpages) Without getting the web-app being restarted?
I create a new class FileUpload for my web page. In onload method of page, i create a new object of that class and after file uploaded, i fill some information of file to that object(name, size, extention,type). I create a method in class to delete that file. But When i use it, the error "The process cannot access the file 'D: emp25.jpg' because it is being used by another process." is appear. I thinks the object is using the file uploaded and i can't delete file.What's the problem and how can i solve it? I need to delete file.
View 5 RepliesUsers can upload files to the server, which are stored effectively forever.
A few of my ideas involve logging every upload, but then the files are usually referenced in html which isn't easy to track.
Files can sit unused but still be referenced. I could do a fuill text search on these, but that's pretty brute force.
My system Uploads files to an IIS server and then i manipualate them and after finished doing every thing, i need to delete the original file, the problem is that the IIS "grabs" the file and i can't delete it, when i close the procces i can delete it manualy from the server, but until i close the procces i can't even do that...
I'm using:File.Delete(Server.MapPath(OriginalFileVirtualPath)); to delete the file.
p.s. for now i'm using the .net server, not a full active IIS, but i don't think that the problem is over there...It even make some sence that when i upload a file to the sever, it won't let to delete it strate away, but i'm sure there is a work around...
my question is related to this topic :
http://forums.asp.net/p/1626458/4186694.aspx#4186694
I added another fileUpload in the Sending E-mail Method as following:
if (FileUpload1.HasFile && FileUpload2.HasFile)
{
FileUpload2.SaveAs(Server.MapPath("NewFolder1") +
"/" + User.Identity.Name.Substring(7) +
"FB.gif");
FileUpload2.SaveAs(Server.MapPath("NewFolder1") +
"/" + User.Identity.Name.Substring(7) +
"SP.gif");
"How can I use these two files that uploaded (Server.MapPath("NewFolder1")
) as attachments in the Attachment Method??"
I tried with this code:
message.Attachments.Add(new System.Net.Mail.Attachment(Server.MapPath("NewFolder1")));
I am VB.Net Windows Application Developer Now i am going an ASP.Net Application. So, the Problem is that in Windows Application i Code this Project like given Below Actually i am Using SQL Server as DataBase and Store Procedure as Query.Becuase i had tried to control the ASP.Net Data Grid with Loop and i Failed to Control it with this method
Private Sub btn_Ok_Click(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles btn_Ok.Click
Fill_dataset("Sel_MovNames", "Tbl_MovNames", Convert.toint32(cmb_MovID.SelectedValue))
[code]...
In my website I have upload control that I use to upload files and all the links of uploaded files saved to sql database on the server of hosting company.then I have a grid view filled from database with the links of the uploaded files, how to delete some files that I uploaded to the server by code from the gridview
View 2 Replieshow to store files (pdf and word files) into sql database and how to display that files with an option of "save" , "open" window from sql data base when user click. i am doing project using c# + asp.net web application
View 1 RepliesI'm trying to use an asp:FileUpload Control to allow users to upload files (.doc, .gif, .xls, .jpg) to a server that is outside of our DMZ and not the Web Server. We want to have the ability to look at these files for viruses, structure, etc prior to saving them into another directory that would allow access to outside users. From what I have read about this control is that it will allow for files to be uploaded to the web server. Can this control be used to upload files to a server other than the web server? If it can be done where should I look for this type of functionality or how do I force it to go to https:servernamefolder name (Where server name is not the web server)? Would I have to read the file then write it to the other server?
View 2 RepliesShowing thumbnail of uploaded media files (pictures, videos etc..) I tried to extract thumbnails from thumbnails.db using Microsoft Shell Controls And Automation (Interop.Shell32.dll). I followed [URL] PROBLEM: I tried it in WPF application and it worked. Then i used the same code in ASP.NET WebForms website and it works for pictures but doest not work for videos. I also tried the same in clean console application but it doesn't work as well. But in wpf it works! the same assembly. Assembly is from Window 7, but neither WinXp's Interop.Shell32.dll works for videos in websites. It throws an exception NotImplementedException whenn I call IExtractImage.Extract(ref IntPtr phBmpThumbnail); Can you explain this behaviour? [URL]
View 1 RepliesHow to add watermark to uploaded doc (pdf or image files).The workflow will be-User register at portal -> user upload some required document (like financial proof or some kind) -> When saving them to database -> a watermark (predefined by admin at backend in admin panel as - Logo or Text) will be added to those uploaded document on top and bottom or wherever possible on the uploaded document.
So in future when admin views the document uploaded by him in his account, it will be displayed with stamp or the watermark. It will prove that the document is uploaded to server by user or whatever. Now, this we have found way to do in jpg, but in case of pdf its quite tough..
I just inherited an ASP.NET WebForms web application that I was tasked with refactoring. One of the features is a file upload and while debugging I noticed that as soon as a file is posted to a certain page/handler, it is automatically uploaded to the root directory of the application. The file is then moved to the proper location. I can't seem to figure out whats causing this automatic upload of the file. Is there something I'am overlooking in ASP.NET WebForms that allows this to happen? Is it an IIS configuration or something?
View 1 RepliesI recently published my website locally and then uploaded the .aspx files to the root directory of the host server and then uploaded all of the compiled files into a new "bin" subdirectory. But, when I accessed my website through my domain name, I got an error message that said that my Default web page has not been compiled.
The service that I am using is an ASP.NET hosted server called JodoHost. But I noticed that, besides the new "bin" subdirectory that I put all of my compiled files into, there was also subdirectories named aspnet_client, cgi-bin, and images. I assume that my problem stems from not placing my compiled files into these. Is this correct? If so, what should I be placing into which directories?
InnerException: System.AccessViolationException: Attempted to read or write protected memory.This is often an indication that other memory is corrupt.at System.Runtime.InteropServices.CustomMarshalers.EnumeratorViewOfEnumVariant.MoveNext()
I am getting this exception few times a day in our website.The page that create PDF file from the uploaded image files result in above excption.
Now I am able to upload files in folder and showing in gridview. but suppose i am going to upload new files so that time in page previous files is showing in gridview. i want that when i am uploading new files so after that uploaded new files only should show in gridview old files should not show in gridview.
View 1 RepliesI'd like give unique name for uploaded files in a folder.
I know we can a uniqueidentifier to file name but I think it isn't a good way.
I have a page that loads a two different files that the user uploaded during page_load. The code is an example I used from the aspsnippets site. The files are stored in a server folder while the location is saved in the database. The code below gets all files in the folder and binds them to a gridview.
Dim filePaths() As String = Directory.GetFiles(Server.MapPath("~/Uploads/2012/emp/"))
Dim files As List(Of ListItem) = New List(Of ListItem)
For Each filePath2 As String In filePaths
files.Add(New ListItem(Path.GetFileName(filePath), filePath))
Next
gvEmp.DataSource = files
gvEmp.DataBind()
What I want to do is to get only one file per user as the fileID along with the location is saved in for every user. I ran a query to get the fileLocation and pass that location stored in the database instead of the current server path but I can't figure out how I would do it.
I am trying to put together a page where files uploaded by a specific users would be listed in a bulletedlist and I am stuck. Here's the rundown:
Users login, they upload files which are saved to disk in the user's own directory. All the file's information, including the path, is stored in a SQL database.
The user has also its own page, where there is a bulletedlist (set as a hyperlink) that gets the filename from the SQL. However, the path to the file is incomplete.
The file is saved to the site's directory structure: C:WebsitesSiteUploadsUserFile.pdf. However, the hyperlink shows[URL]
Can anyone point me to the right direction? Below is a snippet of the upload method and the retrieval to build the bulletedlist.
[Code]....
[Code]....
How can i upload a image in specific folder of server using jquery .... i have many folder under image directory and i want to choose the folder at the time of uploading.
View 1 RepliesWe are going to start accepting resumes online but I need to know if the uploaded files will be virus scanned before I park them into the database. I thought this would be a server thing but the server admin and the security guy both said they didn't know. We already have a firewall and antivirus software, I just want to know how things work with native ASP.Net controls and not a product to try.
View 2 Repliesis datable data store in asp.net dataset.. ?
View 1 RepliesI want to store the following code into the database:
[Code]....
and then get it back in the dataset and display on a page.
As of now I have successfully stored the questions with varchar(MAX) datatype but when I try to get it in the dataset i get the following error:
Failed To Enable Constraints. One Or More Rows Contain Values Violating Non-null, Unique, Or Foreign-key Constraints.
I am doing this in a ASP.NET web application.
EDIT:
Here is the Table definition of the table I am inserting the data into
The query I am using to insert the data into the table:
[Code]....
And finally the code by which I am extracting the data from the dataset
[Code]....
I am working on a web application that is consuming a Dataset returned by a web service. As the application is running I store that Dataset as a session variable to be used over and over again as the user navigates to the different pages that will edit the tables within the dataset. The idea was the user will only have to wait for the data once when the application loads then the application would use the session variable until the user saves the changes they made, when that happens it would pass the edited tables to the service to update the database. Is there problems with this design and the storage of the Dataset and Datatables as a session variable?
View 4 Replies
