public void getProductTypes(string clientID) { try { MySQLBusinessLogic bl = new MySQLBusinessLogic(); DataTable dt = new DataTable(); dt = bl.GetProductType(); if (dt.Rows.Count > 0) { string json = ""; json = ConvertDataTabletoString(dt); Clients.Client(clientID).gotProductTypes(json); } else Clients.Client(clientID).gotProductTypes(""); } catch (Exception ex) { Clients.Client(clientID).gotProductTypes(""); } }