.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

delete downloaded files

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :ASP.Net

Hi all,

I'm not very familiar with asp.net, but i have created a small application with your help.

I can create  dataset's and add some files to this dataset's.

My problem is that i can't delete the added files. I have a button delete but is only delet the record in the sql database but not the files from the harddisk.

Can anyone help me to solve this problem?

I tried allready view months ago but unfortuntly o couldn't solve this.

here is my frontend: (see the part with Gridview1)

<%@ Page Title="test" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="detailshyper.aspx.vb" Inherits="details" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:freelancerberConnectionString %>"
        DeleteCommand="DELETE FROM [freelancer] WHERE [ID] = @original_ID AND (([name] = @orig

View Complete Post

More Related Resource Links

Receive/Delete Multiple FTP Files based on condition using SCRIPT(VB) TASK

I am trying to receive and delete multiple FTP files from a remote FTP server using Script task Below is the code   Dim FTPConnMgr As ConnectionManager FTPConnMgr = Dts.Connections("FTP Connection Manager") Dim FTPClientConn As FtpClientConnection = New FtpClientConnection(FTPConnMgr.AcquireConnection(Nothing)) Dim FileTimeStampNew As String = "20100913021807" Dim remoteFileNames(0) As String remoteFileNames(0) = Dts.Variables("FtpRemoteDirectory").Value & "*" & FileTimeStampNew & ".*" 'Below hardcoded FileName works good. But the problem is there are lots of file in the FTP folder that I dont want to receive 'remoteFileNames(0) = Dts.Variables("FtpRemoteDirectory").Value & "Company_alpha_Full_20100913021807.xml" Dim localPath As String = Dts.Variables("FtpLocalDirectory").Value FTPClientConn.Connect() FTPClientConn.ReceiveFiles(remoteFileNames, localPath, False, False) FTPClientConn.Close() Dts.TaskResult = ScriptResults.Success End Sub End Class If i specifically mention the RemotefileNames this works fine but, when I say *.* it executes succefully but doesn't receives the file. Please advice how to receive multiple file based on a variable BR, AWM

Delete Old Backup Files that are saved in .RAR format



I have configured my SQL Server 2005 to take backups and I have another program running to compress these files to .RAR extension to save space.

I have a Maintenance Cleanup Task also configured to delete old .RAR files but it does not work.  I have specified the extension to look for to be RAR and the job runs without error but no files are deleted.

Is it that only BAK and TRN files are deleted using Maintenance Cleanup Task?

how to delete files from folder in webserver


hi i m using fileupload concept and saving the files to a folder download.hw can i check the files names saved in that folder while site is hosted on webserver.is there any way to delete some of files from that folder runtime. 

Delete files older than 3 days using SSIS tasks


I want to delete all files in a given folder that are older than 3 days from today's date.

I tried using a "Foreach Loop container"  with a "File System" task inside it but found I couldn't access any file properties such as the file creation date. Am I using the wrong task for this job?






P.S. History of the problem:

I used the sql 2005 Database maintenance program to setup our database backup jobs. One day I noticed that the free space on the drive where we keep the dumps had grown small. I found that we had at least 4 weeks of dumps in there, not the 3 days I wanted to keep!  I looked but could not find the "delete file" option in the SSIS package generated by the Database Maintenance Wizard. No wonder the files were piling up.

Show users which files they have downloaded



I am setting up an extranet for our organisation that allows clients to download a large amount of files (several hundred per month). This works fine in general, the only problem I have is that the clients want to see which files they have already downloaded and which not, as it is quite difficult to handle otherwise.

I have been tearing my hair out over this and haven't been able to come up with a good solution so far. Is there any way for SharePoint to display to the user whether they have already downloaded a file or not?

Thanks for the help.

Delete Old Files from FTP


How can I need to delete files from FTP which are more than 30 days old ? The Filename format provides the date of the file like

'ABC_10-09-2010 12:09:000.000'


MOSS remembers cookies files ans cannot delete it even if I delete cookies from my IE


how do I solve this problem without having the rest of the link (withoutthe /Cookie..)


the website is a redirect in the TMG server (means that every user who tries to connect to the website has a redirect in the TMG server)..

I hope to get an answer as fast as possible! thanks!

Stored procedure to get list of files and downloaded

Hi all,I have the below table which gets updated whenever the files get downloaded.The details of list of filenames downloaded will be saved in this table.i need to get the files which are downloaded and put it into a temp table on regular basis.From that Temp TAble i will use the Filenames and split each file into two.The DownloadID will be unique in this table.I need to write a Stored procedure for all this process.How will be the stored proc?i need to call this proc in a job.can you help me in writing the proc..
DownloadID	ConfigurationId		FileName	          LogDate	     FilePublishedDateTime	 
1	          2301		Nobel_2010_10_01.tsv	 2010-10-01	2010-10-04 02:19:53.000	
2	          2301		Nobel_2010_09_08.tsv	 2010-09-08	2010-09-09 21:49:00.000	
3	          2301		Nobel_2010_09_08.tsv	 2010-09-08	2010-09-09 21:49:00.000	
4	          2701		System_2010_10_01.tsv	 2010-10-01	2010-10-03 23:57:41.000 
5	          2401	     Boot_2010_10_01.tsv	 2010-10-01	2010-10-04 00:46:19.000 
Thanks in advance!!

