public void bindgrid()
        {
            BrilliantWMS.WMSOutbound.iOutboundClient Outbound = new WMSOutbound.iOutboundClient();
            try
            {
                CustomProfile profile = CustomProfile.GetProfile();
                DataSet       ds      = new DataSet();
                string        role    = profile.Personal.UserType.ToString();
                if (role == "Super Admin" || role == "Admin" || role == "Warehouse Admin")
                {
                    long userCompany = profile.Personal.CompanyID;
                    ds = Outbound.BindOutboundGrid(userCompany, profile.DBConnection._constr);
                }
                else
                {
                    ds = Outbound.BindOutboundGridbyUser(profile.Personal.UserID, profile.DBConnection._constr);
                }
                grdSalesOrder.DataSource = ds;
                grdSalesOrder.DataBind();

                grdSalesOrder.AllowMultiRecordSelection = true;
                grdSalesOrder.AllowRecordSelection      = true;
            }
            catch { }
            finally { Outbound.Close(); }
        }