Posts by Focos • 557 points
13 posts
-
1
votes1
answer65
viewsQ: How to unite results of queries without mixing them?
How can I join 2 query results without mixing them? For example: The first query results in names starting with Victor, the second results in names containing Victor. Result of first consultation:…
-
2
votes1
answer37
viewsA: Panel that changes size C#
Change the event MouseLeave in this way: private void panel1_MouseLeave(object sender, EventArgs e) { if (panel1.GetChildAtPoint(panel1.PointToClient(MousePosition)) == null) { panel1.Size = new…
-
2
votes4
answers587
viewsA: How to correctly send the value of a null variable in an INSERT?
Check whether the parametro2 is empty if you have a pass NULL, otherwise pass the value of parametro2. await b.EnviaMySQLInsert($"INSERT INTO tabela(parametro1, parametro2) " +…
-
2
votes1
answer85
viewsA: Searching between two dates
Test like this: SELECT `ID_Pacote`, `Nome`, `peca`, `Quantidade`, `Data_entrada`, `Data_saida` FROM `pacote` WHERE data_entrada between @data1 and @data2.
-
3
votes1
answer105
viewsA: Error concatenating more than 9 C#files
Answer Change the line: string[] files = e; for: var files = e .OrderBy(f => new string(f.Where(char.IsLetter).ToArray())) .ThenBy(f => { int number; if (int.TryParse(new…
-
3
votes1
answer30
viewsA: Problem with checkedListBox + drag-n-drop
Unfortunately there are not many solutions. There is a gambiarra that works partially. Remove the event MouseDown and enter the event MouseMove in this way: private void…
-
2
votes1
answer37
views -
3
votes1
answer111
views -
1
votes1
answer109
viewsQ: How to resize 2 Datagridview equally?
I have a form with 2 DataGridView and when resizing the form I can only resize 1 of DataGridView on all sides (with anchor 4 sides) without overlapping the other side DataGridView. Taking the image…
-
1
votes1
answer56
viewsA: How to Open Another Form by Double Clicking on the Cell
Use the event MouseDoubleClick. Check if it is the "Game Type" column using the If. Pass as parameter the Id of the "Game Type" and use it on the screen EquipasLOL. private void…
-
6
votes5
answers5490
views -
1
votes1
answer125
viewsA: How to add reference information in Visual Studio 2017?
Tools → Options → Text Editor → All Languages → CodeLens or Ferramentas → Opções → Editor de Texto → Todos os Idiomas → CodeLens Codelens is not available in the Community Edition. However, Codelens…
-
2
votes2
answers697
viewsA: Problem renaming column in Sql Server table
From what I understand, you want to remove the brackets from the column name. To remove the brackets from the column name just insert quotes before the first bracket and after the last bracket. As…