uploaded image not display in gridview?

Question

User-1647172364 posted

hello sir my requirement is how image can be display in gridview here i select an image from desktop so when i click on submit button but i get an error
Could not find a part of the path 'F:\Asp Projects\WebApplication14\WebApplication14\Uploads\logo.png'.'

please execute them 

here is my code

cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Entity;
using System.Data;
using System.IO;
using System.Configuration;
namespace WebApplication14
{
    
    public partial class Model : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                Fillgridview();
                Filldropdownlist();
            }
        }

        public void Fillgridview()
        {
            using (SchoolEntities2 ctx = new SchoolEntities2())


                Gv8.DataSource = (from SchoolEntities2 in ctx.packages select SchoolEntities2).ToList();
                Gv8.DataBind();
        }
        public void Filldropdownlist()
        {
            using (SchoolEntities2 ctx = new SchoolEntities2())


                dd3.DataSource = (from SchoolEntities2 in ctx.packages select SchoolEntities2).Distinct().ToList();
               dd3.DataBind();
            dd3.Items.Insert(0, new ListItem() { Text = "Select", Value = "0" });
        }
        
        protected void BT_submit_Click(object sender, EventArgs e)
        {
          
            string connection = System.Configuration.ConfigurationManager.AppSettings["con"].ToString();

            string fileName = Path.GetFileName(file1.PostedFile.FileName);
            string filePath = "~/Uploads/" + fileName;
            file1.PostedFile.SaveAs(Server.MapPath(filePath));
            file1.SaveAs(filePath);

            int status = 0;
            using (SchoolEntities2 ctx = new SchoolEntities2())
            {
                ctx.packages.Add(new package()
                {

                    package_name = tb_name.Text,
                    reward = dd3.SelectedItem.ToString(),
                    remarks = tb_remarks.Text,
                    by_whom = Session["username"].ToString(),
                    date_time = System.DateTime.Now.ToLocalTime(),
                    path = filePath


                }) ;

                
                status = ctx.SaveChanges();
                Fillgridview();
                
}
        }

        protected void BT_update_Click(object sender, EventArgs e)
        {
            
            HiddenField field = (HiddenField)FindControl("HiddenField1");
            string Tbl_id = field.Value;
            decimal hf1 = Convert.ToDecimal(Tbl_id);

            using (SchoolEntities2 ctx = new SchoolEntities2())
            {

                var std = (from c in ctx.packages where c.tbl_id == hf1 select c).FirstOrDefault();

                std.package_name = tb_name.Text;
                std.reward = dd3.SelectedValue.ToString();
                std.remarks = tb_remarks.Text;


                ctx.Entry(std).State = System.Data.Entity.EntityState.Modified;
                ctx.SaveChanges();
                Fillgridview();

            }

        }


        protected void BT_delete_Click(object sender, EventArgs e)
        {
            using (SchoolEntities2 ctx = new SchoolEntities2())
            {
                

                var std = ctx.packages.First<package>();
                ctx.packages.Remove(std);
                ctx.SaveChanges();
                Fillgridview();
            
            }
        }

        public void Filldropdownlist1()
        {

            using (SchoolEntities2 ctx = new SchoolEntities2())
            {
                for (int i = 0; i < Gv8.Rows.Count; i++)
                {
                    try
                    {
                        var x = (from SchoolEntities2 in ctx.packages select SchoolEntities2).Distinct().ToList();

                        ((DropDownList)Gv8.Rows[i].FindControl("dd2")).DataSource = x;
                        ((DropDownList)Gv8.Rows[i].FindControl("dd2")).DataBind();
                        ((DropDownList)Gv8.Rows[i].FindControl("dd2")).Items.Insert(0, new ListItem() { Text = "Select", Value = "0" });

                    }
                    catch { }
                }

            }
        }
            
        

        protected void Gv8_RowEditing(object sender, GridViewEditEventArgs e)
        {
            Gv8.EditIndex = e.NewEditIndex;
            Fillgridview();
            Filldropdownlist1();
        }

        protected void Gv8_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            GridViewRow row = Gv8.Rows[e.RowIndex];
            decimal Tbl_id = Convert.ToDecimal(Gv8.DataKeys[e.RowIndex].Values[0]);


            string packag = (row.FindControl("TB_pack") as TextBox).Text;
            string reward = (row.FindControl("dd2") as DropDownList).SelectedValue.ToString();
            string remarks = (row.FindControl("TB_remark") as TextBox).Text;

            using (SchoolEntities2 ctx = new SchoolEntities2())
            {
                var package = (from c in ctx.packages
                               where c.tbl_id == Tbl_id
                               select c).FirstOrDefault();

                package.package_name = packag;
                package.reward = reward;
                package.remarks = remarks;


                ctx.SaveChanges();

            }
            Gv8.EditIndex = -1;
            Fillgridview();
            Filldropdownlist1();
        }

        protected void Gv8_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
        {
            Gv8.EditIndex = -1;
            Fillgridview();
            Filldropdownlist1();
        }
        protected void Gv8_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            decimal Tbl_id = Convert.ToDecimal(Gv8.DataKeys[e.RowIndex].Values[0]);
            using (SchoolEntities2 ctx = new SchoolEntities2())
            {
                var package = (from c in ctx.packages
                               where c.tbl_id == Tbl_id
                               select c).FirstOrDefault();
                
                ctx.packages.Remove(package);
                ctx.SaveChanges();

            }
            Gv8.EditIndex = -1;
            Fillgridview();
            Filldropdownlist1();
        }

        

    }
}

aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="Model.aspx.cs" Inherits="WebApplication14.Model" %>
<asp:Content ID="Content1" ContentPlaceHolderID="title" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="body" runat="server">

    
               <div style="margin-top:30px; margin-left:20px">
            
               <asp:HiddenField ID="HiddenField1" runat="server"   Value="1"/>
        
                   <h1><strong style="color:black">Entity Fm 6.0</strong></h1>    
                   <hr />
           
    <table>
                   
            
     <tr>
                    <td><span style="color:black">Package Name</span><br />
                    <asp:TextBox ID ="tb_name"  runat="server" Width="200px"   /><br />
        
      
                    </td>

                   <td><span style="margin-left:25px; color:black">Reward<br /></span>
                    <span style="margin-left:25px">
                        <asp:DropDownList ID="dd3" runat="server" Width="200px" DataTextField="reward">
                        

                                                   </asp:DropDownList></span> <br />
       
                   </td>
                     
                    <td><span style=" margin-left:25px; color:black">Remarks</><br /></span>
                    <span style="margin-left:25px"><asp:TextBox ID="tb_remarks"  runat="server" Width="410px" /></span> <br />
      
                        
                    </td>
                     
                    
                  
         </tr>
       
                          
     <tr>   
         <td>     
        <br /> <asp:Button ID="BT_submit" runat="server"  Text="Submit" style="border-radius:5px" Height="35px" Width="80px"   OnClick="BT_submit_Click" BackColor="#3366CC" BorderColor="#3366CC" ForeColor="White"  />
       
     </td>
         <td>
           <br /><asp:Button ID="BT_update" runat="server"   Text="Update" style="border-radius:5px; margin-left:1.5em" Height="35px" Width="80px"   OnClick="BT_update_Click" BackColor="#3366CC" BorderColor="#3366CC" ForeColor="White" />
        
         </td>
              <td><br /><asp:Button ID="BT_delete" runat="server" Text="Delete" style=  " margin-left:1.6em;    border-radius:5px" Height="35px" Width="80px"  OnClick="BT_delete_Click" BackColor="#3366CC" BorderColor="#3366CC"  ForeColor="White" /> </td>
       
         <asp:FileUpload runat="server" ID="file1"  BackColor="#3366CC" BorderColor="#3366CC"  ForeColor="White"   />
         </tr>



    </table>
               
               </div>

    <div style="margin-top:30px; margin-left:20px">
        
         <asp:gridview runat="server" ID="Gv8" AutoGenerateColumns="False" BackColor="#3366CC" GridLines="Both"  
             BorderColor="#3366CC"  OnRowCancelingEdit="Gv8_RowCancelingEdit"   OnRowEditing="Gv8_RowEditing"
 OnRowDeleting="Gv8_RowDeleting" OnRowUpdating="Gv8_RowUpdating"   BorderStyle="None" BorderWidth="1px" CellPadding="3" Width="80%" DataKeyNames="tbl_id">
     
        <Columns>
         <%--               <asp:BoundField DataField="package_name" HeaderText="Package Name" /> 
                          <asp:BoundField DataField="reward" HeaderText="Reward" /> 
                          <asp:BoundField DataField="remarks" HeaderText="Remarks" /> --%>
            <asp:TemplateField HeaderText="Package Name" >
                                 <ItemTemplate>
                                     <%# Eval("package_name") %>

                                 </ItemTemplate>
                                 <EditItemTemplate>
                                     <asp:TextBox ID="TB_pack" runat="server" Text='<%# Eval("package_name") %>'  />

                                 </EditItemTemplate>

                             </asp:TemplateField>
                            
         
          <asp:TemplateField HeaderText="Reward">
                                
                                <ItemTemplate>

                         <%# Eval("reward") %>

                                  </ItemTemplate>
                   
                                <EditItemTemplate>
               <asp:dropdownlist ID="dd2" runat="server"   DataTextField="reward" DataValueField="reward"  >

                                      </asp:dropdownlist>
                                 
                                                              
                               
                                </EditItemTemplate>


                            </asp:TemplateField>
         
         
         
         
         
         <asp:TemplateField HeaderText="Remarks" >
                                 <ItemTemplate>
                                     <%# Eval("remarks") %>

                                 </ItemTemplate>
                                 <EditItemTemplate>
                                     <asp:TextBox ID="TB_remark" runat="server" Text='<%# Eval("remarks") %>'  />

                                 </EditItemTemplate></asp:TemplateField>

             <asp:ImageField DataImageUrlField="Path" HeaderText="Image" />
       
                      <asp:CommandField ButtonType="Link" ShowEditButton="true" ShowDeleteButton="true" ItemStyle-Width="150"/>
     
                         </Columns>
             <FooterStyle BackColor="#3366CC" ForeColor="#3366CC" />
             <HeaderStyle BackColor="#3366CC" Font-Bold="True" ForeColor="Window" />
             <PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
             <RowStyle BackColor="White" ForeColor="#003399" />
             <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
             <SortedAscendingCellStyle BackColor="#EDF6F6" />
             <SortedAscendingHeaderStyle BackColor="#0D4AC4" />
             <SortedDescendingCellStyle BackColor="#D6DFDF" />
             <SortedDescendingHeaderStyle BackColor="#002876" />
         </asp:gridview>
           
                
                             
           
        


    </div>

