private void getTypeAssociatedHardware(String strType) { try { var type = new TypeName(strType); DataTable dt = type.AssociatedDatatableHardware(); grvAvailableHardwareType.DataSource = dt; grvAvailableHardwareType.DataBind(); int intTotalAssociatedCount = grvAvailableHardwareType.Rows.Count; if (intTotalAssociatedCount == 0) { lblProblem.Text = "No available hardware of this type of hardware"; } else { lblProblem.Text = intTotalAssociatedCount + " queries listed out."; } } catch (MySqlException ex) { lblProblem.Text = "MySQL exception occurred: " + ex.ToString(); } catch (Exception ex) { lblProblem.Text = ex.ToString(); } finally { mysqlConnectie.Close(); } }