User-893317190 posted
Hi Gopi.MCA,
If you want to use image control to show the image and delete the file in your server,you could try the code below.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="ProductID" AutoGenerateDeleteButton="true" OnRowDeleting="GridView1_RowDeleting">
<Columns>
<asp:BoundField DataField="ProductID" HeaderText="ProductID" InsertVisible="False" ReadOnly="True" SortExpression="ProductID" />
<asp:BoundField DataField="ProductName" HeaderText="ProductName" SortExpression="ProductName" />
<asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
<asp:TemplateField HeaderText="images">
<ItemTemplate>
imagepathe is the file name, /images/WingtipToysBak is the folder pateh where the image is in
<asp:Image ID="Image1" runat="server" ImageUrl='<%# "/images/WingtipToysBak/"+Eval("ImagePath") %>' />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice" SortExpression="UnitPrice" />
<asp:BoundField DataField="CategoryID" HeaderText="CategoryID" SortExpression="CategoryID" />
</Columns>
</asp:GridView>
Code behind.
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindGridview();
}
}
private void BindGridview()
{
using (SqlDataAdapter adapter = new SqlDataAdapter("select * from productBak ", constr))
{
DataTable table = new DataTable();
adapter.Fill(table);
GridView1.DataSource = table;
GridView1.DataBind();
}
}
private static string constr = ConfigurationManager.ConnectionStrings["WingtipToysConnectionString"].ConnectionString;
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand com = new SqlCommand("delete from [productBak] where productid =@id ", con))
{
com.Parameters.AddWithValue("id", GridView1.DataKeys[e.RowIndex].Value);
Image image = GridView1.Rows[e.RowIndex].FindControl("Image1") as Image;
File.Delete(Server.MapPath(image.ImageUrl)); //get the absolute of image path and delete from the server
con.Open();
com.ExecuteNonQuery();
}
}
BindGridview();
}
Best regards,
Ackerly Xu