</asp:Content>

Answer 1

User-939850651 posted

Hi sanam13,

First, you have to make sure that you have created a folder named Images in the server path to save the uploaded images.

Just like this:

Second, you could refer to this article.

Best regards,

Xudong Peng

Answer 2

User-1647172364 posted

hello sir all the code run well but when not any image select  from choose file then they were also path error here my requirement is when not choose file option select then the code run without error   

Aspx

<%@ Page Title="" Language="C#" MasterPageFile="~/Site1.Master" AutoEventWireup="true" CodeBehind="Test lang.aspx.cs" Inherits="WebApplication14.Test_lang" %>
<asp:Content ID="Content1" ContentPlaceHolderID="title" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="head" runat="server">

    
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="body" runat="server">


     <div style="margin-top:30px; margin-left:20px">
        

                    
               
                 
                  <h1><strong style="color:black">Test Language</strong></h1>    
                   <hr />

                  <table>
                      
            

     <tr>
                    <td><span style="color:black">First Name</span><br />
                    <asp:TextBox ID ="tb_name"  runat="server" Width="200px"   /><br />
        
      
                    </td>

                   <td><span style="margin-left:25px; color:black">Last Name<br /></span>
                    <span style="margin-left:25px"><asp:TextBox ID="tb_last" runat="server"  Width="200px" /></span> <br />
      
                   </td></tr>
                      <tr>
         <td>
              <br /><asp:FileUpload ID="fileupload" runat="server" BackColor="lightblue" />
         </td>            
    </tr>

                                    <tr>
        
       <td><br />
         <asp:Button ID="BT_submit" runat="server"  Text="Submit" style="border-radius:5px" Height="35px" Width="80px"   OnClick="BT_submit_Click" BackColor="#3366CC" BorderColor="#3366CC" ForeColor="White"  /></td>
       </tr>
