banner



How To Delete Image From Folder In C# Windows Application

Hi itsme,

Refer below it's working.

HTML

<asp:GridView runat="server" ID="gvImage" AutoGenerateColumns="false" OnRowCancelingEdit="gvImage_RowCancelingEdit"     DataKeyNames="Id" OnRowEditing="gvImage_RowEditing" OnRowUpdating="gvImage_RowUpdating"     OnRowDeleting="gvImage_RowDeleting">     <Columns>         <asp:TemplateField HeaderText="Business organization Proper name">             <ItemTemplate>                 <asp:Label ID="lblId" runat="server" Text='<%# Eval("Id") %>'></asp:Label>             </ItemTemplate>             <EditItemTemplate>                 <asp:TextBox ID="txt_Id" runat="server" Text='<%# Eval("Id") %>'></asp:TextBox>             </EditItemTemplate>         </asp:TemplateField>         <asp:TemplateField HeaderText="Name">             <ItemTemplate>                 <asp:Label ID="lblname" runat="server" Text='<%# Eval("Proper name") %>'></asp:Characterization>             </ItemTemplate>             <EditItemTemplate>                 <asp:TextBox ID="txt_name" runat="server" Text='<%# Eval("Proper noun") %>'></asp:TextBox>             </EditItemTemplate>         </asp:TemplateField>         <asp:TemplateField HeaderText="Image">             <ItemTemplate>                 <asp:Prototype ID="Image1" runat="server" ImageUrl='<%# Eval("Path") %>' eight="80px"                     Width="80px" />             </ItemTemplate>             <EditItemTemplate>                 <asp:Image ID="img_user" runat="server" ImageUrl='<%# Eval("Path") %>' Pinnacle="80px"                     Width="80px" /><br />                 <asp:FileUpload ID="FileUpload1" runat="server" />             </EditItemTemplate>         </asp:TemplateField>         <asp:TemplateField>             <ItemTemplate>                 <asp:LinkButton ID="lbl_edit" runat="server" CommandName="Edit">Edit</asp:LinkButton>                 <asp:LinkButton ID="lbl_delete" runat="server" CommandName="Delete">Delete</asp:LinkButton>             </ItemTemplate>             <EditItemTemplate>                 <asp:LinkButton ID="lbl_update" runat="server" CommandName="Update">Update</asp:LinkButton>                 <asp:LinkButton ID="lbl_cancle" runat="server" CommandName="Cancel">Cancel</asp:LinkButton>             </EditItemTemplate>         </asp:TemplateField>     </Columns> </asp:GridView> <br /> <asp:Label ID="lblResult" runat="server" />

Namespaces

C#

using Arrangement.Data.SqlClient; using System.Data; using System.Configuration; using Arrangement.IO;

VB.Net

Imports System.Data.SqlClient Imports System.IO Imports System.Data

Code

C#

SqlConnection con; SqlDataAdapter da; DataSet ds; string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;  protected void Page_Load(object sender, EventArgs e) {     if (!this.IsPostBack)     {         ImageData();     } }  protected void ImageData() {     con = new SqlConnection(constr);     con.Open();     da = new SqlDataAdapter("SELECT * FROM tblfilespath", con);     ds = new DataSet();     da.Fill(ds);     gvImage.DataSource = ds;     gvImage.DataBind(); }  protected void gvImage_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {     gvImage.EditIndex = -1;     ImageData(); }  protected void gvImage_RowEditing(object sender, GridViewEditEventArgs e) {     gvImage.EditIndex = due east.NewEditIndex;     ImageData(); }  protected void gvImage_RowUpdating(object sender, GridViewUpdateEventArgs e) {     string Id = gvImage.DataKeys[e.RowIndex].Value.ToString();     TextBox txt_BName = (TextBox)gvImage.Rows[eastward.RowIndex].FindControl("txt_BName");     TextBox txt_city = (TextBox)gvImage.Rows[due east.RowIndex].FindControl("txt_city");     TextBox txt_name = (TextBox)gvImage.Rows[east.RowIndex].FindControl("txt_name");     TextBox txt_toll = (TextBox)gvImage.Rows[e.RowIndex].FindControl("txt_toll");     TextBox txt_link = (TextBox)gvImage.Rows[due east.RowIndex].FindControl("txt_link");     TextBox txt_pay = (TextBox)gvImage.Rows[e.RowIndex].FindControl("txt_pay");     TextBox txt_email = (TextBox)gvImage.Rows[e.RowIndex].FindControl("txt_email");     FileUpload FileUpload1 = (FileUpload)gvImage.Rows[e.RowIndex].FindControl("FileUpload1");     con = new SqlConnection(constr);      string path = "~/uploads/";     if (FileUpload1.HasFile)     {         path += FileUpload1.FileName;         FileUpload1.SaveAs(MapPath(path));     }     else     {         Image img = (Image)gvImage.Rows[e.RowIndex].FindControl("img_user");         path = img.ImageUrl;     }     SqlCommand cmd = new SqlCommand("update Q_SP_Afterlogin set Bussiness_name='" + txt_BName.Text + "',city='" + txt_city.Text + "',name='" + txt_name.Text + "',toll_free='" + txt_toll.Text + "',website_link='" + txt_link.Text + "',payment_mode='" + txt_pay.Text + "',email='" + txt_email.Text + "',Images='" + path + "'  where Id=" + Id + "", con);     con.Open();     cmd.ExecuteNonQuery();     con.Close();     gvImage.EditIndex = -1;     ImageData(); }  protected void gvImage_RowDeleting(object sender, GridViewDeleteEventArgs eastward) {     GridViewRow row = (GridViewRow)gvImage.Rows[e.RowIndex];     Label Id = (Label)row.FindControl("lblId");     Label proper name = (Label)row.FindControl("lblname");     con = new SqlConnection(constr);     con.Open();     SqlCommand cmd = new SqlCommand("delete FROM tblfilespath where Id='" + Catechumen.ToInt32(gvImage.DataKeys[e.RowIndex].Value.ToString()) + "'", con);     cmd.ExecuteNonQuery();     con.Close();     ImageDeleteFromFolder(name.Text);     ImageData(); }  protected void ImageDeleteFromFolder(string Images) {     string file_name = Images;     string path = Server.MapPath("~/uploads/");     FileInfo file = new FileInfo(path + file_name);     if (file.Exists)     {         file.Delete();         lblResult.Text = " file deleted successfully";         lblResult.ForeColor = System.Drawing.Color.Light-green;     }     else     {         lblResult.Text = " This file does non exists ";         lblResult.ForeColor = Organisation.Cartoon.Color.Crimson;     } }