SQL Server 2008 Maintenance plan will not delete bak and trn files


I have a sql 2008 maintenance plan to backup databases and to delete old bak files.  The db backup works but the delete does not.  I do not get any error messages, all steps marked successful.  So, I copied the sql statement EXECUTE master.dbo.xp_delete_file 0,N'Z:\SQL BACKUPS\',N'bak',N'2010-11-14T12:43:35',1 and tried to execute in a query window.  I have a successful completion message, BUT the files are not deleted.  I have ensured that the extension is bak and the folder is correct and the account has sysadmin on the server and is a sql sa.  I have tried many options and no success.  

We are version   Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (VM).

Any help would be appreciated.  Thanks!

How to delete unnecessary files from my site using WebMatrix?


I have published my site using WebMatrix.

In my local folder on my PC I've deleted some unnecessary files.

And then published the updated site again.

WebMaxtrix never give any indication it is going to delete files that are not found in an UPDATED published site.

When browsing to my site and requesing the-supposed-to-be-deleted resources I still get them in my browser.


Thanks for any help

Which task would use to copy, move or delete files in SSIS

can any one help me for this question any link of examples for the same highly appreciable
Regards, Amitesh Srivastva

Clean Web.Config Files (VS 2010 and .NET 4.0 Series)

.NET 4 includes a new version of the CLR, and a new .NET 4 specific machine.config file (which is installed side-by-side with the one used by .NET 2, .NET 3 and .NET 3.5).

The new .NET 4 machine.config file now automatically registers all of the ASP.NET tag sections, handlers and modules that we've added over the years, including the functionality for:

.ASP.NET Dynamic Data
.ASP.NET Routing (which can now be used for both ASP.NET WebForms and ASP.NET MVC)
.ASP.NET Chart Control (which now ships built-into ASP.NET V4)
What this means is that when you create a new "Empty ASP.NET application" project in VS 2010, you'll find that the new default application-level web.config file is now clean and simple:

Adding Dynamic Rows in ASP.NET GridView Control with TextBoxes and with Delete functionality

In my previous examples, I have demonstrated on how to add dynamic rows in GridView control with TextBoxes and how to save the values into the database. Now, seems that most of the developers are asking if how to add a delete functionality with it. So in this example, I'm going to show on how to delete a certain row in the dynamic GridView with TextBoxes.

SharePoint document migration challenges when migrating files and folders

There are several challenges when migrating documents to Microsoft SharePoint. While these challenges can be overcome, they are a real pain if the migration source, content and file systems are not SharePoint friendly.

Combine, minify and compress JavaScript files to load ASP.NET pages faster

Websites are getting more interactive these days and most of this interactivity comes from JavaScript. People are using different JavaScript libraries and frameworks to make their websites more interactive and user friendly.

SqlCommand.ExecuteNonQuery() returns -1 when doing Insert / Update / Delete

Sometimes you end up with a return value of -1 when using the SqlClient.SqlCommand.ExecuteNonQuery method.

Why is that?

Well, the ExecuteNonQuery method is there for statements for changing data, ie. DELETE / UPDATE /INSERT, and the returned value are the number of rows affected by that statement.

When checking the documentation we can see that there are some conditions that return -1.

For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command.

When a trigger exists on a table being inserted or updated, the return value includes the number of rows affected by both the insert or update operation and the number of

rows affected by the trigger or triggers. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1.

PrintPocketCE Print Pocket Excel, Pocket Word and email files

Version 3.560 (May 15, 2009):

Important bug fix: a slight difference in how some devices create fonts was causing a few devices to have significantly longer print times for large print jobs.

Adjusted PocketJet printer paper feed commands

Other minor fixes and enhancements.

Version 3.559 (Mar 5, 2009):

Added support for Martel MCP78xx printers

Version 3.558 (Aug 20, 2008):

Added support for Martel MCP78xx printers

Version 3.557 (June 27, 2008):

Fixed error in Canon printer support

Fixed COM0 port selection

Version 3.556 (June 15, 2008):

Added support for Brother MW-260

Added support for Sato MB400

Version 3.555 (Aug 8, 2007):

Added support for Pentax RuggedJet 3 and RuggedJet 4 printers

Changed Epson TM-P60 support to maximum page width of 1200 dots

Version 3.551 (Aug 1, 2006):

Added Peripheral Nomad printer support

Version 3.550 (Mar 23, 2006):

Added Panasonic JT-H200PR printer support

Added Pocket Spectrum printer support

Fixed problem with WM5.0 "inverted image" problem
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend