how to insert images into database and how to retrieve and bind images to gridview using asp.net (or) save and retrieve images from database using asp.net

By: Suresh Dasari Jan 2, 2011

Introduction

Here I will explain how insert and retrieve images from database and how to bind images to gridview using asp.net.

Description:

I have worked on one social networking site at that time we save all the images in to directory folder and we save image path into database at that time I got idea to implement concept like inserting images into database and retrieving the images from database and binding images to gridview using asp.net for that we need follow below steps

First Design table like this in your SQL Server database and give name as Image

Column Name	Data Type	Allow Nulls
ImageId	Int(set identity property=true)	No
ImageName	Varchar(50)	Yes
Image	image	Yes

After that Design your aspx page like this

<title>Inserting images into databse and displaying images with gridview</title>

.Gridview

{

font-family:Verdana;

font-size:10pt;

font-weight:normal;

color:black;

width:500px;

}

</style>

</head>

<body>

<div>

<table>

<tr>

<td>

Image Name:

</td>

<td>

<asp:TextBox ID="txtImageName" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

Upload Image:

</td>

<td>

<asp:FileUpload ID="fileuploadImage" runat="server" />

</td>

</tr>

<tr>

<td>

</td>

<td>

<asp:Button ID="btnUpload" runat="server" Text="Upload" onclick="btnUpload_Click" />

</td>

</tr>

</table>

</div>

<div>

<asp:GridView ID="gvImages" CssClass="Gridview" runat="server" AutoGenerateColumns="False"

HeaderStyle-BackColor="#7779AF" HeaderStyle-ForeColor="white">

<asp:BoundField HeaderText = "Image Name" DataField="imagename" />

<asp:TemplateField HeaderText="Image">

<asp:Image ID="Image1" runat="server" ImageUrl='<%# "ImageHandler.ashx?ImID="+ Eval("ImageID") %>' Height="150px" Width="150px"/>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

</form>

</body>

</html>

After that add using System.IO; using System.Data.SqlClient; and using System.Configuration; namespaces and write the following code in code behind

string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindGridData();

}

/// <summary>

/// btnUpload_Click event is used to upload images into database

/// </summary>

/// <param name="sender"></param>

/// <param name="e"></param>

protected void btnUpload_Click(object sender, EventArgs e)

