private void Bind()
        {
            BllDelivery myCat = new BllDelivery();
            DataSet     ds;

            ds = myCat.GetDelivery();
            gvDelivery.DataSource = ds;
            gvDelivery.DataBind();
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            int         id    = Convert.ToInt32(Session["id"].ToString());
            BllDelivery myCat = new BllDelivery();
            DataSet     ds;

            ds = myCat.GetDeliveryDetailsByID(id);

            int rec = ds.Tables["Table"].Rows.Count;

            DataRow row            = ds.Tables["Table"].Rows[0];
            string  trackingid     = row["trackingID"].ToString();
            string  weight         = row["weight"].ToString();
            string  deliverystatus = row["deliveryStatus"].ToString();
            string  type           = row["deliveryType"].ToString();
            string  value          = row["TotalValue"].ToString();
            string  poid           = row["PoID"].ToString();
            string  invoiceid      = row["InvoiceID"].ToString();



            //string trackingid = ds.Tables[0].Rows[0]["trackingID"].ToString();
            //string weight = ds.Tables[0].Rows[0]["weight"].ToString();
            //string deliverystatus = ds.Tables[0].Rows[0]["deliveryStatus"].ToString();

            trackingidlbl.Text   = trackingid;
            weightlbl.Text       = weight + " KG";
            statuslbl.Text       = deliverystatus;
            deliveryTypelbl.Text = type;
            valuelbl.Text        = value;
            poidlbl.Text         = poid;
            invoicelbl.Text      = invoiceid;


            if (invoiceid == null || invoiceid == "")
            {
                viewinvoice.Visible = false;
            }
            else
            {
                viewinvoice.Visible = true;
            }
        }