images Search from Database using sessions

[usmaaan]

I am facing a problem which is that when i search image from database then it just shows last image which is stored in the database.
my code is

private void Images()
        {
 
            SqlConnection con = new SqlConnection("Data Source=chusman-pc;Initial Catalog=Hotel_Management;Integrated Security=True");
            con.Open();
 
            SqlCommand com = new SqlCommand();
            com.CommandType = CommandType.StoredProcedure;
            com.CommandText = "Images_Search";
            com.Parameters.AddWithValue("@Type", DropDownList3.Text);
 
 
            com.Connection = con;
            SqlDataReader r = com.ExecuteReader();
 
 
            while (r.Read())
            {
                Image1.ImageUrl = (string)r["Images"];
                //Image1.ImageUrl = r["Images"].ToString();
                Session["Id"] =   r["Project_id"];               
                r.Read();
            }
 
            con.Close();
 
        }

I call this function at SelectedIndexCh anged of dropbox..
kindly tell me the issue..

[Rabbit]

In your query, have it select just the top 1 record and sort by the insert date in descending order.

That's as specific as I can get because you didn't give us the table design or the query you're running.

[usmaaan]

My Query Is

USE [hotel_man]
GO
/****** Object:  StoredProcedure [dbo].[Images_Search]    Script Date: 02/14/2013 20:37:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 
ALTER PROCEDURE [dbo].[Images_Search]
@Type as varchar(50)
AS
BEGIN
    select Images, Project_Id   from  dbo.Images   where Type = @Type order by Sorting_Id asc
 
 
 
 
 
END

[Rabbit]

Please use code tags when posting code.

You didn't implement any of my suggestions in my first post.

[Mikkeee]

First off, how many records are being returned? You're in a while loop which will loop through all your records and will set your image and sessionid many times until it gets to the end. (you also have an additional r.Read() in your while loop which should be removed. Rabbit's TOP 1 will work perfectly or you need to bail out of your while loop after the first record is read.