asp.net - Using Delete Button from Gridview to delete a record from Database and from Folder -


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>     &nbsp;</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