Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET
page 1 of 1
Published: 22 Oct 2003
Unedited - Community Contributed
Abstract
Before reading this article, I assume that the reader has read my two previous articles which talks about Inserting Images to Sql Server in ASP .NET and Retreiving Images from Sql Server in ASP .NET. In this article, we will discuss about populating a datagrid with images. Of course, the images will be coming from the database.
by Jesudas Chinnathampi (Das)
Feedback
Average Rating: 
Views (Total / Last 10 Days): 66400/ 47

Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET

Written on: May, 15th 2002.
Introduction

Before reading this article, I assume that the reader has read my two previous articles which talks about Inserting Images to Sql Server in ASP .NET and Retreiving Images from Sql Server in ASP .NET.

In this article, we will discuss about populating a datagrid with images. Of course, the images will be coming from the database.

We will be learning the following aspects in this article.
  1. Formatting or populating a URL dynamically
  2. How to read images from a sql server
  3. How to display the images in a DataGrid which is retrievied from a SqlServer

We will have two ASPX pages, one for displaying the datagrid and another one for pulling the images from sql server datbase. The one which displays the datagrid just contains the TemplateColumns, and ItemTemplates. The DataGrid will have many columns. We will just concentrate on the column which displays the image.

Code to show the image from sql server (DataGrid part).
    <asp:TemplateColumn HeaderText="Image">
        <ItemTemplate>
            <asp:Image
            Width="150" Height="125"
            ImageUrl='<%# FormatURL(DataBinder.Eval(Container.DataItem, "PersonID")) %>'
            Runat=server />
        </ItemTemplate>
    </asp:TemplateColumn>


And the method FormatURL (A Server side Function) is as follows.

    Function FormatURL(strArgument) as String
        Return ("readrealimage.aspx?id=" & strArgument)
    End Function

And the method FormatURL (A Server side Function) is as follows.

    Function FormatURL(strArgument) as String
        Return ("readrealimage.aspx?id=" & strArgument)
    End Function

How it works?

In the above code, we have an ItemTemplate column. And we have a <asp:Image web server control which is equivalent to the <img> tag. In the ImageURL property, we invoke a server side method, FormatURL, which populates the image source. In the FormatURL, you can see that, we invoke another page called readrealimages.aspx, which actually pulls the image from the sql server. The technique for retrieving the image is the same that was discussed in my other article, which deals with
Retreiving Images from Sql Server in ASP .NET. Let us take a took at the content of readimage.aspx.

Code to show the image from sql server (Talking with the Database part).
    Public Sub Page_Load(sender As Object, e As EventArgs)

        Dim strImageID as String = Request.QueryString("id")

        ' Create Instance of Connection and Command Object
        Dim myConnection As New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
        Dim myCommand As New SqlCommand("Select PersonImageType, PersonImage from das_person_real_images Where PersonID=" & strImageID, myConnection)

        ' I have used the select statement. But it would be much much better, if you
        'could write a small stored procedure which contains the above sql statement.
        ' Mark the Command as a SPROC (in case, if you wrote the stored procedure
        'myCommand.CommandType = CommandType.StoredProcedure

        Try
            myConnection.Open()
            Dim myDataReader as SqlDataReader
            myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
            Do While (myDataReader.Read())
                Response.ContentType = myDataReader.Item("PersonImageType")
                Response.BinaryWrite(myDataReader.Item("PersonImage"))
            Loop
            myConnection.Close()
        Catch SQLexc As SqlException

        End Try

    End Sub

How it works?

In the Page_Load event, we first retrieve the querystring (ID of the Person). Then we execute a Sql statement which returns the imagetype and the imagecontent from the database. Retrieving the image and writing to the browser is same as we discussed in Retreiving Images from Sql Server in ASP .NET.

Test this Script

Advantages and Disadvantages

The greatest advantage is that, since we store the images in database, more security is their. And the greatest disadvantage is that, we are making a database call for each image. So, if we have thousands of rows then, this process of retrieving image every time will result in low response time.

Download the code

Click here to download the datagridimages.aspx page
Click here to download the ReadRealImage.aspx page
Click here to download the Stored Procedures and table scripts

Conclusion

In the DataGrid, we do not have a hyperlink to click on the image. You can add another column which has a link that will be display the full image once it is clicked. You can work on this as an enhancement. If you have any trouble in getting this done, don't hesitate to email me.

Links

Inserting Image to SqlServer
Retrieving Images from SqlServer
How to Upload a File?
Textbox Web Server Control

Send your comments to das@aspalliance.com        



User Comments

Title: display image in image control   
Name: sangi
Date: 2013-01-16 2:56:54 AM
Comment:
how can retrieve image from sqlserver then display in image control in asp.net 4.0
Title: Image Slider   
Name: Ram
Date: 2012-05-02 4:42:25 AM
Comment:
How can be make image slider using data basa
Title: Display images in gridview   
Name: csharpaspnetarticles.com
Date: 2012-03-24 6:22:16 AM
Comment:
Here's good example

http://www.csharpaspnetarticles.com/2009/07/display-images-gridview-from-database.html
Title: how upload and retrieve images to/from datagrid view in vb.net   
Name: Divya
Date: 2012-03-17 11:47:33 AM
Comment:
Hai Sir,
i want to split the images into layers in a datagridview and retrieve it.
if i move the mouse on the gridview that layer displays in the picture box
Title: binary code convert into image on sql server   
Name: kadar ali
Date: 2012-02-01 10:28:02 PM
Comment:
hai.....
i want to coding this....
multiple image display on repeater on asp.net using c#...

thanks
kadar ali
Title: displaying image in datagridview in c# windows application (image is stored in SQL server)   
Name: Sheetal
Date: 2012-01-31 11:19:25 PM
Comment:
Hi,

I want to display images which are stored in the SQL server in to a datagridview . My project is a windows application. Thats why I want a code in C# .net in windows application.

Somebody please help me out.

Thx
Title: image not display   
Name: Udayakumar
Date: 2011-12-29 8:03:27 AM
Comment:
sir, i have a problem. while retrieving images, i get the image name from the database. i need to display these images in gridview. i have already uploaded that images in a prticular folder on my site. i dont know how to do it? pls help its urgent?
Title: can you display image in slider jquery   
Name: sachin k
Date: 2011-12-19 4:32:06 AM
Comment:
plz can you display image in slider jquery
Title: how to display image in database   
Name: padma
Date: 2011-12-19 2:22:36 AM
Comment:
please help me i have developed one project in ASP.NET
in c sharp coding
Title: Hpw to display image in sql server   
Name: kumar
Date: 2011-12-16 5:46:58 AM
Comment:
please help me i have developed one project in ASP.NET
in c sharp coding
Title: How to display image and Data from database in Repeater Control using asp & c sharp   
Name: Nikhil
Date: 2011-12-12 12:31:26 AM
Comment:
Please help me I have developed one projrect in ASP.NET
In C Sharp I Have know how to insert image and data in databae
But i don't know how to display image and data in Repeater Control.Its Urgent..
Title: How to display image and Data from database in Repeater Control using asp & c sharp   
Name: Nikhil
Date: 2011-12-12 12:30:22 AM
Comment:
Please help me I have developed one projrect in ASP.NET
In C Sharp I Have know how to insert image in databae
But i don't know how to display image and din Gridvie
Title: Image Display   
Name: VINAY KUMAR GUPTA
Date: 2011-10-18 9:25:48 AM
Comment:
Please help me I have developed one projrect in ASP.NET
In C Sharp I Have know how to inser image in databae
But i don't know how to display image in Gridvie
Title: Image display   
Name: venuacharya
Date: 2011-09-20 12:55:07 AM
Comment:
Dear sir/madam......

Plz help for me....i am requesting for u....
It is very usefull this code for me.....But ....
The Image's are dispalying only one.....the question is

How to Display the image by using PersonImagetype , PersonImage .....
eg:

person Name= venu Image=./jpeg
Person Name= Das Image will display wrong for me....
according to Person ID the Image has to display .....so plz send the code for that.....


thank uuuu
Title: display image in picture box   
Name: Raj Kumar
Date: 2011-09-13 6:22:45 AM
Comment:
I am working on windows application using vb .net.I want to display photo and signature in two different picture box at the same time from sqlserver 2005 .So plz help me in that.
Title: insert and display image in datagridview using c# .net   
Name: Imran
Date: 2011-06-09 1:36:23 AM
Comment:
I am working on windows application using c# .net.I want insert and display records in datagridview using sql server database queries.So plz help me in that.
Title: display images in many columns in grid view   
Name: tina
Date: 2011-03-24 3:01:45 AM
Comment:
how to display images in many columns in gridview when the images are stored using the image path or the image url in database
Title: image do not show in DataGridView   
Name: vunguyen
Date: 2010-11-26 4:21:01 AM
Comment:
I have a code:

protected void bntAdd_Click(object sender, EventArgs e)
{
try
{
string constr = "Data source= STUDENT-E7DAD20; Initial catalog= OPMS; integrated security= true";
SqlConnection con = new SqlConnection(constr);
SqlCommand com = new SqlCommand(constr);
com.CommandText = "insert into Employees values('" + drlBranch.SelectedValue + "','"
+ drlProvince.SelectedValue
+ "','" + txtEmployeeName.Text + "','"
+ txtBirthday.Text + "','" + rdbmale.Checked + "','" + txtPhone.Text + "','" + txtEmail.Text + "','"
+ txtAddress.Text + "','" + fulPicture.FileName + "','"
+ txtCreateDate.Text + "','" + drlAccount.SelectedValue + "','" + drlStatus.SelectedValue + "')";
com.CommandType = CommandType.Text;
con.Open();
com.Connection = con;
com.ExecuteNonQuery();
}
catch (Exception ex)
{
lblError.Text = ex.Message;
}
}

