private void BindDropDowns()
        {
            DataSet dsDLLData = SqlHelper.ExecuteDataset(Global.PFCERPConnectionString, "[pWhseShipListFrm]",
                                                         new SqlParameter("@source", "getdropdowns"),
                                                         new SqlParameter("@searchFilter", ""));

            if (dsDLLData != null)
            {
                ddlBind _ddlBind = new ddlBind();
                _ddlBind.ddlBindControl(ddlLocation, dsDLLData.Tables[0], "LocID", "Name", "", "");
                ddlLocation.Items.Insert(0, new ListItem("ALL", ""));

                _ddlBind.ddlBindControl(ddlUserId, dsDLLData.Tables[1], "UserId", "Name", "", "");
                ddlUserId.Items.Insert(0, new ListItem("ALL", ""));
            }
        }