Implement Upload file control with DetailsView

Question

Good times All

I've an application to mange Chocolate shope,

at admin side there is many pages to mange a site, my problem with a form to insert data in data base with uploaded image by File upload control implemented in details view

you can see a front end code here: 

 

 

<asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SDS_Subcategory" DefaultMode="Insert" Height="50px" Width="125px" OnItemInserting="DetailsView1_ItemInserting">
            <Fields>
                <asp:TemplateField HeaderText="Main Category:">
                    <InsertItemTemplate>
                        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="C_Name" DataValueField="C_Id" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
                        </asp:DropDownList>
                        <asp:Literal ID="Lit_cat" runat="server" Text='<%#Bind("C_Id") %>'></asp:Literal>
                        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" SelectCommand="SELECT [C_Id], [C_Name] FROM [Categories]"></asp:SqlDataSource>
                        <asp:Label ID="Label1" runat="server"></asp:Label>
                    </InsertItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Name:">
                    <InsertItemTemplate>
                        <asp:TextBox ID="TXT_Name" runat="server" Text='<%# Bind("Name") %>'></asp:TextBox>
                    </InsertItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Image">
                    <InsertItemTemplate>
                        <asp:FileUpload ID="FU_Image" runat="server" Enabled='<%# Bind("Image") %>' />
                    </InsertItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="Ingredients">
                    <InsertItemTemplate>
                        <asp:TextBox ID="TXT_Description" runat="server" Text='<%# Bind("Ingredients") %>' TextMode="MultiLine"></asp:TextBox>
                    </InsertItemTemplate>
                </asp:TemplateField>
                <asp:CommandField ShowInsertButton="True" />
                <asp:TemplateField>
                    <InsertItemTemplate>
                        <asp:Label ID="LBMSG" runat="server"></asp:Label>
                    </InsertItemTemplate>
                </asp:TemplateField>
            </Fields>
        </asp:DetailsView>
    </div>

 

 and a code behind here:

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.IO;


namespace WebApplication1.admin
{
    public partial class sub_category : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            Label lbmessage = (Label)DetailsView1.FindControl("LBMSG");
        }

        protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
        {
            string function = ((DropDownList)DetailsView1.FindControl("DropDownList1")).SelectedValue.ToString();
            Literal lit_txt = (Literal)DetailsView1.FindControl("lit_cat");
            lit_txt.Text = function;
            Label lbl_txt = (Label)DetailsView1.FindControl("Label1");
        }

        protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
        {
            FileUpload fu = (FileUpload)DetailsView1.FindControl("FU_Image");
            TextBox txtimg= (TextBox)DetailsView1.FindControl("TXT_Name");
            Literal lit_txt = (Literal)DetailsView1.FindControl("lit_cat");
            TextBox txtdesc =(TextBox)DetailsView1.FindControl("TXT_Description");
            if (fu.PostedFile != null)
            {
                string imgfile = Path.GetFileName(fu.PostedFile.FileName);
                //fu.SaveAs("../images/categories" + imgfile);
                fu.SaveAs(Server.MapPath("../images/categories") + imgfile);
                string mainconnection = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
                SqlConnection sqlcon = new SqlConnection(mainconnection);
                sqlcon.Open();
                string sqlquery = "insert into [dbo].[Sub_categories]([Name],[Image],[Ingredients],[C_Id]) values (@Name,@Image,@Ingredients,@C_Id)";
                SqlCommand sqlcom = new SqlCommand(sqlquery, sqlcon);
                sqlcom.Parameters.AddWithValue("@Name", txtimg);
                sqlcom.Parameters.AddWithValue("@Image", "../images/categories" + imgfile);
                sqlcom.Parameters.AddWithValue("@Ingredients", txtdesc);
                sqlcom.Parameters.AddWithValue("@C_Id", lit_txt);
                sqlcom.ExecuteNonQuery();
                Label lbmessage = (Label)DetailsView1.FindControl("LBMSG");
                lbmessage.Text = "Image and record has beed saved Succesfully";
                sqlcon.Close();
            }
            else {
                Label lbmessage = (Label)DetailsView1.FindControl("LBMSG");
                lbmessage.Text = "Image and record not saved Succesfully";
            }
        }

    }
}

 

 so there is a way to solve a prolem