private void populateList()
{
JDBMHN mhn = new JDBMHN(Common.selectedHostID, Common.sessionID);
JDBMHNPalletTableModelAssign mhntable = new JDBMHNPalletTableModelAssign(mhn.getMHNDataResultSet(listStatement));
TableRowSorter<JDBMHNPalletTableModelAssign> sorter = new TableRowSorter<JDBMHNPalletTableModelAssign>(mhntable);
jTable1.setRowSorter(sorter);
jTable1.setModel(mhntable);
jScrollPane1.setViewportView(jTable1);
JUtility.scrolltoHomePosition(jScrollPane1);
jTable1.getTableHeader().setReorderingAllowed(false);
jTable1.setSelectionMode(ListSelectionModel.MULTIPLE_INTERVAL_SELECTION);
jTable1.setFont(Common.font_list);
jTable1.getColumnModel().getColumn(JDBMHNPalletTableModelAssign.SSCC_Col).setPreferredWidth(132);
jTable1.getColumnModel().getColumn(JDBMHNPalletTableModelAssign.Material_Col).setPreferredWidth(68);
jTable1.getColumnModel().getColumn(JDBMHNPalletTableModelAssign.Batch_Col).setPreferredWidth(75);
jTable1.getColumnModel().getColumn(JDBMHNPalletTableModelAssign.Process_Order_Col).setPreferredWidth(82);
jTable1.getColumnModel().getColumn(JDBMHNPalletTableModelAssign.Quantity_Col).setPreferredWidth(80);
jTable1.getColumnModel().getColumn(JDBMHNPalletTableModelAssign.Uom_Col).setPreferredWidth(35);
jTable1.getColumnModel().getColumn(JDBMHNPalletTableModelAssign.Date_of_Manufacture_Col).setPreferredWidth(120);
jTable1.getColumnModel().getColumn(JDBMHNPalletTableModelAssign.SSCC_Status_Col).setPreferredWidth(100);
jTable1.getColumnModel().getColumn(JDBMHNPalletTableModelAssign.Batch_Status_Col).setPreferredWidth(95);
jTable1.getColumnModel().getColumn(JDBMHNPalletTableModelAssign.Location_Col).setPreferredWidth(88);
jTable1.getColumnModel().getColumn(JDBMHNPalletTableModelAssign.MHN_Col).setPreferredWidth(80);
jScrollPane1.repaint();
JUtility.setResultRecordCountColour(jStatusText, jCheckBoxLimit.isSelected(), Integer.valueOf(jSpinnerLimit.getValue().toString()), mhntable.getRowCount());
}