</table>
         </div>
         <div style="margin-top:30px; margin-left:50px">
             <asp:GridView runat="server" AutoGenerateColumns="false"  ID="Gv1" Width="60%" >                 
        <Columns>
                         <asp:BoundField DataField ="first_name" HeaderText ="First Name" />
                    
            <asp:BoundField DataField ="last_Name" HeaderText ="Last Name" />
            
    <asp:ImageField DataImageUrlField="image" HeaderText="Image" ControlStyle-Height="95" ControlStyle-Width="170" ItemStyle-HorizontalAlign="Center">
                
                
            </asp:ImageField>
                 
                
            
        </Columns>
                         
                                <EditRowStyle BackColor="#2461BF" />
                         
                     <FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True" />
                     <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>
                
                      
          
             </div>
           
    
                  
         
</asp:Content>


c#


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.IO;
using System.Configuration;

namespace WebApplication14
{
    public partial class Test_lang : System.Web.UI.Page
    {
        SqlCommand cmd = new SqlCommand();
        SqlConnection con = new SqlConnection();
        string connection = System.Configuration.ConfigurationManager.AppSettings["con"].ToString();

        public void EstablishConnection(string storeprocedure)
        {
            con.ConnectionString = connection;
            cmd.Connection = con;
            cmd.Connection.Open();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = storeprocedure;
        }

        public void CloseConnection()
        {
            cmd.Connection.Close();
            cmd.Connection.Dispose();
            con.Close();
        }

        public void FillGridview()
        {
            SqlDataAdapter adp = new SqlDataAdapter("select * from test_lang", connection);
            adp.SelectCommand.CommandType = CommandType.Text;
            DataTable DT = new DataTable();
            adp.Fill(DT);

            Gv1.DataSource = DT;
            Gv1.DataBind();


        }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)


            {
                FillGridview();
            }

        }

       
        protected void BT_submit_Click(object sender, EventArgs e)
        {

            string fileName = Path.GetFileName(fileupload.PostedFile.FileName);
            string filePath = "~/img/" + fileName;

            fileupload.PostedFile.SaveAs(Server.MapPath(filePath));


            EstablishConnection("sp_insert_test_lang");
            cmd.Parameters.Add("@first_name", SqlDbType.NVarChar, 100).Value =  tb_name.Text;
            cmd.Parameters.Add("@last_name", SqlDbType.NVarChar, 100).Value = tb_last.Text;
            cmd.Parameters.Add("@Remarks", SqlDbType.VarChar, 100).Value = "1";
            cmd.Parameters.Add("@date_time", SqlDbType.VarChar, 100).Value = System.DateTime.Now.ToString();
            cmd.Parameters.Add("@Status", SqlDbType.VarChar, 100).Value = "1";
            cmd.Parameters.Add("@By_whom", SqlDbType.VarChar, 100).Value = Session["username"].ToString();
            cmd.Parameters.Add("@image", SqlDbType.NVarChar, 255).Value = filePath  ;

           
            try { cmd.ExecuteNonQuery(); }


            catch (Exception ex1) { Response.Write("<script language=javascript>alert('" + ex1.Message.ToString() + ".')</script>"); }
            
            
            CloseConnection();

           
            FillGridview();
        }

        

    }
}   

