Posts by Carlos Bueno • 46 points
3 posts
-
0
votes1
answer28
viewsA: trying to compile code
Your Host does not support SSL connection, so you have to spell that out in your string Connection. To use mysql without Ssl you have to put the parameter Sslmode=None , like the example below. From…
-
0
votes1
answer161
viewsA: Filter with SQL query from a combobox - c#
Only make a check if the value is filled and if it is null or empty you return to Datatable with nothing. DataTable tabela = new DataTable(); If(String.IsNullOrEmpty(valor)) return tabela;…
-
3
votes2
answers324
viewsA: SQL Select return only one of several
To return only one value of each, without repetition, you must use DISTINCT, the query would look like this: SELECT DISTINCT u.nome FROM usuario u JOIN locacao l ON l.UsuarioId = u.id…