System.Byte[] showing in Gridview Column in ASP.NET C#

Hi All,

I am facing a discrepancy in loading image into gridview column in asp.net using c#.

My gridview has action with/without images. Action with images showing System.Byte[]. Please find screenshot below.

I don't want to show System.Byte[] in the column. I already wrote a .css class to assign a icon to that column control. That image is displaying . I need your help to remove System.Byte[] and only to show that icon.

Here is my table where store image:-

SQL stored procedure i using to bind the gridview

SELECT tblActionDetaills.FID,tblVilla.VillaName,tblActionDetaills.VID,tblActionDetaills.AdminUserID,
tblImageDetails.Image,
Convert(varchar(20),EventDate,103) as EventDate,
REPLACE(SUBSTRING(CONVERT(nvarchar(128),EventDate, 109), 12 , 128),':000', ' ') as EventTime,
Description,Comment FROM tblActionDetaills inner join tblVilla on tblVilla.VID=tblActionDetaills.VID
inner join tblUserLogin on tblUserLogin.UserID=tblVilla.UserID
left join tblImageDetails on tblImageDetails.FID=tblActionDetaills.FID
WHERE tblUserLogin.UserID=@UserID
order by Convert(datetime,EventDate,103) desc

.aspx code where binding in gridview

<asp:TemplateField ItemStyle-HorizontalAlign="Left" HeaderText="View Image" HeaderStyle-HorizontalAlign="Center">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" CssClass="lnkbtnSelect" CommandName="LoadImage" Text='<% # Eval("Image")%>' CommandArgument='<%#Eval("FID")%>' runat="server">View Imageasp:LinkButton>
ItemTemplate>
asp:TemplateField>

And C# code where I wrote to bind gridview

using (SqlDataAdapter adapter = new SqlDataAdapter("LoadVillaDetailsForGridForCustomer", clsConObj.sqlCon))
{
adapter.SelectCommand.Parameters.Add("@UserID", SqlDbType.SmallInt).Value = Session["UserID"].ToString();
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dtbl = new DataTable();
adapter.Fill(dtbl);
{
grdConstructionDetails.DataSource = dtbl;
grdConstructionDetails.DataBind();
grdConstructionDetails.HeaderRow.TableSection = TableRowSection.TableHeader; //added by sai on 09/04/2019 for lbl
lblTotalRecords.Text = Convert.ToInt16(dtbl.Rows.Count).ToString();
}
}

Dear All,

This is to inform that the issue has been solved by c# code. Thank you all for the support.

aspx. code

And c# code:-

Dear All,

Now I changed the image path. before I used to insert image directly into table. Now I saving image into a file path and the same path will save into table.

This is how my table values storing now:-

And when I binding the filepath value into the gridview link button, I getting like this.

Please note my requirment:-

1. grid has to display icon only if there is a associated image for the particular action.( which I achieved by binding) .

You can see action with blank in image column.

2) The link button in view Image column doing the important activities like open boostrap modal and modal fetching row Id based images, comment etc..

If I remove code Text='<%#Bind("Filepath")%>'from the Link button , all row column will display with the icon.

Is there any way to eliminate/replace the binding text?

I want to eliminate the text below '\\403-PC\Save Path\.. and to display icon displaying in the back.

without if condition check.I mean comment the if condition and look what happens

Dear Laxmidhar Sahoo,

When I debug the code, line string headerText = e.Row.Cells[5].Text; always is NULL and the breakpoint not going inside the if condition

if (headerText == "View Image")

{

}

perhaps you do not define the cell named Image1

(e.Row.FindControl("Image1") as System.Web.UI.WebControls.Image).ImageUrl = imageUrl;

Dear Laxmidhar Sahoo,

I have changed the cell number and still I not able to recognize that particular column.

if (e.Row.RowType == DataControlRowType.DataRow)