I inserted all information in sql. After the image do not show in DataGridView. Help me, please!!!
Thanks & Best regard
Title: Superb   
Name: Rukatoki
Date: 2010-10-31 6:09:52 AM
Comment:
Thank you very much for this clear cut example!!!
I've been browsing the web for days and I finally found what I've been looking for!!!
Title: How to Insert & Retrive a image into sqlserver 2000   
Name: GL_Sat
Date: 2010-08-11 6:20:02 AM
Comment:
I'm going to do project by using of asp.net and c#. Now i've a plan to take a backend as sqlserver 2000. So i wenna know how to insert and retrive a images from that database.
Please dont send me any syntax. I wenna see complete codes.
For instant,

{
SqlConnection conn;
con=new SqlConnection("server="myserver"; uid="sa", pwd="sa", database="mydatabase",con)
}
Title: retriving image from sqlserver2000 in asp.net and c#   
Name: Rakesh Kuamr
Date: 2010-06-24 6:03:20 AM
Comment:
dear sir
i saved image in sql database using the following coding :-public partial class profilepg2 : System.Web.UI.Page,IHttpHandler
{
SqlConnection connection;
SqlCommand command;
SqlDataReader dr;

protected void Button1_Click(object sender, EventArgs e)
{
if (FileUpload1.HasFile)
{
using (System.IO.BinaryReader reader = new System.IO.BinaryReader
(FileUpload1.PostedFile.InputStream))
{
byte[] image = reader.ReadBytes(FileUpload1.PostedFile.ContentLength);
SaveImage(image);
}
}

}
private void SaveImage(byte[] image)
{
command = new SqlCommand("INSERT INTO Photos (Photo) VALUES (@Photo)", connection);
command.Parameters.AddWithValue("@Photo", image);
command.ExecuteNonQuery();
}
protected void Page_Load(object sender, EventArgs e)
{
connection = new SqlConnection("Data Source=(local); Initial Catalog='pallavi'; Integrated Security=true");
connection.Open();
}

But now i am not able to retrieve image from same database.
plz do the solution for this.
Title: Retrieving Images from SqlServer and displaying in a DataGrid - C#   
Name: Emmao
Date: 2010-04-18 9:05:13 AM
Comment:
Hi,
Very great piece; I have tried it; it worked perfectly.
But when I tried to translate this same concept to display an image in an employee detail form there was a problem.

Could you pls assist me on what to do in this regard.

Thanks.

Emmao
Title: repeater   
Name: varun
Date: 2010-04-03 5:30:36 AM
Comment:
i want to display 9 images in repeaer control
in which 3 row sow 3 images like

1 2 3
4 5 6
7 8 9
Title: Retrieving Images from SqlServer and displaying in a DataGrid - C#   
Name: eljohn obsequio
Date: 2010-03-26 4:03:01 AM
Comment:
sir do you have a version of this code in c#?...
thank u in advance..
Title: converting all the grid values into images.   
Name: Madhu
Date: 2010-03-19 7:25:48 AM
Comment:
hi sir,
i need to replace all the gridviews's cells value into three colored circle,that is red green and yellow. if the value is grater than 90 then green color circle , if its between 80 to 90 yellow color , and if it is less than 80 then red color circle.
i have fetched the data from SQL , now i need to convert .
i am using Asp.net with C# and SQL.

please... please.... please do the favor.
i need it within 2 to 3 days ..
please do the favor for me .

thanq sooo muc in advance.
Title: retreiving images   
Name: hemangini Dhimar
Date: 2010-01-07 3:16:33 AM
Comment:
sir, i have a problem. while retrieving images, i get the image name from the database. i need to display these images in gridview. i have already uploaded that images in a prticular folder on my site. i dont know how to do it? pls help its urgent?
Title: Retrive images   
Name: nitin
Date: 2009-07-21 1:42:48 AM
Comment:
it's great article but i e have one problem how to fetch all images from database this article fetch only one records at a time but i want fetch all records at a time.plz help me
Title: Retrieving Images For FormView   
Name: Phil
Date: 2009-07-15 6:08:28 PM
Comment:
AWESOME TUTORIAL GUYS! I wired this up to an Image Control in my FormView and it works AWESOME! Thank you again!
Title: retrieving images from sqlserver   
Name: arun
Date: 2009-06-20 7:07:46 AM
Comment:
hello sir,
i used this code but am not viewing the images in my browser.
am using IE6 but it not displaying the images in the grid.
please tell me the solution
my email: mangaarun@gmail.com
Title: Problem   
Name: Ramon
Date: 2009-06-01 9:31:40 PM
Comment:
I am having trouble with godaddy and this code, when i publish in my local machine I have no problem, but when I publish to godaddy the pictures show for a day, then something happens and they stop showing, I have been publishing daily but now nothing happens I get no pictures.
Title: Inserting and Retrieving images from SQL Server   
Name: Ravi
Date: 2009-04-08 8:39:24 AM
Comment:
superb code, Great work! Keep it up
Title: Inserting and Retrieving images from SQL Server   
Name: bharat babariya
Date: 2009-04-06 2:34:37 AM
Comment:
hi,
this is a excllent article.
This is a great tutorial and one that has helped me greatly. I was able to modify the code so that I can retrieve all of the images from the database at one time and insert them into a repeating datalist.
Title: Inserting and Retrieving images from SQL Server   
Name: Michael Agbamuche
Date: 2009-03-29 7:01:01 AM
Comment:
great snippet, you have been of immense help to my project. am also considering uploading same image file to a folder on my app directory.
great job
Title: Inserting and retreving images from sqlserver   
Name: Ravichandra
Date: 2009-02-10 11:58:18 PM
Comment:
Hi,

Excellent Article.

It would be better if u write an article for storing thumbnail images also.

Regards,
Ravichandra.
Title: Resize Retrieved Images   
Name: Jeff
Date: 2009-01-12 11:49:54 AM
Comment:
Hello,

This is a great tutorial and one that has helped me greatly. I was able to modify the code so that I can retrieve all of the images from the database at one time and insert them into a repeating datalist.

My question is if anyone has implemented any code, using the code base in this tutorial, to resize the images on the fly for producing images of different sizes without compromising the quality of the original images?

If so, I would be more than grateful to see a code example that can be incorporated into this tutorial.

Great work.
Title: Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET   
Name: Badari
Date: 2008-10-22 4:29:08 AM
Comment:
hi,
Thanks for your information
but i am unable retrive the images when i put the function name in the imageurl it telling that FunctionURL not defined
please help me its urgent...

Regards,
Badari.y
Title: Retrive the image in image controller from database using blobs in sqlserver 2005 with ASP.Net,C#.net   
Name: Naveen
Date: 2008-09-30 1:57:42 AM
Comment:
i want to view the image control which has been stored in the database using blobs in sql server 2005 C#.net with ASP.Net
Title: Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET   
Name: IBIKUNLE OLUWOLE
Date: 2008-09-11 9:42:08 AM
Comment:
Thanks alot for the code well written self explanatory.
God bless you.

Email:ibikunleoluwole@yahoo.com
Title: retrieving image from sql server & displaying in a gridview   
Name: soubhagya biswal
Date: 2008-08-13 2:27:31 AM
Comment:
sir,
i am working in asp.net2005 using c#,sir inserting image into sqlserver is successful,but i am facing problem when to retrieve image from sql server and displaying in a gridview.sir please help me,it's very urgent,sir please provide the code in c#.
My emil id is:-soubhagyabiswal.mca@gmail.com
Title: different images   
Name: hdm
Date: 2008-07-28 1:29:15 AM
Comment:
hi
I want to use different images in one column in datagird.
how can i do that?
can i use "if else" for display datagrid?
Title: Good Idea   
Name: Ajay pandey
Date: 2008-07-24 4:30:41 AM
Comment:
It is realy a good idea and many new comers can take advantage from this code.
Thanks
Title: How do i make Image web control in ASP.NET display an image   
Name: Kenneth
Date: 2008-07-21 10:53:18 AM
Comment:
How do i make an Image web control in ASP.NET display an image with a Bitmap format, after i converted it from Byte,
---this is my code
Private Function ByteToImage(ByVal BImage() As Byte) As System.Drawing.Bitmap

Dim b As Bitmap = CType(Bitmap.FromStream(New MemoryStream(BImage)), Bitmap)

Return b
End Function
------------------------------------------------------
am getting my image Byte from a Database with a Class
and i want to display it with the Image control like this:


dim PicClass as new Picture
' After getting it from the DB
with PicClass
Image1= .PicImage
end with
-------
Pls I need your help urgently
Title: Retrieving Images from Sqlserver and displaying in a Datagrid   
Name: Jowar
Date: 2008-07-20 12:21:35 PM
Comment:
thanks for the code. Simple and well explained. You are the best. (",)
Title: Retrieving Images from Sqlserver and displaying in a Datagrid   
Name: Subhashini
Date: 2008-07-01 6:23:58 AM
Comment:
I like the article.Very informative.I could not guess out fully how the output will be.However I could get the point that connected data access is used and only one image can only be viewed at a time.Is there a way to store images in dataset and retreive from it.Is it possible? Hope I will try and get it.
Title: Displaying image in datagrid   
Name: Noufel
Date: 2008-06-25 3:24:12 AM
Comment:
Superrrrrrrrrrrrrrrrrrrrr.Txs a lot
Title: Multiple images in same page   
Name: Nidhin
Date: 2008-06-24 3:17:41 AM
Comment:
Hi,
I need to print multiple images in same page with this method .I can display images but not in currct order.ie,All images are displaying random.How to display in the currect order.Plz reply here or send the code nidhinrc@gmail.com.
plz any one reply as much as possibal

Thanks & Regards,
Nidhin
Title: intraction with db   
Name: raj
Date: 2008-06-20 1:56:24 PM
Comment:
Iam doing school project, I want intract with db from frontend registration form for retriving & updation data
Title: retrving images ti gridview   
Name: kiran
Date: 2008-06-19 8:12:46 AM
Comment:
thanks a lot
i inserted images to database.
when i am retreving the image sto gridview how can i pass the value to querystring.
i didn't get images in data grid
please send the code kiran.224@gmail.com
Title: Thanks   
Name: kiran
Date: 2008-06-19 7:46:50 AM
Comment:
hi thanks,
when i am executing how can i give query string id .
Request.QueryString("id")
Title: Bakwas   
Name: Bakwas
Date: 2008-06-12 4:52:31 AM
Comment:
If Request.QueryString.Get("Id") IsNot Nothing Then
Response.Clear()
Dim id As Guid = New Guid(Request.QueryString.Get("Id"))
Dim myFile As File = File.GetItem(id)
Response.ContentType = myFile.ContentType
If myFile.ContainsFile Then
Response.BinaryWrite(myFile.FileData)
Else
Response.Redirect(Path.Combine(AppConfiguration.UploadsFolder, myFile.FileUrl))
End If
Else
Response.Redirect("~/")
End If
End Sub
Title: Thanks a lot   
Name: Buddika
Date: 2008-05-29 7:23:45 AM
Comment:
Thanks for this article, its really helpful for me.
Title: In panel or textbox   
Name: Deepa
Date: 2008-05-23 2:04:40 AM
Comment:
Thnx for article, can retrieve image in panel or textbox?
bcoz whn i enter employee id i want picture of that employee in textbox or panel
plzzz help me

Thnx & Regards,
DeepaG
Title: very good   
Name: narender
Date: 2008-05-15 5:49:47 AM
Comment:
it is very good and so much help to my problem,but i have another query,how to crate a excel file dynamically with sheetname
Title: retrive image from databse   
Name: neeraj
Date: 2008-05-06 9:11:29 AM
Comment:
thank's for help me it's realy a good way to do your project reduce the code size theank u once again dost
Title: Open Window   
Name: Abraham
Date: 2008-04-08 6:31:48 AM
Comment:
This is a good script, thanks for your help. But I am facing a problem...It is showing image in different window when I try to load. i have a lay out. How can i show the images in the same wondow (_self)? my URL is something like domainname/default.aspx?pageid=107
Title: hi   
Name: Amol Kagde
Date: 2008-04-07 12:43:23 AM
Comment:
hi

this article realy help me......

thank u!
Title: Verygood   
Name: Nice
Date: 2008-04-03 6:13:28 AM
Comment:
very good
it's too easy
i west my one week behind this problem
but from above solution i got the solution of my problem within a few minutes
thanx again
Title: thanks   
Name: pooja shah
Date: 2008-03-08 4:47:29 AM
Comment:
this article is really a very good article ..
i really liked it..
it has solve my problems of how to upload images
Title: Thanks   
Name: suma
Date: 2008-03-03 7:30:59 AM
Comment:
The information given by u is nice.But when i use the following lines in c#

Response.ContentType = myDataReader.Item("PersonImageType")
Response.BinaryWrite(myDataReader.Item("PersonImage"))

iam unable to find the Item Property as there is no item property in c#.So plz can u help in this issue..
Title: thanks   
Name: ash
Date: 2008-02-19 6:06:58 AM
Comment:
i want to now that if i hv inserted 20 images of a single user
at the time of registration that images are blank. now i hv to retrive that images in datalist and in my datalist i hv to display 20 diff images from that database but when i will insert that time it will take only one image and all 20 images in database will be same .
so plz rply me code how can i display 20 diff images of single user
Title: Thnks   
Name: Shafiq
Date: 2008-02-13 5:14:23 AM
Comment:
i got ideas from this
it is really good
Title: i really thankful to you for this help...   
Name: Rana Omair
Date: 2008-02-13 1:01:01 AM
Comment:
thanks..its really helpful for me...and new commers.as well.
Title: Great!!   
Name: Kristof 'kleine'
Date: 2008-01-30 10:18:30 AM
Comment:
Thank you so much for this post, it was very helpfull in order to complete my latest project.
Please Continue doing such a great job!
Title: displaying image in datagrid   
Name: sravan
Date: 2008-01-21 6:28:44 AM
Comment:
can u please send me how to retriew images to the datagrid from database in the serial order which i had saved in it(images saved in database) not from url but directly from database
Title: displaying image in datagrid   
Name: pradeep
Date: 2008-01-21 6:15:21 AM
Comment:
its good but i waNT SOMETHING more .can u please send me how to retriew images to the datagrid
Title: Thank you   
Name: Noora
Date: 2008-01-21 5:45:40 AM
Comment:
Realy usefull and simple.
Thank you
Title: programing +truth table (and,or,conditional statement)+c++ +show execute   
Name: neda
Date: 2008-01-13 5:10:40 PM
Comment:
I NEED TO HELP ME FOR THIS PROGRAM AND RESULT PLZ
Title: i'm getting problem   
Name: Viral Vyas
Date: 2008-01-05 2:20:26 PM
Comment:
plz any one reply as much as possibal
i have read many of code and smple which showes how to add imgage in grid view from sqlSever but i can't getting full help i mad lost of code from internet but failed to retiver so plz maill me full code with expenetion to me on vikivyas@gmail.com
i will be very thnak full if you help me
Title: about CommandBehavior   
Name: aa
Date: 2007-12-31 3:29:31 AM
Comment:
when i paste the above code in my form a following error has been occurred whats the solution for this problem

"Name 'CommandBehavior' is not declared"
Title: Good sample   
Name: Andrey
Date: 2007-12-28 4:11:56 AM
Comment:
Realy usefull and simple. Thanx a lot!
Title: sir my problem is that suppose there are 50 records in the database and i want to show last 10 records in the grid view   
Name: Amit mittal
Date: 2007-12-20 1:30:47 AM
Comment:
sir my problem is that suppose there are 50 records in the database and i want to show last 10 records in the grid view and it will retrieve only that 10 records from the database not all
Title: Help   
Name: Sioux
Date: 2007-12-06 7:05:06 PM
Comment:
Thanks for the code, it works fine but the image is not displayed in the datagrid, I only get an X.
Did anyone solve this problem?
Please reply to susanna_pecora@hotmail.com
Title: Retrieving images from uploaded folder   
Name: Software Engineer Amjad Hussain
Date: 2007-12-06 6:40:14 AM
Comment:
Thank you for your response sir, i could upload the forder in asp.net but there is one problem to get the exact path of that server on which our project is running. please convey the solution.
Title: Retrieving images from sql server 2000   
Name: Software Engineer Mumtaz Ali
Date: 2007-12-06 6:35:52 AM
Comment:
there is one problem to retrieve the picture from sql 2000 . it is accessed but how to display in a image1 control .
Title: retreiving image   
Name: veerapathiran(phenos)
Date: 2007-11-30 11:55:53 AM
Comment:
hai,
ur coding is easy to understood all..thank u for ur helping mind....
my question: i easy to upload the image for sql server 2ooo data base..but i don't retreiving a image from sql server 2000 data base to asp.net with c#(contros using datalist)..plz how can retrieve the image to datalist control from sqlserver 2000 ..plz reply to me.....
it's very urgent need..plz sir plz......
please post me the code to kalai_veera@sify.com or kalai_veera@rediffmail.com
Title: i want a retrive delete images code   
Name: veena khan
Date: 2007-11-29 9:48:19 AM
Comment:
hi h r u
i just wana say u that i ve some problem in retrive n delete image
how can i retrive n delete images in vb.net2003 using sqlserver2000
plzzzzzzzz
its very urgent
plzzzz
do give me favour
my email is
elite_onlinz@yahoo.com
Title: display image   
Name: sadanandam
Date: 2007-11-29 6:04:34 AM
Comment:
hello ,i want to retrieve the image frm the sql server 2005
and place it an the image conrol plse reply me .plse reply me to sadanandam_mca@yahoo.co.in
Title: Display image   
Name: Sowjanya
Date: 2007-11-28 2:05:51 AM
Comment:
Hello sir,
I want to retrieve an image from sql server 2005 and place it in an image control in c#.net 2.0.
Please post me the code to
sowjanyaposani@gmail.com
Title: mmm...   
Name: Miron
Date: 2007-11-20 9:27:22 AM
Comment:
Saving images in the db is'nt so good idea, special from the reason of the difficulties of show them on the screen.
Opening connection to DB fr every image is a really bad thing to do!
Save your images in a floder, an the names only in the db.
If you concern from security, so disable access to the images directory from your Web.config
Title: Can't display an image   
Name: Nono
Date: 2007-11-12 1:34:09 AM
Comment:
Im using VB in VS2005, SQL Server 2005 and i using the example pages and code posted here, but the datagrid only shows a red 'X' in the column of the image, and all the other columns shows their correct values, somebody knows why the column of the image dont show the image?
thanks...
Title: how we update a single record in datagrid using C#   
Name: Amit s Umredkar
Date: 2007-10-31 12:48:37 AM
Comment:
sir,
i want to update a single or particular record in datagrid and only to view a single record how i can do this plz tell me
Title: how do this for c#?   
Name: putianlei(putianlei@163.com)
Date: 2007-10-30 9:49:30 PM
Comment:
I want to know :how do "Response.BinaryWrite(myDataReader.Item("PersonImage"))" in c#?
Title: Retrieving Images from SqlServer   
Name: Swarup
Date: 2007-10-30 5:29:40 AM
Comment:
Tru myDataReader["PersonImageType"]
Title: Retrieving Images from SqlServer   
Name: kavya
Date: 2007-10-25 1:13:32 AM
Comment:
In following lines getting error:as there is no item property in c#.how to replace:
Response.ContentType = myDataReader.Item("PersonImageType")
Response.BinaryWrite(myDataReader.Item("PersonImage"))
kavita.dhoot@rediffmail.com,
waiting soon to hear from you
Title: Retrieving Images from SqlServer   
Name: karthi
Date: 2007-10-18 1:17:05 AM
Comment:
sir/madam,

i have seen your site for my doubt Retrieving Images from SqlServer, yet i haven't get solution from your site...
i know your site is only link but not solution
Title: how to insert an image into datagrid   
Name: minati
Date: 2007-10-12 6:04:02 AM
Comment:
It was really interesting to find the code. Now my problem is solved to gud extent. Thanks to all the family members of the site u make the world move smooth. the help
Title: how to show two table in one detagrid through stroed procedure   
Name: Amit Singh
Date: 2007-10-07 2:41:27 PM
Comment:
I am trying to show 2 table in one datagrid(using ASP.NET & C#.NET) through Stroed Procedure(sql server2005), but in query(in Stroed Procedure), show error. Can u help me....?
My mail id is "m4aksingh@gmail.com".
Title: http handler   
Name: Maitry Panchal
Date: 2007-09-13 1:14:02 AM
Comment:
i tried your code to retrieve image from databse. Actually i want to display images in datagrid with help of http handler.my project is Blog creation application n i want to display friend list with corresponding images in my myfriend list form
Title: It Works But Some Changes Required   
Name: Subhajit Sarkar
Date: 2007-09-12 6:55:07 AM
Comment:
Changes required in store procedure and some coding in asp.net. but it works fine.
Title: Its giving an error   
Name: Brendan Barghus (brendan@neametrics.com)
Date: 2007-08-31 10:58:46 AM
Comment:
I am getting the folling error on binding the datarid to the dataset (There is no row at position 0). Is there anyway you can help me on this error.
Title: It works   
Name: Rudolph
Date: 2007-07-25 9:04:42 AM
Comment:
If you are struggeling to get this to work then email me and I will send you a step-by-step example of how to upload images and displaying it using a grid.
rudolph@networkdeals.co.za
Title: MR   
Name: Anbu
Date: 2007-07-25 3:27:27 AM
Comment:
It is good.Thanks
Anbu
Title: Mr   
Name: Simon
Date: 2007-07-16 2:48:11 PM
Comment:
This is very useful to any one,its my first time to use asp.net but I now feel like a proffessional somebody.
Siplifies life for Developers
Title: Help full   
Name: muthu
Date: 2007-07-11 11:02:07 AM
Comment:
coding would be very useful to developers thank u
Title: nice Article   
Name: adams
Date: 2007-07-11 6:05:48 AM
Comment:
if you have code for retrive image from sql server into windows picture box in vb.net 2003

Because it only works in ASP
Title: Hw to Update image in datagrid   
Name: Leela
Date: 2007-07-10 8:16:38 AM
Comment:
i wanted to update image , i m able to upload image to dB but unable to update the image if any i do updation. Pls reply me regarding this as soon as possible
Title: please heip me   
Name: sudheer
Date: 2007-07-03 12:30:42 AM
Comment:
hello this is greate code.but my problem is images are inserted into the database.but my client requirement is at the retrieving time that image must be open in Microsoft Office Picture Manager .but my image is opened in another browser how is it possible.how can i open image in Microsoft Office Picture Manager.
Title: Programmer   
Name: chitra
Date: 2007-07-02 4:24:43 AM
Comment:
Hello Sir,
I did what you told to do but this is giving me an error
Error 1 The best overloaded method match for the file name has some invalid arguments
Error 2 Argument '1': cannot convert from 'object' to 'string'

do you have any other solution for this?
thankfully
chitra
Title: SE   
Name: Sathiskumar.P
Date: 2007-06-30 5:39:45 AM
Comment:
How to assign retive image from SQL Server 2000... to image control in asp.net,C#.net....

Help me.......
Title: display tiff image in Datagrid   
Name: K A Bhuva
Date: 2007-06-27 3:50:01 AM
Comment:
In your Code Display .jpeg and .gif but i want to display .tif image in datagrid please help me.

It's very urgent
Title: how to retrieve the text file from access database   
Name: santosh
Date: 2007-06-24 2:04:59 PM
Comment:
plz. send me(santoshjsh@yahoo.com) the code for retriving the text,doc,img file from access database uploaded using fileUpload web control in vb.net. and how to show it in asp.net web form. as soon as possible.
thanking you
Title: Save Images in a Folder in the Application for Display in GridView   
Name: Umesh
Date: 2007-06-22 2:12:45 PM
Comment:
I store image selected by the User in a folder in the Application with a Unique FileName. But in an Edit mode if the User happens to change the image, the new image is also stored with the same name(prev image overwritten) in the folder.

A gridview which shows the record along with the image doesnt show the new image after the update. Its only after the application is restarted does the new image appear.

Can U help me with this..

Cheers
Title: How to save images in SQL Server   
Name: Srikanth
Date: 2007-05-29 5:03:29 PM
Comment:
Hello,

Can some one of you guys,help me how to save images in SQL server by giving path of images. and also how to display them on web pages.It would be really helpful for me if someone can send me the sample code for doing this in C#.Please email me at srikanth.neu@gmail.com

Thanks,
Srikanth
Title: cant able to edit or update a datagrid in vb.net   
Name: Priya
Date: 2007-05-28 3:09:51 AM
Comment:
i hav used datagrid to merge the database, i dont know the code used for edit,update and delete command in the datagrid even though i placed a button item from property builder->columns->button, but i dont know how to write the code for that
Title: nt getting respone   
Name: lopamudra
Date: 2007-05-23 4:52:17 AM
Comment:
i have dropped 3 mails rgding my doubt code, which im using ur code "Retrieving Images from SqlServer and displaying in a DataGrid" .
bt till now im nt getting any response.
can i have wht is d problem?

thanx & regards
Title: nt passin d parameter   
Name: lopa
Date: 2007-05-22 8:47:14 AM
Comment:
grid.aspx.vb
-----------------

Function FormatURL(strArgument) as String
Return ("readrealimage.aspx?id=" & strArgument)
End Function

pullinimage.aspx
-----------------------

Dim strImageID as String = Request.QueryString("id")

function is nt takin any parrameter 2 d next page.
b'cs image page is nt takin any value in query string

plz.......tell me d solution.
Title: doubt   
Name: lopa
Date: 2007-05-22 7:58:51 AM
Comment:
im nt getting d image column bt d sno(ID) ids diaplayin.
while workin with data grid.
bt retrieving image is workin while it is nt in grid.

plz.....help me.
Title: A page can have only one server-side Form tag.   
Name: lopamudra
Date: 2007-05-22 6:06:59 AM
Comment:
after running the gridview page. im getting this error msg in browser "A page can have only one server-side Form tag."
i have used form tag in gridview page.
plz..........let me clear abt it.

waiting
lopashree@rediffmail.com
Title: system.configuration   
Name: lopamudra
Date: 2007-05-22 1:16:58 AM
Comment:
hello sir,
Im workin in asp.net 2.0 and vb language. so it's nt takin support of system.configuration. so im nt able to run my code Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
dr = com.ExecuteReader(CommandBehavior.CloseConnection)
kindly give me idea........
Title: System.Configuration   
Name: lopamudra
Date: 2007-05-22 1:05:04 AM
Comment:
Data.SqlClient.SqlConnection(ConfigurationSettings.AppSettings("ConnectionString"))
dr = com.ExecuteReader(CommandBehavior.CloseConnection)

I am getting error in ConfigurationSettings.AppSettings and CommandBehavior.CloseConnection in my aspx. i added namespace System.Configuration.bt it is nt solved.
Kindly tell me wht is the solution?

lopashree@rediffmail.com
Title: Nice explanation   
Name: venkat
Date: 2007-05-16 9:20:56 AM
Comment:
Nice explanation.but i need this one in delphi programing.from few days onwards iam getting this problem .plz help me.thanQ
Title: easy steps for connectivity   
Name: j.c.vivek
Date: 2007-05-15 8:29:49 AM
Comment:
i am beginner for .net.how to connect the database in easy way. and steps to connect the database.
Title: Please help me   
Name: Yogesh Parihar My Email- parihar_yogesh@yahoo.com
Date: 2007-05-15 12:57:09 AM
Comment:
hi sir,
please help me. Iam doing MCA 6 sem project. Project is Online shopping. In that project ,I want to stroe images in database. What is the code for storing & retrive image from Sql Server.My Project Frontend ASP with VBScript & Backend is SQL Server.Again I Specify My project is on ASP not on ASP.Net bcoz.i have solution of abouve problem in .NET but I am working on pure ASP with VBScript.I am totally harassed becoz no one help me at these movement.Please help me sir.
Title: cant display images   
Name: Bimal
Date: 2007-05-10 2:26:36 AM
Comment:
Hi
i'v use your codes for uploading images to successfully. But in displaying images code i got a problem.And iv try to displaying images in readrealimage.aspx page separately and i got this error "System.InvalidOperationException: Byte[][1]: the Size property has an invalid size of 0.".I cant understand this error can u please help me.
Title: how we can bind a text data(notepad) with asp.net plz do mail me with code   
Name: savita Singh
Date: 2007-05-07 6:05:23 AM
Comment:
how to bind text data with datafris then insert into sql server2000.
insert data will be displayed in to sql
Title: how to binding immages in datagrid codeview   
Name: sreedhar
Date: 2007-05-04 7:27:42 AM
Comment:
hi sir i want to lot of immages binding to datagrid how and also plse giveme code.
and the images(person is immage heis having name,place etc) displayed in datagrid
how plase
helpme
Title: problem displaying image   
Name: Veronica
Date: 2007-05-04 6:32:17 AM
Comment:
Hello,

Your code is great but I have a problem. If I leave the where condition out, an image is displayed. But when trying to select a special image none is shown. Could you please give me a hint of what might be wrong? (If I write a number instead of the variable "strImageID" everything works fine)

Thanks a lot and kind regards,

Veronica
(ve.nokta@gmail.com)
Title: pls help me am using c#   
Name: yogarajan
Date: 2007-05-02 12:59:45 AM
Comment:
Hi

i have one doubt abt datagrid (using c#). pls help me

here is my code

//** code start here**

Page_Load event:

DataSet ds = BuildDataSet();
DataGrid1.DataSource = ds;
DataGrid1.DataBind();

private DataSet BuildDataSet(){ DataSet ret = new DataSet(); DataTable dt =
new DataTable(); DataRow dr = null; // Define table column names and datatypes DataColumn dc =
new DataColumn("ID",Type.GetType("System.Int32")); dt.Columns.Add(dc); dc = new DataColumn("Name",Type.GetType("System.String"));
dt.Columns.Add(dc); dc = new DataColumn("Date",Type.GetType("System.DateTime")); dt.Columns.Add(dc); // Fill the table with sample data
for(int i = 1;i < = 10;i++) { dr = dt.NewRow(); dr["ID"] = i; dr["Name"] = "John Smith";
dr["Date"] = DateTime.Now.AddSeconds(i * 10); dt.Rows.Add(dr); } // Return the dataset to the caller ret.Tables.Add(dt);
return ret;}
//**** code end here**
here i have add one more column with link . how can i add?

pls help me. pls send code immd
am waiting for ur reply
i want to be utput looks like this

ID Name Date URL
1 John Smith 1/1/2007 Hyper Link

2 John Smith 2/2/2007 Hyper Link
Title: C# Code   
Name: Silgia
Date: 2007-04-26 6:30:16 AM
Comment:
Code to show the image from sql server (Talking with the Database part).
-----------------------------------------------------------
if (!string.IsNullOrEmpty(this.Request.QueryString["ID"]))
{
int ID = Convert.ToInt32(Request.QueryString["ID"]);
SqlConnection con = (new globals()).Connection;
string str = "select " + BaseClass.NameofField + " from " + BaseClass.NameofTable + " where " + BaseClass.NameofConField + "=" + ID;
SqlCommand cmd = new SqlCommand(str, con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

while (reader.Read())
{
Response.BinaryWrite((byte[])(reader[BaseClass.NameofField]));

}
con.Close();
con.Dispose();
}
Title: problem   
Name: Shilpa
Date: 2007-04-23 8:52:24 AM
Comment:
hi sir,
please help me. Iam doing my sem project. Project is Online shopping. In that project i need to load many images at one time to datagrid. In database i stored only the path and i stored all the images in a folder. What is the code for loading images to datagrid. Please help me sir.

my email id is shilpa8120002000@yahoo.com
thanking u
shilpa
Title: ploblem   
Name: sunny
Date: 2007-04-19 2:34:19 AM
Comment:
sir this code only one image dispaly i want all images display help me my sunny_bindr@yahoo.co.in
Title: Retriving images from database and display   
Name: Rajesh Kumar Singh
Date: 2007-04-14 2:02:10 AM
Comment:
This code has be perfact for retrive image.
Title: problem   
Name: sunny
Date: 2007-04-10 8:48:50 AM
Comment:
you r retive code is not work in data grid so please check the code sql to data grid
Title: Retriving images and display   
Name: Som
Date: 2007-04-09 1:37:35 PM
Comment:
sorry guys...my id is : som4s3@yahoo.com
Title: Retriving images and display   
Name: Som
Date: 2007-04-09 1:36:27 PM
Comment:
anyone can send me c# code
Title: Retrieving image and display   
Name: Sankar Prasad Giri
Date: 2007-04-03 12:16:14 AM
Comment:
This image retrieving code is really perfect and work it very well
Title: retrive the image   
Name: ann
Date: 2007-03-30 4:13:51 AM
Comment:
convert this code in c#
mailid: sshaalini41@gmail.com
Title: Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET   
Name: ann
Date: 2007-03-30 3:08:31 AM
Comment:
can anybody help me how the same code work in c#(ASP.NET)
Title: Displaying imagesq   
Name: Narender
Date: 2007-02-26 6:48:42 AM
Comment:
Hi this is narender. i tried getting the images from the database. but when i want to display all the images which are in the sql database i was not able to show it. my code is showing only the 1st image.Can any one help me out of this problem.And here is my code.



Dim con As New SqlConnection(ConfigurationSettings.AppSettings("GMR"))
Dim cmd As New SqlCommand
strsql = "select * from images "
Dim ds As DataSet
ds = ExecuteDataset(strsql)
Dim dt As DataTable
dt = ds.Tables(0)
Dim row As DataRow
For Each row In dt.Rows
Dim image As Byte()
image = CType(row("imageurl"), Byte())
Response.BinaryWrite(image)
Next
Title: Retrieving Images from SqlServer and displaying in a DataGrid   
Name: sara
Date: 2007-02-22 2:46:22 AM
Comment:
can you please provide the above code in c#,it would be very helpful of u.
mu emailid is sara.j1980@yahoo.com
Title: C# example   
Name: Mathew Philip Palliampil Kandankavu Areeparampu
Date: 2007-02-12 2:19:06 AM
Comment:
Great Example... Please provide the code in C# also..
Title: Hi have a problem   
Name: quine
Date: 2007-02-06 3:01:45 PM
Comment:
Hi have a problem, copy the code but the column image, me there does not stamp(print) the photos, which can be the mistake?
Title: paging datagrid   
Name: Henry
Date: 2007-02-02 3:52:46 AM
Comment:
The code i got to insert and retrieve information in database is good but i can't navigate on the grid please how do i do paging with your the code.Thank you
Title: DMW   
Name: Trainees
Date: 2007-02-02 1:13:32 AM
Comment:
Uncle please write this code in c# language and using grid view in asp.net 2.0.....thankyou
Title: My problem is solved   
Name: Henry seibenimo
Date: 2007-02-01 5:18:33 AM
Comment:
Thanks a lot,my problem of using images with a database is solved .Keep up the good work
Title: Retrive Image   
Name: sachin gupta
Date: 2007-01-30 1:03:50 PM
Comment:
I am Testing in myself Image Retrive from DataBase(SqlServer). But I run only one form. and retrive image.

Like .. In Button1_Click Event Fire And Image show In Image Control.
Title: Good   
Name: Nityanand
Date: 2007-01-30 4:01:46 AM
Comment:
This Is Very Good Example For any Developer and i like to say Thanks Very Much and Happy Programming

Best Regards,
nitya
Title: Comment on this article   
Name: Balaji
Date: 2007-01-24 1:53:57 AM
Comment:
This is best as on the freshers,But only code in vb some better to prefer for c#.
Title: how to retrieve path from database   
Name: ashas
Date: 2007-01-20 12:44:24 AM
Comment:
hello,
I have stored the image's path using htmlinputfile control in asp.net in the Access.and now i want to updata it how can i retrieve the path from the Access to htmlinputfile.
I tried to use htmlinputfile's value property.
Title: Retrieving and Inserting Images   
Name: yesupatham
Date: 2007-01-12 4:12:39 AM
Comment:
Really helpful ! good job !!
Title: Retrieving images from SQL Server   
Name: TN
Date: 2007-01-04 8:52:38 PM
Comment:
Hi, thanks for putting the code online. I tried you code, but for some reason the datagrid does not display the image. I went over the code a couple of times to check for errors. Any suggestions anyone?
Thank you.

nakhjot@optonline.net
Title: wonder!   
Name: sreekanth
Date: 2006-12-22 5:24:09 AM
Comment:
Hi
Iam sreekanth yor code is very simple and understadable
you done grate job. this is usefull for lot of developers
Thank you & keep it up
Title: This Code Works Fine   
Name: harry
Date: 2006-12-11 4:55:55 AM
Comment:
Great JOB, solve my problem
Title: Too many calls to database   
Name: Khurram
Date: 2006-12-05 10:38:28 AM
Comment:
The article is very useful but i have just one remark. Is this a good idea to query the database for each image isnt it too constly??
Like if you are displaying 50 records in your datagrid you will be doing fifty queries to your database for each image???
Title: How do I update the image file?   
Name: Bama
Date: 2006-11-28 11:16:56 PM
Comment:
How do I update the image file in the database after uploading?
Title: Retrieving image from sql server   
Name: kiran
Date: 2006-11-14 4:57:26 AM
Comment:
could anybody can send me code for binding image to image control from sql server.my id is raj_514@yahoo.co.in..
thanks in advance
Title: Retrieving image from sql server   
Name: kiran
Date: 2006-11-14 4:55:56 AM
Comment:
could anybody can send me code for binding image to image control.my id is raj_514@yahoo.co.in..
thanks in advance
Title: How to display full-size image?   
Name: William
Date: 2006-11-12 9:46:54 AM
Comment:
very good artical, but I am confused how to display full-size image in new window? Thanks
Title: Retrieving Images from folder connected with SQL   
Name: Mirko
Date: 2006-10-31 5:24:46 AM
Comment:
Is it possible to write all images to a folder which is located in server and from that folder the image has to be retrived...can u just send me the details...my mail is mirko.radic@inet.hr
Title: gr8   
Name: ANTONY THURUTHEL
Date: 2006-10-30 6:56:00 AM
Comment:
GUD JOB even guys who just started can understand ur example
Title: work   
Name: ssr
Date: 2006-10-28 11:32:48 PM
Comment:
good job done sir thanks
Title: Retrieve Image & Show in Image Control   
Name: Prajyot
Date: 2006-10-19 1:59:43 AM
Comment:
Hi , Your code is very nice but I want to show retrieved Image in Image Control .Plz reply me on prajyot.mahindrakar@rediffmail.com
Title: Programmer   
Name: Saju Vetiyatil
Date: 2006-10-12 10:46:18 AM
Comment:
Dear,

Thanks for posting this . I have used to great benefit.

I would like to add that you can directly write :
<%# "readrealimage.aspx?ID="+databinder.[...].Tostring()#%>

instead of passing it through a function...

My personal E-mail ID is sajuvn@yahoo.com.

Thanking you once again,
Saju
Title: Retrieving images from sql server   
Name: rajeev kumar
Date: 2006-10-12 3:24:54 AM
Comment:
I am not bee able to display image in data grid column header shown instead of images

please help me rajeev_raja2k@yahoo.co.in
Title: asp.net datagrid   
Name: rukmang
Date: 2006-10-11 11:32:57 AM
Comment:
u have helped me alotttttttttt. great programming.
Can u please send me such articles at
rukmang_r@yahoo.com
Title: image with dotnet   
Name: rukmang rege
Date: 2006-10-11 10:06:12 AM
Comment:
too good articles"http://aspalliance.com/articleViewer.aspx?aId=141&pId=". Excellent.keep up the good work

Can you please send me such articles at
rukmang_r@yahoo.com
Title: Newbie question   
Name: Achmad Fienan R
Date: 2006-10-05 1:59:04 PM
Comment:
Hi,
I found out that your articles are useful for me. But can you give me the alternative way to write above code in ASP 2.0 with vb.net 2005? thanks

I am still a newbie, so I'm easily lost

By the way, if you dont mind. can you give me the explanation through my email? Its v_none@lycos.com
Title: Your code doesn't show the image in DG...   
Name: Vivek
Date: 2006-09-24 12:12:28 PM
Comment:
Your code doesn't show the image retrieved from the database in the database. Where is the exact code....
Title: Retreiving Images from Sql Server in ASP .NET   
Name: Manoj
Date: 2006-09-20 8:17:14 AM
Comment:
This code did a good job
Title: How to Display Images in C#   
Name: Shaju
Date: 2006-09-12 9:22:36 AM
Comment:
Really it is very good code. But I want C# code. I am modifiy this code for C# but it canot work FormatURL function. I am writing FormatURL function in first form like "Public string FormatURL(string strArgumet)"Is it corect? Please help me
Title: Retrieving Images from Sql Server   
Name: Ved Prakash
Date: 2006-08-31 8:12:10 AM
Comment:
This is very nice code.
Inquiry: I want to know that can i also join you.
I am working as a Programmer with IT company from last 6 Month.
Title: Retrieving Images from Sql Server   
Name: Kriss
Date: 2006-08-16 2:45:17 AM
Comment:
In datagrid how to display images is ok but if a particular record does not contain image URL then the image for that control does not exist how to avoid the image template by displaying in the datagrid. plz mail me to kriss_is4u@indiatimes.com
Title: Retrieving images from SQL-Server   
Name: lakshmi
Date: 2006-08-15 3:00:17 AM
Comment:
I just want toknow wht is "id"

Function FormatURL(strArgument) as String
Return ("readrealimage.aspx?id=" & strArgument)
End Function

what is "id"

Pls give answer to lak952000@yahoo.com
Title: Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET   
Name: Ericks
Date: 2006-08-13 3:46:57 AM
Comment:
This works of marvel, has extracted me of the difficulty, say to me how I publish the code that I generated with yours
I have difficulty to write this in English, wait that this good
Title: Retrieving Images from Sql Server   
Name: deepthy
Date: 2006-08-11 1:25:11 PM
Comment:
Function FormatURL(strArgument) as String
Return ("readrealimage.aspx?id=" & strArgument)
End Function

Dim strImageID as String = Request.QueryString("id")


In request.querystring("id")- What is id? (Which id)

how to run?
First i shd run readrealimages.aspx and then i shd run datagridimages.aspx
Title: Retrieving Images from Sql Server   
Name: Argie K. San Pascual
Date: 2006-07-16 11:49:25 PM
Comment:
Thankyou Very Much !! It's a very informative article.
Once again Thankyou..
Title: asp   
Name: itua
Date: 2006-07-16 2:19:14 PM
Comment:
Thank you for ue help but i would like to get a code to send emails with asp also
Title: Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET   
Name: Argie K. San Pascual
Date: 2006-07-11 8:53:49 PM
Comment:
Its a very good Code! Thanks...
Title: retrive an image from database   
Name: gayatri
Date: 2006-07-11 4:47:36 AM
Comment:
this is my id gayatri.sheethal@gmail.com plz send me to this id.
anyone can help me waiting for reply
Title: How to retrive image from database by selecting in dropdownlist   
Name: gayatri
Date: 2006-07-11 4:45:00 AM
Comment:
this is nice but i have another dought by selcting the id in dropdown i must get image from database and display in the image control.plz anyone can helpme.
regards gayatri
Title: dot netq   
Name: jay
Date: 2006-07-10 2:46:19 AM
Comment:
hi i know the indepth
Title: Retrieving Images from Sql Server   
Name: Henrique R. Brandao Neto
Date: 2006-06-30 9:24:09 AM
Comment:
thanks a lot for this helpful article, I had only to increment one thing on my code:
ImageUrl='<%# "view.aspx?id=" & System.Convert.ToString(DataBinder.Eval(Container.DataItem, "id")) %>'
Thats because my Photo Code column in our database is integer. I think so. Regards Henrique/Brasil
Title: error at datareader.item   
Name: kranthi
Date: 2006-06-22 8:34:07 AM
Comment:
Response.ContentType = myDataReader.Item("imageType");
Response.BinaryWrite(myDataReader.Item("myimage"));
does not contain identification item
Title: Doubt   
Name: Jhanani
Date: 2006-06-21 2:55:25 AM
Comment:
<%@register tagname="Acme" TagPrefix="LeftMenu" src="use1.ascx"%>.The above statement can't work in Microsoftvisual studio.net

When i write the same in notepad it is working.
So how to write the same statement in codebehind

plz help
jhanani
Title: Good Show!!!   
Name: Ramaraj R
Date: 2006-06-20 1:49:23 PM
Comment:
Hi Guys,

Really appriciated for helping me through this code....
Title: Mr   
Name: naresh
Date: 2006-06-20 7:58:56 AM
Comment:
good but i have some doubts. can u tell me if there is no field with image type. and if it is bitmap can write image type as bitmap
Title: Images in Datagrid   
Name: nagendra
Date: 2006-06-18 6:02:38 AM
Comment:
Hi,
It's really nice code. I have 1 doubt. Plz reply me. We r using ReadRealImage.aspx to retrieve images. why don't we use this code in datagridimages.aspx itself. is it possible ? I tried but failed. plz post code or give idea. Thanks in advance. my id: meet_nagendrap@yahoo.co.in

plz help !!
Title: Unable to display images   
Name: Ani
Date: 2006-06-08 5:35:37 AM
Comment:
I ahve tried to use the same code but i run into the error
The image “http://localhost:1935/ContentKiosk/WidicoServices.aspx” cannot be displayed, because it contains errors.
I am using C# and ASP.NET 2.0
Please reply to anitha.reddykora@gmail.com
Its urgent.Please help
Title: Unable to disaply images   
Name: Ani
Date: 2006-06-08 5:30:16 AM
Comment:
I have used the code which you have used but still i am unable to dispaly the images.The error i get is
The image “http://localhost:1935/Images.aspx” cannot be displayed, because it contains errors.
Title: retrieving images throgh sql server   
Name: vicky verma
Date: 2006-05-29 2:32:21 AM
Comment:
I have sql server 7.0.is that possible to get images in datagrid ifu have sql 7.0 as ur database
Title: Udapte a row with the image displayed   
Name: Salam
Date: 2006-05-24 4:28:28 PM
Comment:
I forgot to give my mail, here it is salam@altern.org
Title: Udapte a row with the image displayed   
Name: Salam
Date: 2006-05-24 6:34:51 AM
Comment:
Well done, very usefull article. I have a DG with update button. When clicking on the update button, I get the following error :
*******************************
Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request
****************************************

Any idea or help would be apprecaited. Thanks in advance
Title: Retriving images from sqlserver and displaying in a datagrid   
Name: suneetha
Date: 2006-05-22 1:33:53 AM
Comment:
Really it is very nice article.
can anybody help me how the same code work in c#(ASP.NET)
if anybody get the result please mail it to
suneetha.chilukuri@gmail.com
Title: funtastic job   
Name: tarun dabral
Date: 2006-05-17 6:49:27 AM
Comment:
its funtastic coding keep it up
Title: Retrieving Images from Sql Server and displaying in a datagrid   
Name: Krupa Shah
Date: 2006-05-05 1:22:44 AM
Comment:
This code was a big help to mee.
I am having problem retrieving all the images and displaying it on the datalist. It only displays one image i.e. 1st in a row.
Could you please reply me on krupabshah@yahoo.com. I will really appreciate that.
Title: problem with data grid   
Name: jm
Date: 2006-04-26 7:23:16 AM
Comment:
hello--the same image is displaying itself over and over again on the grid although I may have different images in there.

i changed the stored procedure associated with this tutorial to the Persons Table from the upload tutorial (not sure why you would make them different)which solved the intial problem of no data showing up however this new problem is a bit perplexing any help would be appreciated.

my email is sodaboy@sodaboy.net
Title: Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET   
Name: Naveen
Date: 2006-04-01 5:27:31 AM
Comment:
Not very Clear
Title: Displaying Images in GridView   
Name: Rahul
Date: 2006-03-20 1:17:45 AM
Comment:
Thankyou Very Much !! It's a very informative article.
Once again Thankyou..
Title: i am facinf this problem in displaying the data in datagrid   
Name: sridhar
Date: 2006-03-18 3:18:59 AM
Comment:
\
\
\
\
Title: Dynamic Image from Single Fields from Database in a Datagrid   
Name: MM
Date: 2006-03-14 9:28:34 PM
Comment:
Hi
Please tell me how to display Images in Datagrid
eg: i have 15 images in my File location field[in the databse] and i want to show this in a datgrid in 3 columns with 5 rows each
--problem is i need to dynamcally create 3 columns with 5 rows[we can give page size-5] i can do it by getting count and adding 3 rows what will happen i have 33[odd]images or 62[even] or any

pls mail to mathew_mathew@mailcity.com
Title: Ing   
Name: fdeel
Date: 2006-03-13 8:14:26 AM
Comment:
Do you have the C# version of your code
Title: Retrieving Images from Sql Server   
Name: Abu Backar
Date: 2006-03-10 1:34:52 AM
Comment:
thanks for the article, it was a big help for. Masantos Nya Bilay Ed Sika Yun Amin
Title: helpful   
Name: Amit G
Date: 2006-02-22 6:02:17 PM
Comment:
helpfull for bigginers
Title: Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET   
Name: ranjan gupta
Date: 2006-02-16 6:07:11 AM
Comment:
Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET
This is fin article


thanks
Ranjan Gupta(Programmer)
Kannu infotech Pvt. ltd
New delhi
Title: Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET   
Name: ranjan gupta
Date: 2006-02-16 5:55:56 AM
Comment:
Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET

Code are not clear,but this is helpfull for bigginers

thanks
Ranjan Gupta
Title: Image Format and Security   
Name: Danny
Date: 2006-02-06 9:16:53 AM
Comment:
Hello Das,

Your article is very informative and thank you. I need help in a couple of areas:
1. Can I save TIFF for the image format?
2. What if I want to save the image on a file system? How can I access it back? I know it is supposed to be simpler, but I'm not ASP.NET expert.
3. Finally, what if I wanted to add security that is authenticated to Active Directory Services? For instance, what if I want to send a link via email to a user and if the user in that machine is authenticated to ADS and has right to the image, I allow retreiving the image from the file system and display it in ASPX. https://mywebserver.com/default.aspx?UserID=uuuuuuuu&Filename=uuuuuuuu_nnnnnnnnnnnn where u=UserID, n=file name with document suffix

please send me an email at danielt@nsius.com
Thank you,
Title: Retriving Images from sqlserver   
Name: Vinayagamoorthi
Date: 2006-02-01 11:08:42 PM
Comment:
Hi,this is good,but is it possible to do all process in the same page itself i.e. reteriving the image from database and directly converting it to image and pass it to datagrid image tag
Title: Dynamic images in a datagrid   
Name: Araceli
Date: 2006-01-31 1:13:27 PM
Comment:
Your article is very helpful, but how can we retreive dynamic images into a datagrid from a file and not from SQL?

Thx.
Title: Retrieving Images from Sql Server   
Name: Manoj Rastogi
Date: 2006-01-13 5:56:40 AM
Comment:
Hi
It is a good code but can u provide me this code in to the C# i m facing the problem when i m sending images from one page(where i m getting my image from tha database) to the anoyher page(DataGrid page where i want to show).
please help me.
Thanks
Title: Retreived image not displaying   
Name: Namita
Date: 2005-12-27 2:53:03 AM
Comment:
I tried this code. Programmatically its giving no error. But instead of image I am getting cross. Pls help me find the solution.
Title: Developer   
Name: Faiq Shah
Date: 2005-12-23 1:34:03 AM
Comment:
Hi
It is informative article.but it works good in Vb.
in C# you have to change the code as . only one change must be made.
FormatURL(DataBinder.Eval(Container.DataItem, "id","")
the extra empty paranthesis r must.
Title: problem   
Name: prasad
Date: 2005-12-22 1:27:44 AM
Comment:
your page contains lot of errors
first of all rectify all that one
next send me "how to retrive images from databases in vb.net"
for forther deatilas
contact no
to mail
Title: how to edit images in datagrid & save to db its urgent.   
Name: anil
Date: 2005-12-09 8:49:39 AM
Comment:
Hi,
The article is good, but I wan how to edit & update these images.
I need it for admin panel to give faclity to user.
I am using ASP.Net with vb.
Need help Its urgent
Title: Attaching this Image while sending mails   
Name: Sudheshna
Date: 2005-12-06 12:34:05 AM
Comment:
I want to attach the retrieved image while sending emails for that what can be done.This code says how it can be written in the browser using response.binarywrite but I want the image that is retrived from the DB to be saved in its name or anyvariable and to be attached with the mails please help me to find a solution.

Sudheshna
Title: Inserting images   
Name: anu
Date: 2005-12-03 12:52:15 AM
Comment:
hai..
I had done insering image to a database and also retriving from Db too..its is working..but i had a doubt that database will get filled due to this.so is it possible to write all images to a folder which is located in server and from that folder the image has to be retrived...can u just send me the details...my id is anu.92001@gmail.com
Title: Examples are very good   
Name: Amit
Date: 2005-10-25 7:47:45 AM
Comment:
Very Nice Code
Title: Can we upload images to dataset   
Name: Chalam
Date: 2005-10-24 1:56:42 PM
Comment:
Hi,
Suppose we want to upload images to a dataset first and then update the database with DataAdapter.Update(ds) after uploading 5 images, how should we go about doing that

You article was quite enlightening
Regards,
Chalam
Title: BETA 2 doesn't support Template Column in DataGrid   
Name: pdm2
Date: 2005-10-17 12:02:30 PM
Comment:
I am trying to use your example in VWD beta 2 but the DataGrid control doesn't support TemplateColumn. It errors with "The active schema doesn't support the element TemplateColumn"

I would be great if someone could find a SQL image solution for GridView instead since it has replace DataGrid, and since the DynamicImage control has been removed from Beta 2.

any takers?
Title: images from sqlserver   
Name: Siva
Date: 2005-10-07 3:21:35 AM
Comment:
hai
i try your code.but the image is not get displayed in the datagrid.when the execution comes here
Response.ContentType = myDataReader.Item("PersonImageType")
it is not moving to the next line just terminate the next line.please help me on this
Title: Navigating in Datagrid   
Name: smb
Date: 2005-09-28 6:16:01 AM
Comment:
I am doing datagrid as navigation control.Is it possible to navigate the image and information,having particulur condition.Can anybody have solution for this.It's Urgent
Title: Thanks   
Name: Madhavan
Date: 2005-09-27 7:03:22 AM
Comment:
Its working fine.
Title: Response To ur Article   
Name: Imransfg
Date: 2005-07-31 6:52:03 AM
Comment:
Really ur article is very simple and explains every thing in good and clear manner. I have got a lot of help from this article. I shall always be thankfull to u.
Title: Retreiving image   
Name: Nhan
Date: 2005-06-30 12:55:00 AM
Comment:
It is very good.
you can show me to check image. if any row haven't an image, object image must (visible=false).
thanks.
Title: I am Unable to Get the Images in Datagrid   
Name: vamshikrishna
Date: 2005-06-29 3:20:37 AM
Comment:
I am getting the image by using response.content & response.binarywrite

but i am unable to get it on to datagrid.

please help me.

i
Title: any idea how to display pic using C#?   
Name: eMilie
Date: 2005-06-28 11:06:47 PM
Comment:
u r so briliant, but i really dono how to make it works using C# as i display the result using XML ADO.net.

can anyone giv me some idea how to solve it?
Title: DataGrid and Images in the .NET   
Name: Ahmad Kasrawi
Date: 2005-06-02 12:12:12 PM
Comment:
To Tell you the truth, it's very hard to insert an image into a datagrid in the web application, because by default the datagrid can not accept an image, So we must create a custom control (DataGrid) which is now a .dll components, So you can download this component from the Computers and Communications Systems web site, or send me an email, and I'll reply by the assembly file (Compnent)
Title: Retrieving SQL images and binding to a datagrid   
Name: mif
Date: 2005-05-19 4:05:41 PM
Comment:
I tried to use the technique you described, although I used a repeater instead of a datagrid. The image was drawn to a separate page and the calling page, which contained the repeater, did not appear. When I clicked on "Back", control was returned to the form that called the repeater page. Can you suggest a solution? Thank you.
Title: Image not displayed in data grid   
Name: pintea
Date: 2005-04-20 3:55:54 PM
Comment:
Values like name,email,sex..are populated into datagrid from the database however image is not displayed. Column header is shown but image is not shown.x is displayed.
Can you help.
Thanx.
Title: Retrieve images from sql server   
Name: Ramji
Date: 2005-04-20 3:27:03 AM
Comment:
It works well but plz tell me abt how to display the retrieved image in image control
Title: what data type ni sql ?   
Name: nhick
Date: 2005-04-18 2:43:08 AM
Comment:
thanks
Title: Retrieving Images from Sql Server   
Name: Stoyanov, Ivaylo
Date: 2005-04-06 8:56:00 AM
Comment:
Can somebody show me, how to make the same, but in C#.
mail me: ivakami75@hotmail.com
Title: .Item() method is not available   
Name: yasir
Date: 2005-04-04 2:40:56 AM
Comment:
hye
i try ur code but didnt find any datareader.Item() method

Response.ContentType = myDataReader.Item("PersonImageType")
Response.BinaryWrite(myDataReader.Item("PersonImage"))


can u tell wts the error ..
plzz
Title: displaying image in a DataGrid - ASP .NET using C#   
Name: Stoyanov, Ivaylo
Date: 2005-04-02 3:53:14 PM
Comment:
Very good code. But can somebody show me how this look like in C#.
Title: how to display an image in imagecontrol retrieved from sql server   
Name: mahesh
Date: 2005-03-22 1:17:26 AM
Comment:
I am working as a asp.net programmer,I am facing a problem with images,Please solve this problem.
Title: Displaying images in datagrid   
Name: Sree
Date: 2005-03-09 10:51:37 AM
Comment:
Hi,
I tried the above code from url http://authors.aspalliance.com/das/datagridimages.html, but iam unable to display the images in datagrid.
Can any body let me know whether image is displaying from database or the path of the image from database.


Thanks,
Sree.
Title: Image Retrive   
Name: kaushal Patel
Date: 2005-03-03 8:59:23 AM
Comment:
Its good ..send me note abt
How to retrive imae from access database
Title: enlarging the image   
Name: smitha
Date: 2005-02-27 12:55:32 AM
Comment:
Hi,

I would like to know how to enlarge the particular image that i retrieved from the database using datalist.Can u help me??
my email id smitha_srn@rediffmail.com
Title: Displaying images of different sizes in a DataList Web Control   
Name: Trevor
Date: 2005-02-24 7:50:30 AM
Comment:
I do something very similar and can display the images with no difficulty. My problem is that the images on the DB are not uniform in size. So how do I change the image size for each image displayed in a DataList?
I can do the resize if the Image control is outside of the DataList, but how do I resize teh Image control for each row in a DataList?
Title: How to make it display a default image if none found in the DB   
Name: Al
Date: 2005-02-23 11:02:59 AM
Comment:
How to make it display a default image if none found in the DB

This code works ok for me but I want it to display another jpg if no file is found in the DB
Title: Its not work. Pls. help   
Name: Charitha
Date: 2005-02-05 11:12:08 AM
Comment:
I checked this code. But it was not work. Please help me.
Send your answer to my email address given bellow.

charithanayanajith@yahoo.com

Thanks.

-charitha
Title: Binding Image   
Name: Imtiyaz
Date: 2005-01-31 2:52:50 AM
Comment:
This is great!!! I have a problem though I need to bind image1 with the image from the database. How do I do that?
I'll appreciate any feed back.
Title: Getting an error   
Name: Programmer
Date: 2005-01-26 4:53:41 PM
Comment:
I could not get the code to work. Please help. i am using c# and having a compilation error:
SqlDataReader does not contain a definition for item.

I changed my code as follow:

Response.ContentType = "image/jpeg"; Response.BinaryWrite(dr.GetValue( 2 ));

The best overloaded method match for 'System.Web.HttpResponse.BinaryWrite(byte[])' has some invalid arguments

Thanks
Title: Using Javascrit menu in user control   
Name: Mubeen
Date: 2005-01-26 5:42:22 AM
Comment:
I am getting problem in using javascript
in user control. I am using top menu, there
are 5 items in that if i place my cursor on
each of this items it displays another second
level menu items in down wards direction, but
here in user control that second level menu items
are hiding behind data grid which i am using here

Please Help me out in this trouble.
Title: Retrieving Images in Datagrid   
Name: Mubeen
Date: 2005-01-26 5:35:56 AM
Comment:
This article is very useful for me.
I had a problem in this earlier but
after using this code it is clear.

Thank u so much.
Title: software engineer   
Name: Senthil Ramachandran
Date: 2005-01-17 6:35:01 AM
Comment:
can you help how to import a excel file to a datagrid using asp .net. I am using oracle 9i as my back end. my email id is senrams@gmail.com
Title: Adding a link to display full image   
Name: andy
Date: 2005-01-13 9:34:47 AM
Comment:
Thanks for this article. It was of great help. I would like to link the displayed image to display the full image... So if you have the code, I would b happy to learn from it.

Regards,

Andy
Title: Retrieving Images from Sql Server   
Name: Dimitar Hrisafov
Date: 2005-01-13 8:35:41 AM
Comment:
It is OK.
But can you display another control on the same page?
I think no.
This is posible if you create DataSet with Store Procedure, generate Crystal report and use CrystalreportViewer control.
This realy works well.
Title: Enquiry, please Help   
Name: Derick
Date: 2004-12-18 4:59:23 AM
Comment:
Response.ContentType = myDataReader.Item("PersonImageType")
Response.BinaryWrite(myDataReader.Item("PersonImage"))

may i know the "PersonImageType" and personImage" is what?
is it a column database table which store the location of the image?
Title: can u help me in retreiving images and assign it to image control   
Name: Rama Lakshmi
Date: 2004-10-27 2:56:21 AM
Comment:
hi,
It is very good code. but i have a problem . its very urgent plz help me.
i have a dropdown box and imagecontrol in a page
list of images will be displayed in dropdownbox. if i select the image, i have to get that image from the database and should be displayed the imagecontrol of same page . i know how to retrieve the image . but the thing i have to assign it to image control

********** ITS VERY VERY URGENT ********
Title: please help me about retrieving pdf document from sql server and displaying it in a datagrid   
Name: Serkan AKTAY
Date: 2004-10-03 6:23:32 AM
Comment:
i've tested your codes.It could display *.jpg or *.gif in a detagrid but couldn't display pdf documen in datagrid.Cam you help me about this problem?
Thanks..
Title: Retrieving images from sql server   
Name: Nizar
Date: 2004-09-21 11:47:39 PM
Comment:
I am seem to be having problem retrieving all the images and displaying it. It only displays one image and it also skips the very first iamge in the table.
Dim myconnection = New SqlConnection("server=Nizar; database=Smashey; uid=sa; password=password;")
Dim myCommand = New SqlCommand("select * from image", myconnection)
Try
myconnection.Open()
Dim myReader As SqlDataReader
myReader = myCommand.ExecuteReader()
myReader.Read()

Do While (myReader.Read())
Dim bytearray() As Byte = myReader.GetValue("2")
Response.BinaryWrite(bytearray)
Loop
myconnection.Close()

Catch SQLexc As SqlException
Response.Write("Read Failed : " & SQLexc.ToString())
End Try

Please Help
Title: Problem with Save Picture As   
Name: juan
Date: 2004-08-21 11:02:15 AM
Comment:
I'm load the image in datagrid but when I try to "Save Picture AS" in the filename appear Image.aspx and when I rename this name and save, this cannot save as .jpg, I write the extension .jpg and work well but this is not my intention, I need to know how this take the .jpg extension automatically when rename the name.
Title: Merging two columns in a datagrid...   
Name: Tellek Liberty
Date: 2004-08-16 5:11:21 PM
Comment:
Hi,
I would like to know if you can merge two columns in a data grid? I know you can do this easily with a dataset or a sql select statement; but, is it possible to do in a datagrid?
Thanks
Title: help me please!!   
Name: kyo
Date: 2004-08-02 12:41:57 PM
Comment:
as I can record the image unfolded in a file jpg
Title: ms   
Name: hylee
Date: 2004-07-21 12:02:39 PM
Comment:
I am considering making use of session scope DataSet variable to persist the blob data .

Do a select statement outfront in one go instead of hitting the table for all images.

any idea about retrieving session scope in .NET?
Title: Retrieving Images from SqlServer and displaying in a DataGrid - ASP .NET   
Name: Tom Regan
Date: 2004-07-09 8:04:28 AM
Comment:
This works well. It works even faster from a .ashx page (if you use a .aspx page you get the overhead of loading the Page class).
Title: Retrieving Images from Sql Server   
Name: Shanu Gulati
Date: 2004-06-28 11:28:28 AM
Comment:
Really it is very good code.
Inquiry: I want to know that can i also join you.
I am working as a Programmer with IT company from last 3 years. I also have lots of experience in VB and ADO.Net






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-03-18 10:41:14 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search