{

//Condition to check if the file uploaded or not

if (fileuploadImage.HasFile)

{

//getting length of uploaded file

int length = fileuploadImage.PostedFile.ContentLength;

//create a byte array to store the binary image data

byte[] imgbyte = new byte[length];

//store the currently selected file in memeory

HttpPostedFile img = fileuploadImage.PostedFile;

//set the binary data

img.InputStream.Read(imgbyte, 0, length);

string imagename = txtImageName.Text;

//use the web.config to store the connection string

SqlConnection connection = new SqlConnection(strcon);

connection.Open();

SqlCommand cmd = new SqlCommand("INSERT INTO Image (ImageName,Image) VALUES (@imagename,@imagedata)", connection);

cmd.Parameters.Add("@imagename", SqlDbType.VarChar, 50).Value = imagename;

cmd.Parameters.Add("@imagedata", SqlDbType.Image).Value = imgbyte;

int count = cmd.ExecuteNonQuery();

connection.Close();

if (count == 1)

{

BindGridData();

txtImageName.Text = string.Empty;

ScriptManager.RegisterStartupScript(this, this.GetType(), "alertmessage", "javascript:alert('" + imagename + " image inserted successfully')", true);

}

/// <summary>

/// function is used to bind gridview

/// </summary>

private void BindGridData()

{

SqlConnection connection = new SqlConnection(strcon);

SqlCommand command = new SqlCommand("SELECT imagename,ImageID from [Image]", connection);

SqlDataAdapter daimages = new SqlDataAdapter(command);

DataTable dt = new DataTable();

daimages.Fill(dt);

gvImages.DataSource = dt;

gvImages.DataBind();

gvImages.Attributes.Add("bordercolor", "black");

}

Here we need to restrict user to upload only image formats in file upload control for that validaiton check this post how to validate file type in file upload control using javascript

After Completion of above code we need to add HTTPHandler file to our project to retrieve images from database because we save our images in binary format getting the binary format of data from database it’s easy but displaying is very difficult that’s why we will use HTTPHandler to solve this problem.

Here HTTPHandler is a simple class that allows you to process a request and return a response to the browser. Simply we can say that a Handler is responsible for fulfilling requests from the browser. It can handle only one request at a time, which in turn gives high performance.

Right Click on your project add new HTTPHandler.ashx file and give name as ImageHandler.ashx and write the following code in pagerequest method like this

string strcon = ConfigurationManager.AppSettings["ConnectionString"].ToString();

public void ProcessRequest(HttpContext context)

{

string imageid = context.Request.QueryString["ImID"];

SqlConnection connection = new SqlConnection(strcon);

connection.Open();

SqlCommand command = new SqlCommand("select Image from Image where ImageID=" + imageid, connection);

SqlDataReader dr = command.ExecuteReader();

dr.Read();

context.Response.BinaryWrite((Byte[])dr[0]);

connection.Close();

context.Response.End();

}

Here don’t forgot to set the connection string in web.config file here I am getting database connection from web.config file for that reason you need to set the connectionstring in web.config file like this

</connectionStrings>

Demo

Download sample code attached

If you enjoyed this post, please support the blog below. It's FREE!

Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS

Subscribe by Email

224 comments :

«Oldest ‹Older 1 – 200 of 224 Newer› Newest»

zia said...: Good but i prefer storing images in filesystem cuz my webhost provides limited database space; January 5, 2011 at 4:50 AM
Suresh Dasari said...: hi zia thanks for you suggestion i have written article to save images in filesystem and display the images from folder check this link
http://aspdotnet-suresh.blogspot.com/2011/03/how-to-save-images-into-folder-and.html; March 22, 2011 at 2:17 AM
Anonymous said...: hi,
i wanted to know how can we delete a row from gridview, so that is gets deleted from the database also..; April 30, 2011 at 2:49 PM
Suresh Dasari said...: hi,
check this link here i explained clearly how to delete gridview rows using asp.net
http://aspdotnet-suresh.blogspot.com/2011/01/how-to-delete-records-in-gridview-with.html; April 30, 2011 at 7:10 PM
Donzo said...: Any ideas how ti put data into images that are moving around a web page ? its for non-profit dcollier8@netzero.net; July 13, 2011 at 8:35 PM
Ger said...: do i need to change the connection string? im still having errors; August 16, 2011 at 1:02 AM
Suresh Dasari said...: Hi Ger,
Yes you have to change the connection string here i used my db connection you should give your db connection in web.config file; August 16, 2011 at 1:05 AM
Anonymous said...: hi suresh

any idea to delete the row containing images in the datagridview; August 17, 2011 at 5:00 AM
manju said...: any idea to delete the row containing images in the datagridview, its giving error in the http handler; August 17, 2011 at 5:03 AM
Suresh Dasari said...: hi manju,
Check this post to delete gridview records

http://www.aspdotnet-suresh.com/2011/01/how-to-delete-records-in-gridview-with.html

Here we are inserting images in database so if we delete record in database that is enough. Here you need to remember one point that is after delete record again rebind your gridview with latest data.; August 17, 2011 at 5:13 AM
manju said...: thanks suresh

i got it; August 17, 2011 at 11:29 PM
Ted said...: i try to use the delete gridview record for the images but it does not work. any ideas about this error?

ArgumentOutOfRangeException
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index; August 18, 2011 at 2:18 AM
ramesh said...: Hi suresh,

I am working with Image web gallery so I am trying to use jquery uploadify to upload images and store them in folder and at the same time I need to save them to sql Server database.But I am failing in doing that Can you do me an article regarding that.So that I need to resize the Images while uploading an save them in seperate foldder and the original one's in another folder.And I need to display those Images after loading using list view or gridview as you did.if you give me any ideas that will be very helpful to me.; September 5, 2011 at 5:46 AM
ramesh said...: This is my handler code:

public class Upload : IHttpHandler {

public void ProcessRequest (HttpContext context) {
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
try
{
HttpPostedFile postedFile = context.Request.Files["Filedata"];

string savepath = "";
string tempPath = "";
tempPath = System.Configuration.ConfigurationManager.AppSettings["FolderPath"];
//tempPath = context.Request["folder"];
savepath = context.Server.MapPath(tempPath);
string filename = postedFile.FileName;
if (!Directory.Exists(savepath))
Directory.CreateDirectory(savepath);

postedFile.SaveAs(savepath + @"\" + filename);
//Fileupload.UploadToDatabase(savepath + @"\" + filename);

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ImagesConnectionString"].ToString());
//Open the database connection
con.Open();
//Query to insert images path and name into database
SqlCommand cmd = new SqlCommand("Insert into Image(ImagePath) values(@ImagePath)", con);
//Passing parameters to query
cmd.Parameters.AddWithValue("@ImagePath", filename);
cmd.ExecuteNonQuery();
//Close dbconnection
con.Close();

context.Response.Write(tempPath + "/" + filename);

//context.Response.Write(filename);
context.Response.StatusCode = 200;
}
catch (Exception ex)
{
context.Response.Write("Error: " + ex.Message);
}

}

public bool IsReusable {
get {
return false;
}
}; September 5, 2011 at 5:48 AM
Anonymous said...: hii...sir
h r u...
your site is very nice.....
sir i hv used the asp.net3.5..and when we try to add the httphandler file to my project .....then we can no got up this file in ADD new items template ....from where i can add it to my project; October 9, 2011 at 10:39 AM
Robin Raghav said...: sir i have an exception in httphandlarfile.........at line(SqlDataReader dr=Connection.ExecuteReade();).....Exception is "incorrect syntax near"=" ";; October 9, 2011 at 12:03 PM
Anonymous said...: hi, this code is working fine if we use asp.net empty website, but if we are using asp.net website template we are not able to call .ashx file itself, please help me out , thank you; October 11, 2011 at 8:23 PM
ahobul said...: hi, this code is working fine if we use asp.net empty website, but if we are using asp.net website template we are not able to call .ashx file itself, please help me out , thank you; October 11, 2011 at 8:24 PM
Anonymous said...: Why would I be getting a box with red X instead of the images?; October 19, 2011 at 7:22 PM
manju said...: hi suresh

give me some ideas(some reference links) to create table dynamically and adding the rows also dynamically with prevoius rows data.............; October 21, 2011 at 4:35 AM
sonu said...: hi this is sonu ,i have used this code,codes are running bt images are not comes across the name field,it is unable to show image in data list.except it all things are working properly.i used to generic handler,i am using windows7,visual studio 2010,and .net4.0.whats the problem plz suggest me.
sonu new delhi.; October 30, 2011 at 11:17 AM
Shambhu said...: Thanks very much suresh jee your website is very helpfull for developers.; November 4, 2011 at 12:28 AM
Shambhu said...: Will you please tell me in bigger project which image save method we should use in database using image database or using folder upload classical method. Please describe the difference in performance while comparing both.; November 4, 2011 at 12:30 AM
indrajeet said...: Great. It is too much helpful for me.; November 9, 2011 at 11:04 PM
Jay Patel said...: i want upload image and save in database then i want to give a link to each image for example :- when i click on img1 it redirect page on its detail page and when i click on img2 it redirect page to its owan page.; November 21, 2011 at 8:04 PM
felix said...: i need display video from database in asp.net; November 24, 2011 at 9:20 PM
SIMANTA said...: Hi suresh

I am simanta, i am a web developr.I am stucking with one problem. Please help me sir,
I want to dispaly images dynamically in gridview and simultaneously i also want to put some data in 2 textbox. When image change the value inside the textbox should also change. The image should change in a regular time interval.

With Regards
Simanta Jyoti Medhi
+919538804164; November 27, 2011 at 9:29 PM
Anonymous said...: i am Ajay Yadav. I am trying to upload an image in my website folder and saved its path in my database. I search it on internet but not able to do this. Plz help me. And send me at akylucknow@gmail.com; December 13, 2011 at 1:28 AM
Suresh Dasari said...: @Ajay Yadav
check this post to save images in folder and images path in database
http://www.aspdotnet-suresh.com/2011/03/how-to-save-images-into-folder-and.html; December 13, 2011 at 1:32 AM
Ujjwal said...: Hello Suresh Sir..

I really liked the Article. I read too many articles about saving images in DB but this is the simplest and easy to understand. thanks.

Also i have a query how can i add java script ( like On mouse over a particular image the image should be shown in another panel) to the images that i am retrieving in my Datalist from database.

I have the java script to do it but don't know how to do it on images that are dynamically retrieved.; December 15, 2011 at 2:54 AM
yuva said...: hi sir,
If i am insert the picture into the asp web page ,i can able to write the text in next line only.if i want to write the text into the side of picture means what can i do?...; December 18, 2011 at 10:52 PM
yuva said...: hi sir,
If i am insert the picture into the asp web page ,i can able to write the text in next line only.if i want to write the text into the side of picture means what can i do?...; December 18, 2011 at 10:53 PM
kiran kumar said...: i wrote the code step by step as you said, but it is showing error "ImageID could not be null"

2) i changed the property value of table as ImageID set to null values true. and i debug it , then it is storing images showing message "saved successfully" but if i check in table , imageID is showing empty.
3) and in gridview control, the image control doesn't showing the stored image, it is showing like breaking image control.
why i am getting these errors? give me the solution pls; December 24, 2011 at 3:34 AM
Suresh Dasari said...: @kiran,
In table design i said we need to set the Identity Property true for ImageID column once we set whenever insert record automatically ImageID column fill with value(like 1,2,3...) otherwise you need to enter values manually. I think you forgot to set the Identity Property for ImageID coulumn and check your images path.; December 24, 2011 at 4:16 AM
suresh said...: how can we write mouse click event for the datagrid images column.
my requirement after clicking that image it has to open in a new window in full size; December 27, 2011 at 3:19 AM
Suresh Dasari said...: @suresh
check this post it will helps you to solve your problem here i explained clearly how to show image in lightbox whenever we click on image in gridview
http://www.aspdotnet-suresh.com/2011/03/display-gridview-images-with-lightbox.html; December 27, 2011 at 3:24 AM
Anonymous said...: hello sir,
ur all articles r very nice n helpful
sir i want to upload multiples images against one UserID in the database and show all images in gridview. i want add button for multiple uploads
can u send me the demo code on my id manindra.tayal@gmai.com
plz help me; December 27, 2011 at 8:40 AM
nagendra said...: hi sir,
ur blog is very helpful.
how to edit records in gridview & upload images using insert&update commands in asp.net?
plz help me?; December 30, 2011 at 9:55 PM
Nityanand Yadav said...: Nityanand Yadav said

I am regular user of your website . This really Helpful... . i have no word to explain it.; January 7, 2012 at 10:45 PM
kunal said...: may i use this on vb.net project then how i add http handler page or which page or method is used instead of http handler; January 15, 2012 at 11:22 AM
Anonymous said...: hello suresh,
I am sushil. I am able to store the image in database in varbinary format. but the problem is while retrievin it. I am using linq to entity style. so will be there any change in the logic of retrieving. i have tried context.response.binarywrite but its not working; January 22, 2012 at 5:57 AM
chandan said...: iam chanchal singh
my problem is that all my user not having img in our database only some user have img so that if img is not in our database than only default img is show and img is present then their img show.; January 24, 2012 at 5:27 AM
Anonymous said...: i m akash
hi your whole code is working properly but the problem is inserted images are not shown in the gridview..; January 25, 2012 at 4:51 AM
Praveen said...: Sir i want that image should be compressed while uploading in database.; February 2, 2012 at 10:42 PM
shyam said...: hi sir... i am very new to the asp.. presently i am working with the gridview..can we insert data into the gridview with out any ado .net architecture and taking autogenerate colums=false...if yes can you please help me?; February 5, 2012 at 9:39 AM
Anonymous said...: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server); February 5, 2012 at 11:13 PM
Anonymous said...: sir,Im new to .net,i compiled the above source dnt get any error but while running it says
Server Error in '/' Application.

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

Line 14: public partial class WebForm5 : System.Web.UI.Page
Line 15: {
Line 16: string strcon = ConfigurationManager.AppSettings["ConnectionString"].ToString();
Line 17: protected void Page_Load(object sender, EventArgs e)
Line 18: {; February 9, 2012 at 9:04 AM
aarthi said...: sir am getting the following error when i compile the above code please help me
Both DataSource and DataSourceID are defined on 'gvImages'. Remove one definition.; February 10, 2012 at 12:17 AM
Anonymous said...: What Namespace should i add to get the configuration Manager; February 15, 2012 at 10:58 PM
surendar said...: i have used this code ,image is saved but it is not retrirv.

it will be displayed error message like.

Error 1 Type 'Handler' does not inherit from 'System.Web.IHttpHandler'. F:\surendar outlook\WebSite5\Handler.ashx 1

what should i do.; February 22, 2012 at 3:09 AM
Himanshu Pandey said...: Hi suresh
i m a newbie in asp.net..I am a avid user and a great fan of yours,love to read your posts.Please tell me how to give this functionality of inserting comments and displaying them one by one,as is done above..please i have to implement it in my project
Regards
Himanshu; February 23, 2012 at 11:48 PM
Suresh Dasari said...: @Himanshu Pandey..
check this post here i explained clearly how to save and display comments

http://www.aspdotnet-suresh.com/2012/01/repeater-control-example-in-aspnet.html; February 24, 2012 at 1:24 AM
Himanshu Pandey said...: Hii suresh
Thanks for your reply.I m much elated and thrilled when i saw ur reply for me.Thanks
I gone through your post,but i also need to show small profile pictures of the ppl along with their comments???Please do help me
thanks again
regards
Himanshu; February 24, 2012 at 11:44 AM
Himanshu Pandey said...: This comment has been removed by the author.; February 24, 2012 at 1:00 PM
Himanshu Pandey said...: Oh suresh,its done.Its 2:30 am morning and i am still Gearing up with your post,trying to add profile of users along with their comments from database,and finally its done.
Thanks Suresh for your for your quick reply,which helped me to reach my way.This bespeaks your kindly heart.
One more thing i wanna ask you,though i practiced the same in sql server Db,but i am using mysql db in my project,so the same code will work??what is the datatype to be used in mysql for storing images?
please always keep in touch.
Regards
Himanshu; February 24, 2012 at 1:05 PM
Ajay Patil said...: sir i'm unable to retrive images ...there is no error ...gridview images are blank; February 29, 2012 at 1:39 AM
poonam said...: Hi,
your code is excellent but its can't work with web application got error fileupload control doesn't exist in current content.; March 13, 2012 at 3:36 AM
poonam said...: Hi,

can u please tell me how to give transaction of image ie i want to do the slideshow with effect

pls help me; March 13, 2012 at 3:39 AM
Jonathan said...: Simply create datatable with image column and add image to it

dtMain.Columns.Add("ImageColumn", typeof(Image));

dtMain.Rows.Add(Image.FromFile(photopath + "1.jpg"));

Download full code at http://tablegridview.blogspot.in; March 15, 2012 at 1:06 AM
Suresh Dasari said...: @poonam..
this sample i did using web application only it will work as web application and for slideshow effect check this post http://www.aspdotnet-suresh.com/2011/12/jquery-lightbox-image-slideshow-gallary.html; March 15, 2012 at 5:43 AM
Unknown said...: lokesh said....

it's gud but can u say simple way to insert a img from sql db and retrive from sql db; March 17, 2012 at 10:12 AM
rakesh b.k said...: Thanks mate :); March 22, 2012 at 12:30 AM
Kodexpression said...: sir can u tell me how to rotate the ImageButton Control....????; March 24, 2012 at 6:51 AM
Anonymous said...: hello sir i m getting error that, "The name 'ScriptManager' does not exist in the current context". plz sir tel me solution for this; March 24, 2012 at 10:54 PM
asmita said...: hello sir my image is not getting display.........plz sir tel me solution on it......as soon as possible; March 24, 2012 at 11:53 PM
jigu said...: can u give me ur contc no.; March 28, 2012 at 12:59 AM
Pooja said...: hello,....Please tell me how to give connectionstring....thank you...; March 29, 2012 at 10:28 PM
Suresh Dasari said...: @Pooja..
i updated post by adding connectionstring also please check it once.; March 29, 2012 at 11:14 PM
Anonymous said...: Hi Suresh,
I am pradip
In gridview I want to show 3 Columns.In first column (Cell) image,In 2nd column(Cell) one linkbutton and information and in 3rd column (Cell) informtion(static).
I am able to insert image into 1st column
but unable to insert 2 columns info
Please give me solution as soon as possible
Thanks in advance.; March 31, 2012 at 10:50 AM
trinadh said...: hi suresh this artical helps me lot thanks..n i need more explanation about images and videos storing in databases please help me...; April 3, 2012 at 2:28 AM
Anonymous said...: MY IMAGES ARE NOT GETTING DISPLAYED CAN PLEASE GUIDE ON THIS ?; April 13, 2012 at 12:39 AM
Seema said...: Why these pics wont display.... i really exhausted.. plz guys somebody help me ... i have followed the steps exactly.. and downloaded these attached file and compared it with mine .. but it still not working ..

the code i working properly but the images don't display .. it shows red "X" instead.

plzzzzzzzzzzzz help me.; April 25, 2012 at 1:35 PM
Seema said...: finally i found the solution..

for those who r facing a problem with displaying the image .
you just have to add a new webForm and do the retrieve process through it.
don't combine both of codes(store image and retrieve image) together in the same form..

copy this code for binding the data in the gridview, and past it in the form load of the new webForm(to retrieve the image) and design a gridview as specified above ... instead of writting the function of binding the data for the gridview in the form of storing the images.

that's it .. hope i was clear in explaining it; April 25, 2012 at 4:11 PM
Anonymous said...: i have used this code,codes are running bt images are not comes across the name field,it is unable to show image in data list.except it all things are working properly.i am using windows7,visual studio 2010,and .net4.0.whats the problem plz suggest me.; May 7, 2012 at 1:22 PM
Unknown said...: Image is not store in sql database as a binary data i want to store in data base as well as in a folder. do you have any idea about that ?; May 12, 2012 at 11:12 AM
Suresh Dasari said...: @Sunil Acharya....
check this post to save images to folder
http://www.aspdotnet-suresh.com/2011/03/how-to-save-images-into-folder-and.html; May 12, 2012 at 10:14 PM
adi said...: i am able to upload the files into server but i am unable to view the images in the browser.
instead of image it is displaying [x] in red color; May 17, 2012 at 11:32 PM
adi said...: @seema can u upload ur file and share the link here; May 17, 2012 at 11:43 PM
adi said...: @suresh
can u tell me how to display only single image based on drop downlist selction; May 17, 2012 at 11:49 PM
Suresh Dasari said...: @adi...
if you are getting cross mark means please check your handler code whether you are getting data from database correctly or not and to display image based on dropdownlist selection means you need to pass image id then get those record details from database and display it on your page.; May 18, 2012 at 12:23 AM
adi said...: @suresh
<%@ WebHandler Language="C#" Class="ImageHandler" %>

using System;
using System.Web;
using System.IO;
using System.Data.SqlClient;
using System.Configuration;

public class ImageHandler : IHttpHandler {

string con = ConfigurationManager.AppSettings["ConnectionString"].ToString();
public void ProcessRequest(HttpContext context)
{
string imageid = context.Request.QueryString["ImageID"];
SqlConnection connection = new SqlConnection(con);
connection.Open();
SqlCommand command = new SqlCommand("select Image from Image where ImageID=" + imageid, connection);
SqlDataReader dr = command.ExecuteReader();
dr.Read();
context.Response.BinaryWrite((Byte[])dr[0]);
connection.Close();
context.Response.End();
}

public bool IsReusable {
get {
return false;
}
}

}; May 18, 2012 at 1:49 AM
Anonymous said...: Hi I getting this error what should i do now ? antone expain this error.........!NullReferenceException Was Unhandled by User Code; May 18, 2012 at 5:53 AM
Anonymous said...: Hi suresh,

Iam getting error while loading gridview

http://aspdotnet-suresh.blogspot.com/2011/01/how-to-delete-records-in-gridview-with.html...

kindly assist me..

Naveenkumar chemutu; May 26, 2012 at 5:18 AM
Arun.P said...: Hai suresh thank u so much.; June 14, 2012 at 3:20 AM
Arun.P said...: suresh, how to upload video files and how to view that videos in asp; June 14, 2012 at 3:25 AM
Anonymous said...: Thank you so much mate it had been really helpful god bless you; June 14, 2012 at 1:41 PM
vivek said...: there is no error in my code but image is not showing in gridview it dispalys as a blank.; June 15, 2012 at 2:44 AM
vivek said...: what is the best way of sending cintrols values from one page to next page and next page to other page by button click and submit it on this page..(as like registration of more than one page )..plz rep it.........; June 15, 2012 at 2:49 AM
Anonymous said...: Hi sir,I am clicking on upload button i am getting an error ,Server error / website application HTTP 400 Bad request can you please suggest me how to remove this error?; June 22, 2012 at 8:52 AM
Junz Tan said...: Hi suresh,
After I upload the image, it cannot display the image at the gridview. Please help. thank you.; June 25, 2012 at 8:04 PM
SAGAR BHOGALE said...: how to upload video and save it in database and retrive from database and play. please give me the code in c# asp.net my email id= bhogale.sagar1@gmail.com; June 26, 2012 at 4:50 AM
Aswini said...: hi sir
why we are giving ImageUrl='<%# "ImageHandler.ashx?ImID="+ Eval("ImageID") %>' this url in grid view i cant get it will u explain with any other logic.; July 1, 2012 at 8:17 AM
Aswini said...: hi sir
why we are giving ImageUrl='<%# "ImageHandler.ashx?ImID="+ Eval("ImageID") %>' this url in grid view i cant get it will u explain with any other logic.; July 1, 2012 at 8:18 AM
Kodexpression said...: Sir how to show binary image from database in repeater?; July 5, 2012 at 12:03 PM
Anonymous said...: hai suresh
in grid view you are selecting only two columns what about image column; July 21, 2012 at 12:06 AM
Anonymous said...: sir,
i have an problem
when any user form fillup his/her registration purpose, he/she also have to uploaded his/her picture and when he/she logged in the account then he/she can see his/her image as the home section.
i want to make profile pic
can u tell me sir...............
how i will do it; August 6, 2012 at 2:03 AM
Anonymous said...: hi; August 7, 2012 at 9:29 AM
Anonymous said...: Sir,the above code is running error free,but I am unable to view the images.I am only viewing the image name but not the image in the gridview.Please help Suresh sir.; August 9, 2012 at 12:45 AM
Life with Saheli said...: Sir,the above code is running error free,but I am unable to view the images.I am only viewing the image name but not the image in the gridview.Please help Suresh sir.; August 9, 2012 at 12:47 AM
Anonymous said...: i got error like this "object must iconvertible" what is the solution for this....; August 16, 2012 at 10:59 AM
jitenderkapil said...: hey how to retrive particular binary image from SQL server in asp.net using C#. when i search image throu text box.; August 20, 2012 at 1:40 AM
Anonymous said...: Can you make video tutorial for this; September 9, 2012 at 4:29 AM
Anonymous said...: Dear Suresh Sir my problem is upload Photoimages in KB.MB like bank apply online form it will only genarate 50MB give the full source and cs and other problem photo image in dimension...; September 18, 2012 at 9:21 AM
Anonymous said...: HOW TO SEE IMAGE FROM NORTHWIND DATABASE IN ASP.NET USE C#,PLZ HELP; September 27, 2012 at 3:31 AM
Unknown said...: Hi it is very nice article but when run this code take me this is error
"
Cannot insert the value NULL into column 'ImageId', table 'DressDB .dbo.Image'; column does not allow nulls. INSERT fails.
The statement has been terminated."
please what i can do
thanks alot; October 2, 2012 at 11:46 PM
Anonymous said...: creating tabs dynamicaly using juery; October 8, 2012 at 6:19 AM
Anonymous said...: Hi Suresh,
Keep the Good work going.

I have a similar DB as you have shown except in my assignment I have to use varchar type to store Img path rather then the img it self in the database.

Now using the Grid itself I have to Add the add the img by browsing to the img path and then on "OK" I have to show the img in the grid rather then its path.
A hint that I had got from my Faculty is use a File Upload Control.
Now I am really saturated trying to figure it out...; October 15, 2012 at 12:08 PM
Anonymous said...: its really wonderful buddy thanx a lot; October 30, 2012 at 5:04 AM
ၾကည္ျမန္မာ said...: Sureah,

What happened to me? When I create your code, I can input image to database, but they are not come out.

When I downloaded and ran your code directly (a little change for database connection), I got 8 errors concern with image name textbox, upload box and gridview are not current context.

When I run update, delete, edit program, I can run directly according your code.

Any help for me, pls.; November 14, 2012 at 1:02 AM
a said...: dfs; November 18, 2012 at 8:58 PM
Unknown said...: you can do 1 thing that somehow try to get the file extension of an uploading file and compare it using if statement
if(extnsn=="jpg")
{
code to be executed
}
try that .....well i am a beginner but dis could work.....
if u find it useful then comment; November 25, 2012 at 7:59 AM
Unknown said...: how to send session(or)querystring data from one page to multiple pages in asp.net; December 5, 2012 at 2:13 AM
shanti said...: Can you send more tutorial for this..... plss; December 20, 2012 at 7:48 AM
Unknown said...: Hii Suresh Sir..
this is jp..
can you please tell me how to use the httphandler in our project because when I am retrieving he image from database in the grid view there is no error but it is not showing the image.
please reply ASAP....
thank you in advance.......; December 25, 2012 at 12:22 AM
kannan said...: This comment has been removed by the author.; December 26, 2012 at 2:42 AM
kannan said...: i need one help suresh,can you please tell how to use print option work in firefox...; December 26, 2012 at 2:43 AM
Mahaboob said...: Hellow sir,
I implemented ur code but im not getting accurate result. i.e im getting imagename, imageid, but the image is not displaying. In gridview the image is displaying in error image format.
Please give me answer what is the reason? and what is the solution. please reply me. thank u somuh.; December 28, 2012 at 3:28 AM
Unknown said...: Sir i am unable to understand that how to add httphandler in my project kindly help me in this regard; December 29, 2012 at 12:19 AM
Anonymous said...: can u tell how to create stored procedure; December 30, 2012 at 7:14 PM
Unknown said...: Hi it is very nice article but u have to update one thing there is a generic handler behalf of httphandler in asp.net 4.0 . and really good article keep it up; January 9, 2013 at 11:46 PM
Anonymous said...: hi sir,
i am raju i want to retrieve image from gridview to image control in asp.net plz help me; January 24, 2013 at 4:27 AM
Unknown said...: Hi ...Sir

I took support of your code ...Its nice

I am facing difficulties to show image in gridview

Grid view only displayed Image name not image; February 3, 2013 at 3:43 AM
Unknown said...: hi ,
i m sivi . i having employee login and logout table using oracle.
here login and logout time problem. ex
21/01/2013 9:15:10 AM
21/01/2013 6:45:23 PM
21/01/2013 6:46:41 PM. this is prob. i need first entry and last entry then calculate the working hour . ple help me. i m eager to waiting for your replay; February 5, 2013 at 11:12 PM
Saurav said...: HI Suresh. This post was very helpful for me for my project. Now i have a query that u r passing parameter like "cmd.Parameters.Add("@imagedata", SqlDbType.Image).Value = imgbyte;" on the page itself but i have created a class and i want to pass the imgbyte parameter to class like "objClass.imgbyte" but it is giving an error. So can u pls help me how to pass parameter of byte[] type to class; February 13, 2013 at 1:47 AM
Anonymous said...: Hi Suresh,
Your site is really good.I wanted to know how to display the column value from database into the label box after inserting successfully.; February 17, 2013 at 9:01 PM
Anonymous said...: This comment has been removed by a blog administrator.; February 18, 2013 at 10:03 AM
Anonymous said...: I'm really enjoying the theme/design of your site. Do you ever run into any browser compatibility problems? A few of my blog audience have complained about my site not operating correctly in Explorer but looks great in Chrome. Do you have any recommendations to help fix this issue?

Here is my page credit cards; February 18, 2013 at 10:53 AM
Anonymous said...: This comment has been removed by a blog administrator.; February 19, 2013 at 6:27 AM
Anonymous said...: This comment has been removed by a blog administrator.; February 20, 2013 at 2:59 AM
Anonymous said...: This comment has been removed by a blog administrator.; February 20, 2013 at 4:50 AM
Anonymous said...: This comment has been removed by a blog administrator.; February 20, 2013 at 10:21 AM
Kesavakumar said...: hi Suresh,

Your code is working fine, except image. Instead of grid view I'm using data-list in that i'm getting all data even for image url also like this("ImageHandler.ashx?ImID=5"), data what it is fetching is correct but image is not getting displayed through image handlerfile. This image handler file not get fired only in this datalist. same datahandler I used to display image once i upload a image by that time it is working fine, please guide me how to display image in datalist.; February 27, 2013 at 4:12 AM
Anonymous said...: this example is very useful; March 4, 2013 at 2:44 AM
neha sharma said...: Hi dear,, you are too good i am just a beginner and your posts helps me a lot and easy to understand too ..thanks a lot really u r too good..; March 6, 2013 at 3:47 AM
Unknown said...: hi.. i want to know how to match an image with a stored image in the database.; March 8, 2013 at 11:55 PM
Anonymous said...: How To update Binary data image in database...????PLz help me out; March 18, 2013 at 11:52 PM
Anonymous said...: sir ,i have used this code but sir still problem havebeen arise.when we run the webpage it insert the image in database sometimes but it doesn't show imgaes in gridview,no error is occur at the uploading the image

Regards,
ashutosh kumar; March 19, 2013 at 11:28 PM
Naina said...: Thanx for the idea; March 20, 2013 at 4:32 AM
m said...: images uploded but not showing in grid view please help; March 23, 2013 at 1:29 PM
Rohan Tangade said...: Hi Sir.
I want to create a search box for students,means suppose i type 'Rohan' then it must show all students whose names ara rohan in asp c#...
Thanking you
Rohan; March 26, 2013 at 3:17 AM
Unknown said...: hi sir i want to compare two car model wise like audi a4 and swift dezire... how i compare??? plz give response..yhank u in advance sir; March 27, 2013 at 12:28 PM
nandy said...: I don know what to say, but one this is Suresh, thank you verymuch, bcoz of your site, so many of us learnt many things. ppl who are outt there plz learn from this site, you ll make yo task easier.

Once again, Thank You.; March 30, 2013 at 12:16 AM
Anonymous said...: Will the code work without these lines?
HttpPostedFile img = fileuploadImage.PostedFile;
img.InputStream.Read(imgbyte, 0, length);

Bcoz we are not using img anywhere in the code?; March 31, 2013 at 12:00 AM
Unknown said...: hello sir,
after inserting the images i was unable to view the grid view. Help me.; April 2, 2013 at 12:52 PM
Anonymous said...: Error occured when ConfigurationManager is used..; April 15, 2013 at 11:13 AM
Anonymous said...: hello sir,
Images are not visible in gridview only the names of images are visible..why so?; April 15, 2013 at 12:07 PM
Anonymous said...: Hello,
Can't we put the fileUpload control in the gridView and acces it????
Am not able to bing the image dynamically in gridview by directly putting the fileUpload control in grid View... Sir Please can you help me...

My Code is...; April 18, 2013 at 11:33 PM
Anonymous said...: April 18, 2013 at 11:35 PM
Unknown said...: image are uploading but not Displaying on page...

an error was there saying that:--

SqlException was Unhandled by user code
Incorrect syntax near '='.

at Imagehandler.ashx.cs file at the line of:-

dr = command.ExecuteReader();

please give me solution; April 20, 2013 at 3:31 AM
Ani said...: Thanks a ton...Your site is really helpful. Finally able to upload images using ASP .NET.

But I can't understand the GridView part...Do you have a tutorial of how to display images in datagridview control in ASP .NET?; April 23, 2013 at 9:42 AM
Ramesh Babu said...: thanks...
And
I have one question...
How to divide image into blocks ?; April 25, 2013 at 2:13 AM
Gaurav Agarwal said...: how can i create image gallery?
plz tell me, my id is gauravpansari1991@gmail.com; April 25, 2013 at 4:33 AM
joshila said...: Hi sir,how can i create image gallery?how to edit or update image in database??pls help me...; May 16, 2013 at 3:44 AM
Anonymous said...: Hello! Sir, do you know how to fetch the latest image uploaded to the database to be displayed on the homepage?; May 19, 2013 at 11:12 PM
Anonymous said...: your blog is very useful... Thank you..; May 20, 2013 at 4:20 AM
him2cool said...: hi suresh why this problem comes- Cannot insert the value NULL into column 'ImageId', table 'ImageDemo.dbo.Image'; column does not allow nulls. INSERT fails.
The statement has been terminated.; May 20, 2013 at 9:22 PM
Bharat said...: hii bro.
it showing error "server tag is not well formed"
at; May 24, 2013 at 1:23 AM
Anonymous said...: hello sir, there is a problem when retrieve images from database. also you did not explain what namespace should be use. Please tell me the above code and also tell using HttpHandler file does need configure in web.config file. thanks; June 1, 2013 at 2:20 AM
Anonymous said...: Hello Sir,
I have a problem. I am developing a website using .NET 3.5(lang C#) and WAMP server MySQL as a backend. I want to store and retrieve images from database. I can store the images in database successfully but I am not able to retrieve the images. Plz help me in that sir.

I am a regular follower of your blog. Plz help me.

Thank you very much in advance.; June 6, 2013 at 2:20 AM
Anonymous said...: Hi, i want to save file from front end to database (varbinary field) and retreive using object of the businness class(using hashtable to pass data); June 24, 2013 at 3:56 AM
Unknown said...: can u suggest me..
how to add image into gridview from folder ...
please give me solution for this
thank you; June 24, 2013 at 11:22 AM
Anonymous said...: sir i am tried this code but the image is not displayed in grid view because u could not explain about imagehandler.ashx in this part so plz update it
thank u sir; July 2, 2013 at 4:04 AM
Unknown said...: hi suresh sir , here i want to export images in excel format but my images are stored in binary format in database , how can i get it using c# code ............................................................................................................................; July 3, 2013 at 5:16 AM
Unknown said...: ArgumentOutOfRangeException
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
every time getting the same error plz help me suresh.
why exactely this error is coming?; July 10, 2013 at 2:57 AM
Anonymous said...: This comment has been removed by the author.; July 16, 2013 at 9:26 PM
Anonymous said...: This comment has been removed by a blog administrator.; July 16, 2013 at 9:28 PM
Mathi said...: Instead of loading the DataTable from DB I'm hard coding it and tried to display images which is not working for me. The images are not loading for me. Below is the only code change I've made. Please help me.

dt.Columns.Add("imagename");
dt.Columns.Add("ImageID");

DataRow dr = dt.NewRow();
dr["imagename"] = "Image1";
dr["ImageID"] = @"D:\Mathi_Working\01816_Backup\Mathi\Images\9.gif";

dt.Rows.Add(dr);

DataRow dr1 = dt.NewRow();
dr1["imagename"] = "Image2";
dr1["ImageID"] = @"D:\Mathi_Working\01816_Backup\Mathi\Images\HereSmiley.JPG";
dt.NewRow();
dt.Rows.Add(dr1);; July 30, 2013 at 5:09 AM
Anonymous said...: I like much your website. Thanx for valuable coding.; August 4, 2013 at 10:11 PM
Anonymous said...: Nice blog.. Thanks for providing the information how to insert images into database and how to retrieve and bind images to gridview using asp.net and how save and retrieve images from database using asp.net. Really it is a very useful blog!!

Convert Image; August 5, 2013 at 12:36 AM
Anonymous said...: hey
hope you are fine. your code of retrieving image is not working fine for me.images are being displayed in the cells of data table.; August 6, 2013 at 6:50 AM
Anonymous said...: i am using following code to insert image in database........image path is saved in database and also image is saved in picture folder.........but i dont know how to fetch image from database using similar code
if u can please help me

protected void Button1_Click(object sender, EventArgs e)
{

con.Open();
if (FileUpload1.HasFile)
{
String photo = "~/picture/" + FileUpload1.FileName;
FileUpload1.SaveAs(MapPath(photo));
{
String pic = "~/pic/" + FileUpload1.FileName;
cmd = new SqlCommand("insert into wpt values ('" + TextBox1.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + DropDownList1.Text + "','" + DropDownList2.Text + "','" + DropDownList3.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + DropDownList4.Text + "','" + pic + "','" + TextBox5.Text + "')", con);
cmd.ExecuteNonQuery();
//Response.Redirect("registerredirect.aspx");
}
}

}; August 24, 2013 at 2:48 AM
Anonymous said...: sir,
I require a code for creating an ivr application using asterisk.; August 27, 2013 at 3:12 AM
Unknown said...: i tried ur above given code but an error throwing

Error : Type ImageHandler does not inherit from System.web.IHttpHandler

If u hv any idea please update soon,
thanks
Amit; September 6, 2013 at 8:44 AM
Anonymous said...: Hi suresh,

can you write code for:- Insert video file in database and then show on page. i have searched a lot but could not gate proper code. Please write code for us. I am frequent visitor of this site

Thank You
Reena Singh; September 11, 2013 at 3:23 PM
Unknown said...: Hi Suresh,

I want to upload a video file using c#.net.Save the uploaded file in SQL database. The uploaded video and its thumbnail shown into grid view. When user click on thumbnail they can play it. Please suggest the better solution.; September 16, 2013 at 6:23 AM
Unknown said...: I getting group of images for particular ID(VehicleID),,,it returns 3 records...but same image is binding three times....; October 1, 2013 at 7:04 AM
Unknown said...: hi please help me
my image save in sql in binary format.
i want to retrieve it in image box.
my query is select img from userprofile where username=@username; October 3, 2013 at 2:55 AM
Anonymous said...: i need code for complete login page with db also for forgot pwd.thanq; October 4, 2013 at 2:32 AM
Anonymous said...: getting error
says that- Incorrect syntax near @imagedata
plese help...please...

projectdatasp@gmail.com; October 12, 2013 at 9:43 AM
Unknown said...: Mr Suresh Sir How to insert Multiple Record in One Click Plz Help Me; October 22, 2013 at 10:00 PM
R.s.v.v. Prasad Rao said...: Sir, How can i pass textbox value in the query string given in the image tag of aspx? plas help me sir; October 24, 2013 at 4:24 AM
Anonymous said...: Hi sir,

I want to dispaly image in gridview. But i am storing images from one webpage and storing in sql server dbtype is image.
i want to retrieving form database and show it an other web page in gridview..; October 26, 2013 at 3:32 AM
Unknown said...: Sir, Namaskar
i am using VS 2010 and ms sql server 2005. Here I m facing a type convert problem. pls solve it.
error is:

Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Implicit conversion from data type varchar to varbinary is not allowed. Use the CONVERT function to run this query.

Source Error:

Line 44: cmd.Parameters.Add("@imagename", SqlDbType.VarChar, 50).Value = imagename;
Line 45: cmd.Parameters.Add("@imagedata", SqlDbType.Image).Value = imgbyte;
Line 46: int count = cmd.ExecuteNonQuery();
Line 47: connection.Close();
Line 48: if (count == 1)

Source File: c:\Users\rakesh\Documents\Visual Studio 2010\WebSites\RuhilTech\image.aspx.cs Line: 46; October 29, 2013 at 10:26 PM
Abhinav Malviya said...: everything is fine but my sotred images not dispaly in image folder.
i hv already use httphandler,ashx file.
i hv to follow all ur instruction but all worked successfully but images not display..plz give us positive answer...; November 22, 2013 at 9:25 PM
Unknown said...: sir,I Have two tables and i am displaying the datas using a gridview by using view in sql server i need to implement drop down search thats all are working fine but i need to Change in this by using login form when a user logins his username gets saved automatically by using session but while i am displaying in grid i am getting this username its the id we have given for the corresponding user but related to that id i need to match the correct username thats given in another colomn in login table and needs to display in gridview can u please give me a idea how to implement this. Iam trying from last 2 days not getting please help me....; November 26, 2013 at 1:25 PM
Unknown said...: hello sir,
my name is saurabh gupta
i have a problem can u help me out that problem
sir i save the image path in database and image store in a folder
but it will not retrieve at the time of page load sir please give me answer
thanks sir...; December 6, 2013 at 2:45 AM
Anonymous said...: sir your blog is a great help for student like us, but some of your demo are not working pls make them work they are very beneficiary in understanding the concepts; December 16, 2013 at 8:00 AM
Unknown said...: hello sir,
how to display the images using datalist control and for the corresponding id[row].; December 18, 2013 at 11:44 PM
Unknown said...: sir,
how can we insert new row using data grid view without textbox controls. for ex. using add command to insert new record within gridview.
so please give me code sir......; December 18, 2013 at 11:51 PM
Sandeep said...: Hi,
I was able to load the image on the page using this however the handler.asps/.ashx is running when the current page lifecycle ends (i.e. after the page load completes). In my case I am creating the image control dynamically(there can be multiple image controls) and I need to fetch and bind the images corresponding to each control. Using the above technique only the last image URL gets assigned to the image control, the rest of the images show up blank. Can I get some help on this?; January 9, 2014 at 8:08 AM
Anonymous said...: working well thanks; January 20, 2014 at 4:21 AM
Unknown said...: HI Suresh,
How to retrieve image from file path stored in database display into listviewt using asp.net; January 24, 2014 at 11:23 PM
Unknown said...: hi sir,
I am completely confused regarding "how to retrieve an image from database on clicking imagebutton present in a gridview"
Thanx in advance..; January 29, 2014 at 10:37 PM
Unknown said...: hi sir,

Thanx for such a valuable response.; February 7, 2014 at 10:14 PM
The Online Income Insider said...: thanx; February 10, 2014 at 3:11 AM
Anonymous said...: Can Anybody explain me what is the use of handler.ashx file with an example. please show me a scenario with and without use of handler.ashx file. plz i need it immediatly.; February 11, 2014 at 10:31 AM
Cool_Coding said...: I am working on a windows application that will store customer data along with image,
I have done the part of uploading a image. Now I want to write a code that will work as like download link in web applications.
How to save uploaded image data back to computer?
Here is code i used for upload

private void btnUpload_Click(object sender, EventArgs e)
{
try
{
string str = ConfigurationManager.ConnectionStrings["MySampleDBConnectionString"].ConnectionString.ToString();
SqlConnection con = new SqlConnection(str);
OpenFileDialog open = new OpenFileDialog();
open.Filter = "Image Files(*.jpeg;*.bmp;*.png;*.jpg)|*.jpeg;*.bmp;*.png;*.jpg";
if (open.ShowDialog() == DialogResult.OK)
{
txbImg.Text = open.FileName;
pictureBox1.Image = new Bitmap(open.FileName);
}
btnSave.Visible = true;
}
catch (Exception ex)
{
MessageBox.Show("Error" + ex.Message.ToString());
}; February 15, 2014 at 2:59 AM
Unknown said...: How can i add the HTTPhandler.ashx class in visual studio 2008? plz help..; February 24, 2014 at 10:17 PM
Murari said...: Dear Suresh , I try this post's code on Visual studio 10.
http handler giving syntax error near reader.
what change should i made in that.

Thanks in advance.; February 26, 2014 at 1:22 PM
Unknown said...: I came to know many things about .net only from your posts suresh. Thanks a lot . . . . U R doing a good job; March 6, 2014 at 10:56 PM