Displaying image from binnary data

Question

Dear all I have a varbinary(max) column in sql server database table and i am fetching this data..I am inserting image in this column How can display image in image control or in any other way

Krishna Garad · Answer

the way create httphandller class in your application and like bellow. public class ImageHandle : IHttpHandler { public void ProcessRequest (HttpContext context) { string imageid = context.Request.QueryString["ImID"]; SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlcn"].ConnectionString); connection.Open(); SqlCommand command = new SqlCommand("Select ImageColumn From TblImages Where ImageId="+imageid, connection); SqlDataReader dr = command.ExecuteReader(); if (dr.Read()) { context.Response.BinaryWrite((Byte[])dr[0]); //context.Response.BinaryWrite((Byte[])dr[1]); } connection.Close(); context.Response.End(); } public bool IsReusable { get { return false; } } } and in aspx page provide Image controls imageurl property like Image1.ImageUrl="~/ImageHandle.ashx?ImID="+someid;

Krishna Garad · Answer

As per me for no of images you should use gridview to display the images. That means you need not to create no of links. You should use datalist also to do this.

Mayur Gujrathi · Answer

Dear krishna As per my question your answer is correct but i want to do slight change in this.. When i am fetching image i dont to display iy directly.. what ever no of images i am getting i want to create as much of link button dynamically and on click of i want to generate pop up to display paricular image.. Please help

Displaying image from binnary data

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)