public void FillGridLists() { //Retrieve & fill Grid lists DbCommand oCmd = UpgradeHelpers.DB.AdoFactoryManager.GetFactory().CreateCommand(); int i = 0; oCmd.Connection = modGlobal.oConn; oCmd.CommandType = CommandType.Text; string strSQL = "spSelect_UniformRepairerList "; oCmd.CommandText = strSQL; ADORecordSetHelper oRec = ADORecordSetHelper.Open(oCmd, ""); //fill Repairer for all Uniform Repairers int tempForVar = ViewModel.sprPPEList.MaxRows; for (int x = 1; x <= tempForVar; x++) { ViewModel.sprPPEList.Row = x; ViewModel.sprPPEList.Col = 2; i = 0; while (!oRec.EOF) { ViewModel.sprPPEList.TypeComboBoxIndex = i; ViewModel.sprPPEList.TypeComboBoxString = modGlobal.Clean(oRec["repairer_name"]); i++; oRec.MoveNext(); } ; oRec.MoveFirst(); } //fill Repairer for all Uniform Types strSQL = "sp_GetEmployeeCurrentItemList '" + modGlobal.Shared.gAssignID + "' "; oCmd.CommandText = strSQL; oRec = ADORecordSetHelper.Open(oCmd, ""); int tempForVar2 = ViewModel.sprPPEList.MaxRows; for (int x = 1; x <= tempForVar2; x++) { ViewModel.sprPPEList.Row = x; ViewModel.sprPPEList.Col = 1; i = 0; while (!oRec.EOF) { ViewModel.sprPPEList.TypeComboBoxIndex = i; ViewModel.sprPPEList.TypeComboBoxString = modGlobal.Clean(oRec["UniformType"]) + ": " + modGlobal.Clean(oRec["tracking_number"]); i++; oRec.MoveNext(); } ; oRec.MoveFirst(); } }