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();
}
}
