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();
}
}
