如何在GRIDVIEW中删除文件路径同时删除文件?
源码如下:
我检查过几次代码了, 没有任何报错, 问题就出在文件老是删不了路径中的图片文件.
<%@ Page Language="VB" %>
<%@ Import Namespace="System.IO" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">
Protected Sub GridView1_RowCommand(ByVal sender As Object, ByVal e As GridViewCommandEventArgs)
If GridView1.EditIndex = -1 Then
Return
End If
Dim fileUpLoad As FileUpload = TryCast(GridView1.Rows(GridView1.EditIndex).FindControl("FileUpload1"), FileUpload)
Dim fileName As String = Guid.NewGuid().ToString()
Dim extension As String = System.IO.Path.GetExtension(fileUpLoad.FileName)
If fileUpLoad.HasFile Then
'When insert a file, rename image as guid name
fileUpLoad.SaveAs(Server.MapPath("~/images/" + "/" + fileName + extension))
Me.SqlDataSource1.UpdateParameters("image_name").DefaultValue = fileName + extension
Else
' Me.SqlDataSource1.UpdateParameters("image_name").DefaultValue=
End If
End Sub
Protected Sub GridView1_RowDeleting(ByVal sender As Object, ByVal e As GridViewDeleteEventArgs)
'取得图片名称
Dim imageName As String = GridView1.DataKeys(e.RowIndex).Values("image_name").ToString()
'customer.delete(GridView1.DataKeys(e.RowIndex).Values(0).ToString())
'FillCustomerInGrid()
'test
'Response.Write(delimg)
'problem is here
Dim path As String = Server.MapPath("~/images") + imageName
File.Delete(path)
End Sub
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource1"
EmptyDataText="没有可显示的数据记录。" AllowPaging="True" AllowSorting="True"
CellPadding="4" ForeColor="#333333" GridLines="None" OnRowCommand="GridView1_RowCommand">
<RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True"
ShowSelectButton="True" />
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True"
SortExpression="id" />
<asp:TemplateField>
<EditItemTemplate>
<asp:Image ID="Image2" runat="server" ImageUrl='<%# "images/" + DataBinder.Eval(Container.DataItem, "image_name") %>' />
<asp:FileUpload ID="FileUpload1" value="img.jpg" runat="server" />
</EditItemTemplate>
<ItemTemplate>
<asp:Image ID="Image3" runat="server" ImageUrl='<%# "images/" + DataBinder.Eval(Container.DataItem, "image_name") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:deareConnectionString1 %>"
DeleteCommand="DELETE FROM [Table1] WHERE [id] = @id"
InsertCommand="INSERT INTO [Table1] ([id], [image_name]) VALUES (@id, @image_name)"
ProviderName="<%$ ConnectionStrings:deareConnectionString1.ProviderName %>"
SelectCommand="SELECT [id], [image_name] FROM [Table1]"
UpdateCommand="UPDATE [Table1] SET [image_name] = @image_name WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter Name="id" Type="String" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="id" Type="String" />
<asp:Parameter Name="image_name" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="id" Type="String" />
<asp:Parameter Name="image_name" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
</div>
</form>
</body>
</html>