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

Question

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 Image</asp: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();
}
}

Bineeshcp Viswanath · Answer

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:-

Bineeshcp Viswanath · Answer

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=' '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.

Laxmidhar Sahoo · Answer

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

Bineeshcp Viswanath · Answer

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") { }

Laxmidhar Sahoo · Answer

perhaps you do not define the cell named Image1 (e.Row.FindControl("Image1") as System.Web.UI.WebControls.Image).ImageUrl = imageUrl;

Bineeshcp Viswanath · Answer

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; } }

Laxmidhar Sahoo · Answer

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; } } }

Jeeva Subburaj · Answer

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.

Bineeshcp Viswanath · Answer

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.

Jeeva Subburaj · Answer

System.Byte is showing because the in the linkbutton, you have set the text with Text=' ' which shows thats value. If you remove that, it wont print it. ' CommandArgument=' ' runat="server">View Image