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