protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack)
            return;

        if (Request.QueryString["ProductId"] == null)
        {
            tblProductImage.Visible = false;
            lblMsg.Text = "Sorry you cannot add an image";
            //return;
        }
        else
        {

            dtProductImage = taProductImage.SelectProductNamebyProductId(Convert.ToInt32(Request.QueryString["ProductId"]));

            if (dtProductImage.Rows.Count > 0)
                lblProductName.Text = dtProductImage.Rows[0]["ProductTitle"].ToString();
            else
            {
                tblProductImage.Visible = false;
                lblMsg.Text = "Sorry you cannot add an image";
            }
        }
        if (Request.QueryString["ID"] != null)
        {
            if (Request.QueryString["ID"] == "True")
            {
                lblMsg.Visible = true;
                lblMsg.Text = "Successfully Added";
            }
        }
    }
 public void BindData()
 {
     if (Request.QueryString["ProductId"] != null)
     {
         dtProductImage = taProductImage.SelectProductImagebyProductId(int.Parse(Request.QueryString["ProductId"].ToString()));
         if (dtProductImage.Rows.Count > 0)
         {
             DataList1.DataSource = dtProductImage;
             DataList1.DataBind();
         }
         else
         {
             btnUpdateSortOrder.Visible = false;
         }
     }
     else
         Response.Redirect("Product.aspx");
 }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack)
            return;

        if (Request.QueryString["ID"] != null)
        {
            if (Request.QueryString["ID"] == "True")
            {
                lblMsg.Visible = true;
                lblMsg.Text = "Successfully Edited";
            }
        }

        if (Request.QueryString["ImageId"] != null)
        {
            dtProductImage = taProductImage.SelectProductImagebyImageId(Convert.ToInt32(Request.QueryString["ImageId"]));

            if (dtProductImage.Rows.Count > 0)
            {
                DataRow row = dtProductImage.Rows[0];
                Image1.ImageUrl = "~/thumbnail.aspx?Image=Images/ProductImages/" + row["Image"].ToString() + "&size=100";
                lblLargeImage.Text = row["Image"].ToString();
                txtSortOrder.Text = row["Sort"].ToString();
                txtTitle.Text = row["Title"].ToString();
                txtDescription.Text = row["Description"].ToString();

            }
            else
            {
                tblProductImage.Visible = false;
                lblMsg.Text = "Image Details not found";
            }
        }
        else
        {
            tblProductImage.Visible = false;
            lblMsg.Text = "Image Details not found";
        }
    }