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 idnameaddress from employee; com = new SqlCommand(str con); SqlDataReader reader; reader = com.ExecuteReader(); GridView1.DataSource = reader; GridView1.DataBind(); con.Close(); } } } Thanks