{

DataRowView dr = (DataRowView)e.Row.DataItem;

string headerText = e.Row.Cells[5].Text;

if (headerText == "View Image")

{

string imageUrl = "data:image/jpg;base64," + Convert.ToBase64String((byte[])dr["Image"]);

(e.Row.FindControl("Image1") as System.Web.UI.WebControls.Image).ImageUrl = imageUrl;

}

follow the code

"FileUpload1" runat="server" />
"btnUpload" runat="server" Text="Upload" OnClick="Upload" />
"gvImages" runat="server" AutoGenerateColumns="false" OnRowDataBound="OnRowDataBound">
"Id" HeaderText="Image Id" />
"Name" HeaderText="Name" />
"Image">
"Image1" runat="server" />
"dialog" style="display: none">

I hope you understand that System.Byte[] is getting printed because of the linkbutton has text property which is mapped to Image Field (byte array object). But, what you are saying is , you want to keep the link button with the text field yet you don't want to show the System.Byte[] text which is confusing me. Maybe, I am not understanding your requirements clearly.

Dear Mr. Subburaj,

I know that the System.Byte is showing becuase of that piece code. That code kept for user to understand that particular action has a image.(its a client requirment)

I need to keep only the icon in that column and need to remove System.Byte[] in gridview column.

System.Byte is showing because the in the linkbutton, you have set the text with Text='<% # Eval("Image")%>' which shows thats value. If you remove that, it wont print it.

View Image

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bineeshcp Viswanath7y ago
Dear All,

This is to inform that the issue has been solved by c# code. Thank you all for the support.

aspx. code

And c# code:-

0
Bineeshcp Viswanath7y ago
Dear All,

Now I changed the image path. before I used to insert image directly into table. Now I saving image into a file path and the same path will save into table.

This is how my table values storing now:-

And when I binding the filepath value into the gridview link button, I getting like this.

Please note my requirment:-

1. grid has to display icon only if there is a associated image for the particular action.( which I achieved by binding) .

You can see action with blank in image column.

2) The link button in view Image column doing the important activities like open boostrap modal and modal fetching row Id based images, comment etc..

If I remove code Text='<%#Bind("Filepath")%>'from the Link button , all row column will display with the icon.

Is there any way to eliminate/replace the binding text?

I want to eliminate the text below '\\403-PC\Save Path\.. and to display icon displaying in the back.

0
Laxmidhar Sahoo7y ago
without if condition check.I mean comment the if condition and look what happens
0
Bineeshcp Viswanath7y ago
Dear Laxmidhar Sahoo,

When I debug the code, line string headerText = e.Row.Cells[5].Text; always is NULL and the breakpoint not going inside the if condition

if (headerText == "View Image")
{
}
0
Laxmidhar Sahoo7y ago
perhaps you do not define the cell named Image1

(e.Row.FindControl("Image1") as System.Web.UI.WebControls.Image).ImageUrl = imageUrl;
0
Bineeshcp Viswanath7y ago
Dear Laxmidhar Sahoo,

I have changed the cell number and still I not able to recognize that particular column.

if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView dr = (DataRowView)e.Row.DataItem;
string headerText = e.Row.Cells[5].Text;
if (headerText == "View Image")
{
string imageUrl = "data:image/jpg;base64," + Convert.ToBase64String((byte[])dr["Image"]);
(e.Row.FindControl("Image1") as System.Web.UI.WebControls.Image).ImageUrl = imageUrl;
}
}
0
Laxmidhar Sahoo7y ago
follow the code
"FileUpload1" runat="server" />
"btnUpload" runat="server" Text="Upload" OnClick="Upload" />

"gvImages" runat="server" AutoGenerateColumns="false" OnRowDataBound="OnRowDataBound">

        "Id" HeaderText="Image Id" />
        "Name" HeaderText="Name" />
        "Image">

                "Image1" runat="server" />




"dialog" style="display: none">
protected void OnRowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView dr = (DataRowView)e.Row.DataItem;
string headerText = e.Row.Cells[2].Text; // just changed the index of cells
if (headerText == "Image") {
string imageUrl = "data:image/jpg;base64," + Convert.ToBase64String((byte[])dr["Data"]);
(e.Row.FindControl("Image1") as Image).ImageUrl = imageUrl;
}
}
}