protected void bind()
        {
            string CO_ID = Request.QueryString["CO_ID"];
            List <DAL_CustomerOrder> CO_List = new List <DAL_CustomerOrder>();

            CO_List = obj.GetSingleCustomerOrder(CO_ID);

            tb_ID.Text             = CO_ID;
            tb_CompanyEmail.Text   = CO_List[0].CO_CompanyEmail.ToString();
            tb_CompanyName.Text    = CO_List[0].CO_CompanyName.ToString();
            tb_CompanyContact.Text = CO_List[0].CO_CompanyContact.ToString();
            tb_CompanyAddress.Text = CO_List[0].CO_CompanyAddress.ToString();


            // =============== Gridview =================

            DAL_OrderItem item = new DAL_OrderItem();
            DataSet       ds;

            ds = item.GetAll_OrderItem();
            gv_OrderItem.DataSource = ds;
            gv_OrderItem.DataBind();


            lbl_To.Text = CO_List[0].CO_CompanyEmail.ToString();
        }
        protected void bind()
        {
            string CO_ID = Request.QueryString["CO_ID"];
            List <DAL_CustomerOrder> CO_List = new List <DAL_CustomerOrder>();

            CO_List = obj.GetSingleCustomerOrder(CO_ID);

            tb_ID.Text             = CO_ID;
            tb_CompanyEmail.Text   = CO_List[0].CO_CompanyEmail.ToString();
            tb_CompanyName.Text    = CO_List[0].CO_CompanyName.ToString();
            tb_CompanyContact.Text = CO_List[0].CO_CompanyContact.ToString();
            tb_CompanyAddress.Text = CO_List[0].CO_CompanyAddress.ToString();


            // =============== Gridview =================

            DAL_OrderItem item = new DAL_OrderItem();
            DataTable     ds;

            ds = item.GetAll_OrderItem();
            gv_OrderItem.DataSource = ds;
            gv_OrderItem.DataBind();


            gv_OrderItem.FooterRow.Cells[2].Text = "Total Amount";
            gv_OrderItem.FooterRow.Cells[3].Text = ds.Compute("SUM(OI_Price)", "").ToString();


            lbl_To.Text = CO_List[0].CO_CompanyEmail.ToString();
        }