VB.Net

Private con As SqlConnection Private da As SqlDataAdapter Individual ds As DataSet Individual constr Every bit String = ConfigurationManager.ConnectionStrings("constr").ConnectionString Protected Sub Page_Load(ByVal sender Every bit Object, ByVal eastward As EventArgs) Handles Me.Load     If Not Me.IsPostBack Then         ImageData()     Terminate If End Sub  Protected Sub ImageData()     con = New SqlConnection(constr)     con.Open up()     da = New SqlDataAdapter("SELECT * FROM tblfilespath", con)     ds = New DataSet()     da.Fill(ds)     gvImage.DataSource = ds     gvImage.DataBind() End Sub  Protected Sub gvImage_RowCancelingEdit(ByVal sender As Object, ByVal e As GridViewCancelEditEventArgs)     gvImage.EditIndex = -1     ImageData() End Sub  Protected Sub gvImage_RowEditing(ByVal sender As Object, ByVal e As GridViewEditEventArgs)     gvImage.EditIndex = east.NewEditIndex     ImageData() Stop Sub  Protected Sub gvImage_RowUpdating(ByVal sender As Object, ByVal e Every bit GridViewUpdateEventArgs)     Dim Id As String = gvImage.DataKeys(e.RowIndex).Value.ToString()     Dim txt_BName Every bit TextBox = CType(gvImage.Rows(e.RowIndex).FindControl("txt_BName"), TextBox)     Dim txt_city As TextBox = CType(gvImage.Rows(e.RowIndex).FindControl("txt_city"), TextBox)     Dim txt_name As TextBox = CType(gvImage.Rows(east.RowIndex).FindControl("txt_name"), TextBox)     Dim txt_toll As TextBox = CType(gvImage.Rows(e.RowIndex).FindControl("txt_toll"), TextBox)     Dim txt_link As TextBox = CType(gvImage.Rows(e.RowIndex).FindControl("txt_link"), TextBox)     Dim txt_pay Equally TextBox = CType(gvImage.Rows(e.RowIndex).FindControl("txt_pay"), TextBox)     Dim txt_email Every bit TextBox = CType(gvImage.Rows(east.RowIndex).FindControl("txt_email"), TextBox)     Dim FileUpload1 Every bit FileUpload = CType(gvImage.Rows(eastward.RowIndex).FindControl("FileUpload1"), FileUpload)     con = New SqlConnection(constr)     Dim path As String = "~/uploads/"      If FileUpload1.HasFile Then         path += FileUpload1.FileName         FileUpload1.SaveAs(MapPath(path))     Else         Dim img As Image = CType(gvImage.Rows(eastward.RowIndex).FindControl("img_user"), Image)         path = img.ImageUrl     End If      Dim cmd As SqlCommand = New SqlCommand("update Q_SP_Afterlogin gear up Bussiness_name='" & txt_BName.Text & "',city='" + txt_city.Text & "',name='" + txt_name.Text & "',toll_free='" + txt_toll.Text & "',website_link='" + txt_link.Text & "',payment_mode='" + txt_pay.Text & "',email='" + txt_email.Text & "',Images='" & path & "'  where Id=" & Id & "", con)     con.Open()     cmd.ExecuteNonQuery()     con.Close()     gvImage.EditIndex = -1     ImageData() Finish Sub  Protected Sub gvImage_RowDeleting(ByVal sender As Object, ByVal eastward Every bit GridViewDeleteEventArgs)     Dim row Every bit GridViewRow = CType(gvImage.Rows(e.RowIndex), GridViewRow)     Dim Id Equally Label = CType(row.FindControl("lblId"), Label)     Dim name As Label = CType(row.FindControl("lblname"), Label)     con = New SqlConnection(constr)     con.Open()     Dim cmd As SqlCommand = New SqlCommand("delete FROM tblfilespath where Id='" & Convert.ToInt32(gvImage.DataKeys(due east.RowIndex).Value.ToString()) & "'", con)     cmd.ExecuteNonQuery()     con.Shut()     ImageDeleteFromFolder(proper noun.Text)     ImageData() Terminate Sub  Protected Sub ImageDeleteFromFolder(ByVal Images Every bit String)     Dim file_name As Cord = Images     Dim path As String = Server.MapPath("~/uploads/")     Dim file As FileInfo = New FileInfo(path & file_name)      If file.Exists Then         file.Delete()         lblResult.Text = " file deleted successfully"         lblResult.ForeColor = Organization.Drawing.Colour.Green     Else         lblResult.Text = " This file does not exists "         lblResult.ForeColor = System.Drawing.Color.Red     Cease If End Sub

Screenshot

Source: https://www.aspsnippets.com/questions/121149/Delete-data-from-Database-and-Image-from-Folder-Directory-using-C-and-VBNet-in-ASPNet/

Posted by: robeyandeavy1951.blogspot.com

0 Response to "How To Delete Image From Folder In C# Windows Application"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel