How to convert byte array to image & display in GridView

Question

Hi All, My webservice will return the bytearray. Now, I need to convert it into Image & i need to display that image into GridView control. How can i do this? Thanks in Advance

Satyapriya Nayak · Answer

Hi Siva, Try this... Untitled Page Employee Details Name Address Image File Text="Insert" onclick="btn_insert_Click"> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Byte_array_gridview { public partial class _Default : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; protected void btn_insert_Click(object sender, EventArgs e) { insertdata(); } public void insertdata() { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select count(*)from employee where name='" + txtname.Text + "'"; com = new SqlCommand(str, con); int count = Convert.ToInt32(com.ExecuteScalar()); con.Close(); if (count > 0) { lblMessage.Text = "Sorry! you can't take this username"; } else { lblMessage.Text = "You can take this username"; con.Open(); int len = Upload.PostedFile.ContentLength; byte[] pic = new byte[len + 1]; Upload.PostedFile.InputStream.Read(pic, 0, len); str = "insert into employee values (@name,@address,@photo)"; com = new SqlCommand(str, con); com.Parameters.AddWithValue("@name", txtname.Text); com.Parameters.AddWithValue("@address", txtaddress.Text); com.Parameters.AddWithValue("@photo", pic); com.ExecuteNonQuery(); con.Close(); lblMessage.Text = "Employee Details Inserted Successfully!"; Response.Redirect("employee.aspx"); con.Close(); } } } } Untitled Page using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Drawing; using System.Drawing.Imaging; using System.IO; using System.Data.SqlClient; namespace Byte_array_gridview { public partial class image : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select photo from employee where id = '" + Request.QueryString["id"] + "'"; com = new SqlCommand(str, con); MemoryStream stream = new MemoryStream(); byte[] image = (byte[])com.ExecuteScalar(); stream.Write(image, 0, image.Length); Bitmap bitmap = new Bitmap(stream); Response.ContentType = "image/Jpeg"; bitmap.Save(Response.OutputStream, ImageFormat.Jpeg); con.Close(); stream.Close(); } } } Untitled Page Id : Name : Address : '/> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Byte_array_gridview { public partial class employee : System.Web.UI.Page { string strConnString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string str; SqlCommand com; protected void Page_Load(object sender, EventArgs e) { SqlConnection con = new SqlConnection(strConnString); con.Open(); str = "select id,name,address from employee"; com = new SqlCommand(str, con); SqlDataReader reader; reader = com.ExecuteReader(); GridView1.DataSource = reader; GridView1.DataBind(); con.Close(); } } } Thanks

How to convert byte array to image & display in GridView

Answers (1)