private void BindGrids()
 {
     try
     {
         DepartmentPPETableAdapters.DepartmentPPESelectCommandTableAdapter ta = new DepartmentPPETableAdapters.DepartmentPPESelectCommandTableAdapter();
         gvPPE1.DataSource = ta.GetDepartmentPPEByDeptId(int.Parse(ddlDepartment1.SelectedValue), int.Parse(ddlCompany1.SelectedValue));
         gvPPE1.DataBind();
         gvPPE2.DataSource = ta.GetDepartmentPPEByDeptId(int.Parse(ddlDepartment2.SelectedValue), int.Parse(ddlCompany2.SelectedValue));
         gvPPE2.DataBind();
         HideTransferButtons();
     }
     catch
     {
         //this is needed as some time the ddls are not set.
     }
 }