ASP.NET

if (Request.QueryString["ImgID"] != null && Request.QueryString["Orientation"] != null)
{
    System.Int32 _ImgID = Convert.ToInt32(Request.QueryString["ImgID"].ToString().Trim());
    string _Orientation = Request.QueryString["Orientation"].ToString().Trim();
    HttpContext.Current.Session["PrevID"] = _ImgID;
    SqlDataReader thisReader = null;
    SqlConnection thisConn = new SqlConnection(ConfigurationManager.ConnectionStrings["MediaGalleryConnectionString"].ConnectionString);
    SqlCommand thisCmd = new SqlCommand("Command String", thisConn);
    tmpStr = "Select PageImage, PageText from PhotoGallery WHERE RecordID='" + _ImgID.ToString() + "'";

    thisCmd.CommandText = tmpStr;

    try
    {
        thisConn.Open();
        thisReader = thisCmd.ExecuteReader(CommandBehavior.CloseConnection);

        while (thisReader.Read())
        {
            System.Drawing.Image _image = System.Drawing.Image.FromStream(new System.IO.MemoryStream((byte[])thisReader["PageImage"]));

            System.Web.HttpContext.Current.Response.ContentType = "image/jpeg";

            if (Request.QueryString["Orientation"].ToString().Trim() == "Landscape")
            {
                //System.Drawing.Image _newimage = _image.GetThumbnailImage(800, 600, null, new System.IntPtr());
                System.Drawing.Image _newimage = _image;
                _newimage.Save(System.Web.HttpContext.Current.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
            }
            else if (Request.QueryString["Orientation"].ToString().Trim() == "Portrait")
            {
                System.Drawing.Image _newimage = _image; //.GetThumbnailImage(600, 726, null, new System.IntPtr());
                _newimage.Save(System.Web.HttpContext.Current.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
            }
        }
    }
    catch{/*Sanitized*/}
    finally{/*Sanitized*/}
}

<br />
protected void ImageClick_Command(object sender, CommandEventArgs e) <br />
  {<br />
    Response.Write("test");<br />
    <br />
  }  <br />
<br />

fajrif wrote:

i'am retrieving a lot of data from Oracle DB, it's about more than 75000 records.
if the amount of record less than 1500 it works fine and fast,
my problem is if the record number greater than that = the process is taking to long and it will stop because the session is timeout.