How to call FileUpload in Gridview cell in C# asp.net?

Question

0.00/5 (No votes)

See more:

Hello,

I want to update image using Edit,Update using C# asp.net gridview,
So, How to call FileUpload in Gridview cell in C# asp.net?

I placed FileUpload in Gridview Cell but when we call image using file upload, it,s blank image going in to the variable, I am using this code for Update Image:-

C#

FileUpload Image1 = (FileUpload)GVStartCampaignDetails.Rows[e.RowIndex].FindControl("Image1");// Image it's filling blank in Image Field.
        string filename = System.IO.Path.GetFileName(Image1.FileName);
        Session["UpdateImage"] = filename;
Image1.SaveAs(Server.MapPath("Templates/") + filename + ".jpg");
                    SqlConnection con = new SqlConnection(connectionString);
                    con.Open();
                    SqlCommand cmd = new SqlCommand("procUpdateImage", con);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.Add("@EmailId", SqlDbType.NVarChar).Value = EmailId;
cmd.Parameters.Add("@ImagePath", SqlDbType.NVarChar).Value = Session["UpdateImage"].ToString();
cmd.ExecuteNonQuery();
con.close();

Please Help me.

Thanks in Advance.

Posted 14-Jan-14 19:10pm

ankit.agg1984

Updated 14-Jan-14 19:11pm

Gitanjali Singh

v3

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Answer 1 · 2014-01-14T19:14:00

Solution 1

Check this.

Upload file in each row of asp.net gridview[^]
How to upload a file in gridview when it is in EDIT mode.[^]

Posted 14-Jan-14 19:14pm

Karthik_Mahalingam

Comments

[no name] 15-Jan-14 1:55am

Hi, Karthik

I am using this code for image update in gridview but blank image it's getting in this (Image1) variable.
Please help me.

GridViewRow row = GVDetails.Rows[e.RowIndex];
//FileUpload Image1 = (FileUpload)GVDetails.Rows[e.RowIndex].FindControl("Image1");
FileUpload Image1 = row.Cells[5].FindControl("Image1") as FileUpload;
if (Image1 != null && Image1.HasFile)
{
Image1.SaveAs(Server.MapPath("Templates/") + Image1.FileName + ".jpg");
}

Karthik_Mahalingam 15-Jan-14 1:58am

Image1 is the name of fileupload control ??

Siva Hyderabad 14-Mar-14 7:54am

+5

[no name] 15-Jan-14 3:47am

Yes

Karthik_Mahalingam 15-Jan-14 3:50am

can u post your entire grid code,
aspx as well code behind..
i have to trace it.

[no name] 15-Jan-14 4:07am

My Grid Code:-
<asp:UpdatePanel ID="UpdatePanel2" runat="server">
<contenttemplate>
<asp:GridView ID="GVDetails" runat="server" CssClass="dataTable"
RowStyle-CssClass="odd_row" AlternatingRowStyle-CssClass="even_row"
AutoGenerateColumns="false"
onrowcancelingedit="GVDetails_RowCancelingEdit"
onrowediting="GVDetails_RowEditing"
onrowupdating="GVDetails_RowUpdating"
onrowdatabound="GVDetails_RowDataBound">
<alternatingrowstyle cssclass="even_row">
<columns> <asp:TemplateField HeaderStyle-CssClass="dataTableHeader" HeaderText="S.No.">
<itemtemplate>
<%# ((GridViewRow)Container).RowIndex + 1%>

<HeaderStyle CssClass="dataTableHeader" />

<asp:TemplateField HeaderStyle-CssClass="dataTableHeader" HeaderText="Image">
<itemtemplate>
<asp:Image ID="GVImage" runat="server" ImageUrl='<%#string.Format("~/Templates/{0}",Eval("ImagePath"))%>' style=" width:100px; height:100px; float:none; text-align:center; margin:0px;" />

<HeaderStyle CssClass="dataTableHeader" />
<edititemtemplate>
<asp:FileUpload ID="Image1" runat="server" />
<asp:RegularExpressionValidator ID="REFUImage" runat="server" Text="*" ToolTip="Image formate only" ControlToValidate="Image1" ValidationExpression="[a-zA-Z0_9].*\b(.jpeg|.JPEG|.jpg|.JPG|.jpe|.JPE|.png|.PNG|.mpp|.MPP|.gif|.GIF)\b">

<asp:TemplateField HeaderStyle-CssClass="dataTableHeader">
<edititemtemplate>
<asp:ImageButton ID="imgbtnUpdate" CommandName="Update" runat="server" ImageUrl="~/images/update.png" ToolTip="Update" Height="20px" Width="20px" />
<asp:ImageButton ID="imgbtnCancel" runat="server" CommandName="Cancel" ImageUrl="~/images/Cancel.png" ToolTip="Cancel" Height="20px" Width="20px" />

