Posts by i_melo • 75 points
8 posts
-
0
votes1
answer45
viewsQ: Count SQL repeats with INTERSECT and COUNT
I have an SQL table with hundreds of data, and I would like to introduce an array, the same be compared with this table and it is informed how many repetitions occurred. (Table --> EVENT | DADOS1…
-
0
votes1
answer66
viewsA: How to concatenate an SQL Server statement?
After much research I found the final function DECLARE @nota1 INT DECLARE @nota2 INT DECLARE @posicao1 INT DECLARE @posicao2 INT SET @nota2 = 2 WHILE @nota2 <= 20 BEGIN SET @nota1 = 1 WHILE…
-
0
votes1
answer66
viewsQ: How to concatenate an SQL Server statement?
I have a table in SQL Server Management Studio in which I have the fields test | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 Create a for loop in Visual Studio’s C# in another table that counted how many…
-
2
votes2
answers112
viewsQ: How to select 2 records in an SQL Table in a given sequence?
I have a table with 100,000 records and the fields: id | dia | chuva_manha | chuva_tarde | chuva_noite I would like to create an instruction that consults the table and counts how many times a given…
-
0
votes2
answers573
viewsQ: Doubt how to send calling a method in another class
I have a cl_Calculo class that has a method that calls a table in sql by a CRUD class already created, and I want in a Form when clicking a button to call the method of this class passing the sql…
-
1
votes1
answer136
viewsQ: C# - How do I check if 2 arrays have one or more numbers in common?
How do I find that in the numbers of 4 Textbox that are in the array numeros, are on the array impares or pares, what are these numbers and how many are odd and how many pairs? int[] numeros = new…
-
0
votes2
answers491
viewsA: Dynamically provide buttons
Thanks for the help, with your help and searches I got the desired result: namespace teste3 { public partial class Form1 : Form { int Dias; int Horarios; private Button[][] botoes = new Button[3][];…
-
3
votes2
answers491
viewsQ: Dynamically provide buttons
insert the description of the image here.You can find out how I can through a textbox insert a numerical value, and with this value x make visible x buttons of y. ex. if I type 3 in the textbox, the…