Posts by Weiner Lemes • 462 points
16 posts
-
2
votes2
answers145
viewsA: checkar checkbox of gridview based on database value
Edited response: List<domUsuario> list2 = dao.ListaTodosFilial(this.txtCODUSUARIO.Text); foreach (GridViewRow row in this.dgvACESSOfilial.Rows) { if(row.RowIndex < 0) continue; var values =…
-
1
votes1
answer182
viewsA: Entity Framework Sum and Count different status
If the Loan and Installment tables are well related: var data = new DateTime(2019, 7, 10); var result = conn.Emprestimo .Select(e => new { e.Id, e.Numero, e.ValorEmprestimo, e.Parcela.IdeStatus,…
-
1
votes2
answers112
viewsA: Changing table values using UPDATE CASE
would be two commands: UPDATE participacao SET ativo = 0 WHERE nome = 'luiz' AND equipe = 'A'; UPDATE participacao SET nome = 'carlos' WHERE id = 2
-
6
votes2
answers367
viewsA: Artificial Intelligence for Games in Unity
The head "False Knight" at Hollow Night does not use advanced AI as machine Learning or deep Learning, which are Ias of learning. You can decorate the patterns of bosses with time in Hollow Night,…
-
0
votes3
answers694
viewsA: how do I make a row_number keeping the document number with different plots?
Maybe then it’ll work out: WITH DocumentoLinha AS ( SELECT RC1_DOCREC, ROW_NUMBER() OVER (ORDER BY RC1_DOCREC) AS NumeroLinha FROM RECEBER1 GROUP BY RC1_DOCREC ) SELECT R2.RC2_DOCREC,…
-
4
votes1
answer28
viewsA: SQL performing wrong query
I think the right query would be: SELECT * FROM produtos WHERE quantidade <= quantidade_minima
-
1
votes1
answer37
viewsA: Icollection property in class is not instantiated
It may be that the Firstordefault function is returning null because the Cspitems list is empty, or that the variable s of the lambda expression is null. If you want the Offeruri variable to be met…
-
2
votes1
answer111
viewsA: Chart with horizontal scrolling c#
Just create a control variable for the scrollbar camera: int camera = 0; This part would look like this: for (int i = camera; i < (camera + (pictureBox.Width / 0.2)); i++) and in the scrollbar…
-
-2
votes4
answers2917
viewsA: Filter using only month and year on SQLSERVER
SELECT NOME_CLIENTE, COUNT(NUMERO_BILHETE) AS 'QUANTIDADE DE BILHETES' FROM BANCO.DBO.CLIENTES WHERE YEAR(DATA_EMBARQUE) >= YEAR(@DataInicial) AND MONTH(DATA_EMBARQUE)…
-
0
votes1
answer72
viewsA: How to save value entered by the user in 2 different arrays?
Two control variables are missing, one for the number of items inserted in the C array, and the other for the Kelvin array. Try this way: float tC, tK, storesC[11], storesK[11], calC, calK; int i,j,…
-
2
votes2
answers498
viewsA: C# Read TXT file and delete
Change: sw.WriteLine(linha[1]); for: sw.WriteLine(item.Linha);
c#answered Weiner Lemes 462 -
0
votes1
answer45
viewsA: Consult validity with two dates using Ef 6
db.Documentos .GroupBy(o => new { o.ClientId, o.TipoDocumentId } .Select(o => new { o.Key.ClientId, o.Key.TipoDocumentId, Data = o.Max(d => d.ProximaEmissao) } .Where(o => o.Data >=…
-
1
votes1
answer91
viewsA: Excessive use of pens c#
A 3ms refresh rate is higher than the screen refresh rate either at 60fps (16.6ms) or 120fps (8ms). Even if you force Invalidate every 3 ms, it will not update at the same time. Try to optimize…
-
0
votes1
answer361
viewsA: Graphic creation c#
See if you can help him. Set the Minvalue and Maxvalue and Datacount properties - Amount of data that will come.. Just create a timer and call the Addvalue method every time. using…
-
0
votes1
answer43
viewsA: How to check if the seat is free and if you are not asking the user to type again by inserting an 'X' in the occupied space?
I guess it’s almost over by then. Just add this code already done in a while and create a boolean control variable to terminate the loop. I don’t know if I understand how you’ll manage the seats,…
canswered Weiner Lemes 462 -
1
votes3
answers283
viewsA: No Fill new column as Null, yes with specified value in script
There are two ways: 1) In Sql Management Studio 2017, right-click the table and Design. Select the column you want to set a Default value. In Column Properties, in the General tab, in Association or…