<itemtemplate>
<asp:ImageButton ID="imgbtnEdit" CommandName="Edit" runat="server" ImageUrl="~/images/Edit.png" ToolTip="Edit" Height="20px" Width="20px" />

<HeaderStyle CssClass="dataTableHeader" />

<rowstyle cssclass="odd_row">

<Triggers>
<asp:AsyncPostBackTrigger ControlID="GVDetails" />
</Triggers>

My Code Behind Code:-

protected void GVDetails_RowEditing(object sender, GridViewEditEventArgs e)
{
Image img = GVStartCampaignDetails.Rows[e.NewEditIndex].FindControl("GVImage") as Image;
imgEditPath = img.ImageUrl;
GVStartCampaignDetails.EditIndex = e.NewEditIndex;
BindStartYourCampaignDetails();
}

protected void GVDetails_RowUpdating(object sender, GridViewUpdateEventArgs e)
{

GridViewRow row = GVStartCampaignDetails.Rows[e.RowIndex];
FileUpload Image1 = row.Cells[5].FindControl("Image1") as FileUpload;
if (Image1 != null && Image1.HasFile)
{
Session["UpdateImage"] = Image1.FileName + ".jog";
Image1.SaveAs(Server.MapPath("Templates/") + Session["UpdateImage"].ToString());
}
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand cmd = new SqlCommand("procUpdateImage", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmailId", SqlDbType.NVarChar).Value = EmailId;
cmd.Parameters.Add("@ImagePath", SqlDbType.NVarChar).Value = Session["UpdateImage"].ToString();
cmd.ExecuteNonQu

Karthik_Mahalingam 15-Jan-14 5:00am

GVDetails
gridview name is different..

[no name] 15-Jan-14 5:03am

Now is Right.

Karthik_Mahalingam 15-Jan-14 5:11am

seems ur code is not formated properly..
after this line <asp:UpdatePanel ID="UpdatePanel2" runat="server">
<contenttempalte>
should come..

some thing is missing pls check it...

TrushnaK · Answer 2 · 2014-01-14T19:53:00

Refer below links for retriving images and show in grid:-
http://www.c-sharpcorner.com/UploadFile/0c1bb2/uploading-and-displaying-images-from-database-using-Asp-Net/[^]
http://www.aspdotnet-suresh.com/2011/01/how-to-insert-images-into-database-and.html[^]
http://aspsnippets.com/Articles/Upload-images-to-folder-and-display-uploaded-images-in-ASPNet-GridView-using-C-and-VBNet.aspx[^]

Gitanjali Singh · Answer 3 · 2014-01-14T19:15:00

In aspx

ASP.NET

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="FileUploadInsideGridView.aspx.cs" Inherits="FileUploadInsideGridView" %>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
            DataKeyNames="PersonID" DataSourceID="SqlDataSource1"
            onrowcommand="GridView1_RowCommand" >
            <Columns>
                <asp:BoundField DataField="FirstName" HeaderText="FirstName"
                    SortExpression="FirstName" />
                <asp:BoundField DataField="LastName" HeaderText="LastName"
                    SortExpression="LastName" />
                <asp:TemplateField HeaderText="Upload">
                    <ItemTemplate>
                        <asp:FileUpload ID="FileUpload1" runat="server" EnableViewState="true" />
                        <asp:Button ID="saveBtn" runat="server"
                            CommandArgument="<%# Container.DataItemIndex%>" CommandName="save"
                            Text="OK"/>
                    </ItemTemplate>
                </asp:TemplateField>
                <%--<asp:ButtonField ButtonType="Button" CommandName="save" Text="Save"/>--%>
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:SomeConnectionString %>"
            SelectCommand="SELECT [PersonID], [FirstName], [LastName] FROM [Person]">
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

In Code behind

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class FileUploadInsideGridView : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName.Equals("save")) 
        {
            //GridView Row Index
            int rowIndex = int.Parse( e.CommandArgument.ToString().Trim());

            // ID of the Current Row
            String ID = GridView1.DataKeys[rowIndex].Values["PersonID"].ToString().Trim();

            //File Upload Instance of the Current Row
            FileUpload fileUpload = (FileUpload)GridView1.Rows[rowIndex].FindControl("FileUpload1");

            //File
            System.IO.Stream stream = fileUpload.PostedFile.InputStream;
            
            //File Length
            int length = fileUpload.PostedFile.ContentLength;
            
            //Content of the File
            byte[] data = new byte[length];
            
            //Fill data
            stream.Read(data, 0, length);

            //File Extension
            String extension = System.IO.Path.GetExtension(fileUpload.PostedFile.FileName);
        }
    }
}

Refer:
http://forums.asp.net/t/1627633.aspx[^]
how to manage file upload control inside grid view how to get the path of file in file upload[^]

This may help.

How to call FileUpload in Gridview cell in C# asp.net?

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0