when click on delete, record containing image removed database image still remains in folder. please experienced asp.net programmer help? thank in advance!
<%@ page title="" language="c#" masterpagefile="~/masterpage.master" autoeventwireup="true" codefile="management.aspx.cs" inherits="pages_management_management" %>
add new product
<asp:gridview id="grdproducts" runat="server" allowpaging="true" allowsorting="true" autogeneratecolumns="false" datakeynames="id,image" datasourceid="generalproducts" width="80%" onrowediting="grdproducts_rowediting" cellpadding="4" forecolor="#333333" gridlines="none"> <alternatingrowstyle backcolor="white" /> <columns> <asp:commandfield showdeletebutton="true" showeditbutton="true" /> <asp:boundfield datafield="id" headertext="id" insertvisible="false" readonly="true" sortexpression="id" /> <asp:boundfield datafield="catid" headertext="catid" sortexpression="catid" /> <asp:boundfield datafield="name" headertext="name" sortexpression="name" /> <asp:boundfield datafield="price" headertext="price" sortexpression="price" /> <asp:boundfield datafield="description" headertext="description" sortexpression="description" /> <asp:boundfield datafield="image" headertext="image" sortexpression="image" /> <asp:boundfield datafield="seller" headertext="seller" sortexpression="seller" /> <asp:boundfield datafield="stateid" headertext="stateid" sortexpression="stateid" /> <asp:boundfield datafield="cityid" headertext="cityid" sortexpression="cityid" /> <asp:boundfield datafield="streetid" headertext="streetid" sortexpression="streetid" /> <asp:boundfield datafield="streetnoid" headertext="streetnoid" sortexpression="streetnoid" /> <asp:boundfield datafield="type" headertext="type" sortexpression="type" /> <asp:boundfield datafield="packaging" headertext="packaging" sortexpression="packaging" /> <asp:boundfield datafield="unit" headertext="unit" sortexpression="unit" /> </columns> <editrowstyle backcolor="#2461bf" /> <footerstyle backcolor="#507cd1" font-bold="true" forecolor="white" /> <headerstyle backcolor="#507cd1" font-bold="true" forecolor="white" /> <pagerstyle backcolor="#2461bf" forecolor="white" horizontalalign="center" /> <rowstyle backcolor="#eff3fb" /> <selectedrowstyle backcolor="#d1ddf1" font-bold="true" forecolor="#333333" /> <sortedascendingcellstyle backcolor="#f5f7fb" /> <sortedascendingheaderstyle backcolor="#6d95e1" /> <sorteddescendingcellstyle backcolor="#e9ebef" /> <sorteddescendingheaderstyle backcolor="#4870be" /> </asp:gridview>
" deletecommand="delete [product] [id] = @id" insertcommand="insert [product] ([name]) values (@name)" selectcommand="select * [product]" updatecommand="update [product] set [name] = @name [id] = @id">
<deleteparameters> <asp:parameter name="id" type="int32" /> </deleteparameters> <insertparameters> <asp:parameter name="name" type="string" /> </insertparameters> <updateparameters> <asp:parameter name="name" type="string" /> <asp:parameter name="id" type="int32" /> </updateparameters> </asp:sqldatasource> </p> <p> </p> <p> <asp:linkbutton id="linkbutton2" runat="server" cssclass="button" postbackurl="~/pages/management/manageproductcats.aspx">add new productcat</asp:linkbutton> </p> <asp:gridview id="grdproductstype" runat="server" allowpaging="true" allowsorting="true" autogeneratecolumns="false" datakeynames="id" datasourceid="generalproductcat" width="50%" style="margin-top: 0px" cellpadding="4" forecolor="#333333" gridlines="none"> <alternatingrowstyle backcolor="white" /> <columns> <asp:commandfield showdeletebutton="true" showeditbutton="true" /> <asp:boundfield datafield="id" headertext="id" insertvisible="false" readonly="true" sortexpression="id" /> <asp:boundfield datafield="name" headertext="name" sortexpression="name" /> </columns> <editrowstyle backcolor="#2461bf" /> <footerstyle backcolor="#507cd1" font-bold="true" forecolor="white" /> <headerstyle backcolor="#507cd1" font-bold="true" forecolor="white" /> <pagerstyle backcolor="#2461bf" forecolor="white" horizontalalign="center" /> <rowstyle backcolor="#eff3fb" /> <selectedrowstyle backcolor="#d1ddf1" font-bold="true" forecolor="#333333" /> <sortedascendingcellstyle backcolor="#f5f7fb" /> <sortedascendingheaderstyle backcolor="#6d95e1" /> <sorteddescendingcellstyle backcolor="#e9ebef" /> <sorteddescendingheaderstyle backcolor="#4870be" /> </asp:gridview> <asp:sqldatasource id="generalproductcat" runat="server" connectionstring= "<%$ connectionstrings:superstoredbconnectionstring %>" deletecommand="delete [productcat] [id] = @id" insertcommand="insert [productcat] ([name]) values (@name)" selectcommand="select * [productcat]" updatecommand="update [productcat] set [name] = @name [id] = @id"> <deleteparameters> <asp:parameter name="id" type="int32" /> </deleteparameters> <insertparameters> <asp:parameter name="name" type="string" /> </insertparameters> <updateparameters> <asp:parameter name="name" type="string" /> <asp:parameter name="id" type="int32" /> </updateparameters> </asp:sqldatasource> </div>
from can tell, you're using <asp:sqldatasource >
data source gridview. sql commands in place , delete command works because deletes db.
i don't see code, assume there isn't any. need add code in "rowdeleting" event of gridview. code can added there access filesystem , delete file whatever folder you're talking about.
Comments
Post a Comment