private void updateBookImagePanel() { try { SqlDataReader dataReader = (SqlDataReader)DatabaseProcedures.GetProductsByCategory((ddlBookName.SelectedItem.Text.ToString().Trim()), conn); while (dataReader.Read()) { lblBookTitle.Text = dataReader["Title"].ToString(); lblUnitPrice.Text = "$" + dataReader["UnitPrice"].ToString(); lblShortDescription.Text = dataReader["ShortDescription"].ToString(); lblLongDescription.Text = dataReader["LongDescription"].ToString(); lblBookAuthor.Text = dataReader["Author"].ToString(); lblBookRating.Text = dataReader["Rating"].ToString() + " stars"; imgBookImage.ImageUrl = "../images/books/computer_books/" + dataReader["ImageFile"].ToString().Trim(); lblDiscount.Text = dataReader["Discount"].ToString() + "%"; lblPreorder.Text = "$" + dataReader["PreOrderPrice"].ToString(); lblPrintLength.Text = dataReader["PrintLength"].ToString() + " pages"; } dataReader.Close(); conn.Close(); } catch (SqlException sqlErr) { //Response.Write(sqlErr); Debug.Write(sqlErr.Message); } catch (Exception excpt) { Debug.Write(excpt.StackTrace); } finally { conn.Close(); } }