Answer 3

User-939850651 posted

Hi sanam13,

When the image file is not selected, this problem will indeed occur.

If you don’t want to make such an error, you can judge whether the uploaded file exists in the click event, and then make the corresponding operation according to the judgment result.

It just like this:

protected void BT_submit_Click(object sender, EventArgs e)
        {   
            //judge whether the uploaded file exists
            if (fileupload.HasFiles)
            {
                string fileName = Path.GetFileName(fileupload.PostedFile.FileName);
                string filePath = "~/img/" + fileName;

                fileupload.PostedFile.SaveAs(Server.MapPath(filePath));

                EstablishConnection("sp_insert_test_lang");
                cmd.Parameters.Add("@first_name", SqlDbType.NVarChar, 100).Value = tb_name.Text;
                cmd.Parameters.Add("@last_name", SqlDbType.NVarChar, 100).Value = tb_last.Text;
                cmd.Parameters.Add("@Remarks", SqlDbType.VarChar, 100).Value = "1";
                cmd.Parameters.Add("@date_time", SqlDbType.VarChar, 100).Value = System.DateTime.Now.ToString();
                cmd.Parameters.Add("@Status", SqlDbType.VarChar, 100).Value = "1";
                cmd.Parameters.Add("@By_whom", SqlDbType.VarChar, 100).Value = Session["username"].ToString();
                cmd.Parameters.Add("@image", SqlDbType.NVarChar, 255).Value = filePath;

                try { cmd.ExecuteNonQuery(); }

                catch (Exception ex1) { Response.Write("<script language=javascript>alert('" + ex1.Message.ToString() + ".')</script>"); }

                CloseConnection();

                FillGridview();
            }
            else {
                Response.Write("<script>alert('Please upload the image file.');</script>");
            }
        }

You could also refer to this document too.

Best regards,

Xudong Peng

Answer 4

User-1647172364 posted

Sir i meant to say that i also have other textbox in this page and i want that when even i don't select any image from choose file only i insert data through textboxes

then also insertion would be occur. If i doesn't choose file then error occur is "System.IO.DirectoryNotFoundException: 'Could not find a part of the path 'F:\Asp Projects\WebApplication14\WebApplication14\img\'.'" 

Answer 5

User-939850651 posted

Hi sanam13,

Well, as you said in this case, even if you do not select the image file, data will be inserted into the data table, then this error will occur when filling the Gridview.

Then you need to judge whether there is an uploaded image file. If not, you also need to set the corresponding parameter to empty and insert it into the data table.

The ImageField control on the page uses the NullDisplayText or NullImageUrl property to set its default text or image.

Please refer to below code:

Code behind:

public partial class DisplayPic : System.Web.UI.Page
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conStr"].ConnectionString);
        SqlDataAdapter da;
        DataSet ds;
        SqlCommand cmd;
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void upload_Click(object sender, EventArgs e)
        {
            if (fileupload.HasFiles)
            {
                try
                {
                    upload.Text = "Upload";
                    string filename = Path.GetFileName(fileupload.PostedFile.FileName);
                    fileupload.SaveAs(Server.MapPath("~/Images/" + filename));
                    con.Open();
                    cmd = new SqlCommand("insert into Image_Details (ImageName,Image) values(@ImageName,@Image)", con);
                    cmd.Parameters.AddWithValue("@ImageName", filename);
                    cmd.Parameters.AddWithValue("@Image", "~/Images/" + filename);
                    cmd.ExecuteNonQuery();
                    da = new SqlDataAdapter("select * from Image_Details", con);
                    ds = new DataSet();
                    da.Fill(ds);
                    gdImage.DataSource = ds;
                    gdImage.DataBind();
                }
                catch (Exception ex)
                {
                    upload.Text = ex.Message;
                }
            }
            else
            {
                // have no upload image file
                con.Open();
                cmd = new SqlCommand("insert into Image_Details (ImageName,Image) values(null,null)", con);
                cmd.ExecuteNonQuery();
                da = new SqlDataAdapter("select * from Image_Details", con);
                ds = new DataSet();
                da.Fill(ds);
                gdImage.DataSource = ds;
                gdImage.DataBind();
            }
        }
    }

Page code:

<form id="form1" runat="server">
        <h3 style="color: #0000FF; font-style: italic">Display Image in GridView Using ASP.NET</h3>
        <div>
            <asp:FileUpload ID="fileupload" runat="server" />
            <br />
            <asp:Button ID="upload" runat="server" Font-Bold="true" Text="Upload" OnClick="upload_Click" />
            <br />
            <br />
        </div>
        <div>
            <asp:GridView runat="server" ID="gdImage" HeaderStyle-BackColor="Tomato" AutoGenerateColumns="false">
                <Columns>
                    <asp:BoundField DataField="ImageId" HeaderText="ImageId" />
                    <asp:BoundField DataField="ImageName" HeaderText="ImageName" />
                    <asp:ImageField DataImageUrlField="Image"  NullDisplayText="There is no image" HeaderText="Image"></asp:ImageField>
                </Columns>
            </asp:GridView>
        </div>
    </form>

Result:

Best regards,

Xudong Peng

Answer 6

User-1647172364 posted

Sir i have applied your given code else part is working but if part not working when i am uploading image from choose file image is not inserting. 


protected void BT_submit_Click(object sender, EventArgs e)
        {
            
            if (fileupload.HasFiles)
            {
                try
                {
                    BT_submit.Text = "Submit";
                    string fileName = Path.GetFileName(fileupload.PostedFile.FileName);
                    string filePath = "~/img/" + fileName;

                    fileupload.PostedFile.SaveAs(Server.MapPath(filePath));


                    EstablishConnection("sp_insert_test_lang");
                    cmd.Parameters.Add("@first_name", SqlDbType.NVarChar, 100).Value = tb_name.Text;
                    cmd.Parameters.Add("@last_name", SqlDbType.NVarChar, 100).Value = tb_last.Text;
                    cmd.Parameters.Add("@Remarks", SqlDbType.VarChar, 100).Value = "1";
                    cmd.Parameters.Add("@date_time", SqlDbType.VarChar, 100).Value = System.DateTime.Now.ToString();
                    cmd.Parameters.Add("@Status", SqlDbType.VarChar, 100).Value = "1";
                    cmd.Parameters.Add("@By_whom", SqlDbType.VarChar, 100).Value = Session["username"].ToString();
                    cmd.Parameters.Add("@image", SqlDbType.NVarChar, 255).Value = filePath;

                }



                catch (Exception ex)
                {
                    BT_submit.Text = ex.Message;
                }
                CloseConnection();

                FillGridview();
                


            }
            else
           

                {
                    EstablishConnection("sp_insert_test_lang1");
                    cmd.Parameters.Add("@first_name", SqlDbType.NVarChar, 100).Value = tb_name.Text;
                    cmd.Parameters.Add("@last_name", SqlDbType.NVarChar, 100).Value = tb_last.Text;
                    cmd.Parameters.Add("@Remarks", SqlDbType.VarChar, 100).Value = "1";
                    cmd.Parameters.Add("@date_time", SqlDbType.VarChar, 100).Value = System.DateTime.Now.ToString();
                    cmd.Parameters.Add("@Status", SqlDbType.VarChar, 100).Value = "1";
                    cmd.Parameters.Add("@By_whom", SqlDbType.VarChar, 100).Value = Session["username"].ToString();
                    cmd.Parameters.Add("@image", SqlDbType.NVarChar, 255).Value = "null";


                    FillGridview();
                
            }
        }