Posts by Bruno Warmling • 1,540 points
98 posts
-
0
votes1
answer38
viewsA: How do you get the AM out of a date that doesn’t follow a pattern?
See if one of these solutions solves. Convert with AM/PM: TO_DATE('3/1/2020 12:00:00 AM', 'MM/DD/YYYY HH:MI:SS am', 'nls_date_language=american') Convert with month in writing: TO_DATE('01 March…
-
0
votes2
answers24
viewsA: Operation using another table field
The error occurs because in your subselect you are making a filter for the main table product. And since you did not indicate that the query should be grouped by code, you end up having this problem…
-
0
votes1
answer32
viewsA: Work with dates and times in a table
Data type DATE allows data display in format YYYY-MM-DD I am correct? Yeah and no, the guy DATE stores a date in the database, so viewing will depend on who is dealing with this data. How I would…
-
1
votes1
answer27
viewsA: How to use if with Eventlistener
You can use the event mouseleave which will be executed when your cursor is over your element. Example: document.getElementById('caracters').addEventListener('mouseleave', () =>…
web-applicationanswered Bruno Warmling 1,540 -
0
votes1
answer38
viewsA: Exception error Calling
Include the rest of the directory next to the file name: $curPath = (Get-Location).Path $inFile = $curPath + "\test.ps1" $outFile = $curPath + "\testcrypted.ps1" Import-Module ./xencrypt.ps1…
powershellanswered Bruno Warmling 1,540 -
0
votes1
answer54
viewsA: Use a form int variable in another form C#
You can do it in many ways. One of them is to pass the values in your form constructor: //Isso você faz no Form1 private void button1_Click_1(object sender, EventArgs e) { //Aqui você constrói o…
-
1
votes1
answer48
viewsA: Script deleting other html elements
You are removing because you registered the event in your Form. And whenever the message exists, by clicking on anything it will be deleted. Because your condition will always be true. You can…
jqueryanswered Bruno Warmling 1,540 -
0
votes1
answer57
viewsA: Incrementing Progressbar with a Timer causes a Visual Bug! The Progress only carries half but the value is FULL! c#
According to this response from ONLY. This is a known problem of Windows. The C# uses the component ProgressBar window native. Starting with Windows 7, more "soft" animations were made on the…
-
2
votes1
answer253
viewsA: Help with Trigger Mutating
The mistake ORA-04091: table is mutating happens when you try to access a table that is being modified within a trigger. This means that at runtime any attempt to directly access one of these tables…
-
0
votes1
answer121
viewsA: C# - Problems with Scriptmanager after Response
When you send a downloadable document to the user, you cannot mix the information in your response. This means that you cannot have part of the answer being a document and another HTML part. That’s…
-
1
votes3
answers137
viewsA: SQL Query - ORA-01795
If you create a type parameter CLOB and assign your list as the value of this parameter, you can divide this list in runtime, through a few tricks with CONNECT BY and there will be no need to create…
-
2
votes2
answers140
viewsA: How to return error message with API
Change the method signature to return one IActionResult and put your user feedback within the method OK. [HttpGet] public IActionResult GetAll() { try { return Ok(userRepository.GetAll()); } catch…
c#answered Bruno Warmling 1,540 -
2
votes2
answers74
viewsA: SQL EMAIL PATCH
I would suggest using other tools that SQL offers you. Instead of using the regexp_instr and regexp_replace, try to use simpler functions such as substr,instr,like I made an example that would be…
-
0
votes1
answer244
viewsA: How to catch the monitor serial via code
On Windows, I would recommend you to search for this information using wmi. Import the reference below: Imports System.Management And search the serial data using the table Wmimonitorid: Dim…
-
0
votes2
answers44
viewsA: Doubt group by oracle
Make a with or place this information in a sub-query between your columns: Example 1: WITH ultima_entrada AS( SELECT fk_empregado, MAX(entrada_posto) entrada_posto FROM tb_empregado_no_posto GROUP…
-
0
votes0
answers54
viewsQ: Nuget package does not point to the installed package
I have an app, just like a package Nuget. The package in question is the: System.Net.Http This application has the target framework set to .NET Framework 4.7.2. When checking in the project to where…
-
0
votes1
answer112
viewsA: c# - How to close a specific instance of internet explorer?
Add the reference to Microsoft Internet Controls in the COM tab. Add in usings the reference to the previously imported library. using SHDocVw Then do it this way: const string janelaParaFechar =…
-
2
votes3
answers1361
viewsA: C# Manipulate Postasync Response
Install the nuget package FakeItEasy, create a fake of HttpClient. A simple example would be something like this: private HttpClient CreateFakeHttpClient() { var fakeHttpClient =…
-
1
votes3
answers249
viewsA: DOUBT IN SQL -TURN ROWS INTO COLUMNS
Use the function PIVOT to bring your rows in columns: Example: SELECT * FROM (SELECT 1 codigo, 'Carro' nome FROM dual UNION ALL SELECT 2 codigo, 'Moto' nome FROM dual UNION ALL SELECT 3 codigo,…
-
2
votes1
answer30
viewsA: How to join sublists with Linq
I don’t know if using Constains is the best way, since in your Pedido no reference to the ItemPedido, but you can do it this way: var resultado = from i in pedidos.SelectMany(e => e.Itens) from p…
-
3
votes4
answers491
viewsA: Print values of a vector without line break
The function Console.WriteLine writes and breaks line. In this case, use the function Console.Write, who just writes what you want. Example: Console.Write(numeros[i] + " ");…
-
0
votes3
answers215
viewsA: Problems with connectionString in ASP.NET C# CORE
In accordance with that response from the OS, you need to add the nuget package System.Configuration.ConfigurationManager to your project. After that, you access the ConfigurationManager through the…
-
0
votes2
answers375
viewsA: How to insert and execute parameters in a precedent in oracle 11g in vb6
Include the nuget package Oracle.ManagedDataAccess in your project (This is a driver connection to the database Oracle). Import these two namespaces into your code: Imports…
-
1
votes1
answer29
viewsA: Why does my "th" tag have space between the columns after I apply background?
It is because the <table> by default has the property cellspacing defined in 1. This 1 is the space... set to 0 that will solve. <table cellspacing="0"> ... </table>…
-
1
votes1
answer23
viewsA: Select in Mysql
Use the LEFT OUTER JOIN to bring the data, even when one of them is NULL: SELECT cidade.nome, ppref.nome as Prefeito, pvice.nome AS Vice FROM cidade LEFT OUTER JOIN pessoa ppref ON cidade.idPrefeito…
-
2
votes1
answer60
viewsA: Insert not exist duplicating records
Look, on your temporary table you have 1:N. That is, each TokenId may appear several times. If you want to enter them only once, you could group the data, taking the last record of each. The fact is…
-
2
votes1
answer50
viewsA: How to put 'Ws:' only in the first xml node of a WCF service request?
I wonder how I do so that only the knot <Registar> stay with 'Ws:' <ws:Registar> on your tag? Yes, you can define that your DTO does not have a namespace. Through the properties of the…
-
0
votes2
answers1062
viewsA: Add-Migration does not work on EF Core 3
According to what is informed by the error: System.Missingmethodexception: No parameterless constructor defined for type 'Devio.Data.Context.Meudbcontext' You need to create a constructor with no…
-
0
votes1
answer43
viewsA: C# How to pass service and model to a search window
You chose to use the generics in c#, but did not give more information to the compiler than you "want" or expect with this tipo... Thus the compiler interprets his tipo, just as a simple object, so…
-
3
votes1
answer1613
viewsA: How to Add DLL to Visual Studio? (Unconventional form)
From what I’ve seen, what you’re really trying to do is just include a file in your project. You should open the folder of your project, inside the same visual studio. Right-click on your project…
-
2
votes1
answer951
viewsA: Thread error: Control accessed from a thread that is not the one in which it was created
This happens because your event is running in a thread and its controls were created in the thread main. Unfortunately you cannot access them directly in your thread. The most correct way to solve…
-
0
votes2
answers73
viewsA: Error calling webmethod
As in your signature Webservice you expect only one string, is exactly what you should go through when consuming it via javascript. When sending data via javascript thus: JSON.stringify("{…
-
3
votes1
answer73
viewsA: Get-Nettcpconnection bring the event Count
Goes below: "" + (Get-NetTCPConnection | where { $_.RemotePort -eq 443}).Count + " - " + (Get-Date)
powershellanswered Bruno Warmling 1,540 -
0
votes1
answer679
viewsA: How to use Max() and Count() function together?
I read from the comments that you’re trying to do this on Oracle. You can do it this way: /*Cria o agrupamento por descrição*/ WITH dados AS ( SELECT clfdescricao, MAX(COUNT(n.nfe_id)) cnt FROM…
-
0
votes1
answer150
viewsA: Get line data after button click on an ASP.NET Repeater
This is the solution as you are doing: protected void btnEditar_Click(object sender, EventArgs e) { //Busca o item do seu repeater var rptItem = (RepeaterItem)((Button)sender).Parent; //Busca os…
-
0
votes4
answers1276
viewsA: How to get the amount of records from a Datareader?
By changing the execution behavior of your command, you can get the total of rows your query has executed, through the property RecordsAffected. See below: using (var reader =…
-
1
votes2
answers485
viewsA: Functionality of ! Ispostback
In . net Webforms there are 2 flags indicating how the request was made for your page. They are: IsPostBack and IsCallback. These two flags are used to implement logic for your code, through the…
-
3
votes1
answer88
viewsA: Extract parameters from an SQL query
Can be done using regular expressions: string query = "SELECT * FROM TABELA WHERE CAMPO1 = :PARAM1 AND CAMPO2 = AND CAMPO2 = :PARAM2"; Regex regex = new Regex(@"(:+)(\S+)", RegexOptions.Compiled |…
-
0
votes1
answer36
viewsA: Error deleting with Restapi and dot net core 3
In case you are looking for an Array of um here: var um = await _repo.GetAllUMAsyncByIdL(UmId); // aqui retorna um array and passing the array on delete rather than spend an Entity alone: if(um ==…
-
1
votes1
answer139
viewsA: How to take the record value according to its position number in SQL SERVER
The function Row_Number() is a window function, you cannot use it directly on where of your select. What you can do is something like this: SELECT @fkid = r_id FROM (SELECT Row_Number() over(ORDER…
-
1
votes1
answer202
viewsA: Dynamically referencing dll C#
a question has arisen whether it is possible to load the dll based on the version user-selected Yes it is possible, however if you load a dll by reflection, everything you do, will have to be done…
-
1
votes1
answer102
viewsA: Error while refreshing report Viewer C#
Add Datasource as follows: //limpa datasources reportViewer.LocalReport.DataSources.Clear(); //carrega relatório using (var st =…
-
1
votes1
answer213
viewsA: C# Backgroundworker
Probably on the property CaminhoArquivo or in the method ConectaDBF you are searching for the values of the screen. I am assuming this because information is missing from your code snippet. But the…
c#answered Bruno Warmling 1,540 -
1
votes1
answer147
viewsA: How to compress files into multiple files with specific sizes?
Using the Ionic.Zip library you can do this. But you will create new compact files containing your compressed files. public static void ComprimirEmPartes(string diretorio, string arquivoSaida) {…
c#answered Bruno Warmling 1,540 -
0
votes1
answer147
viewsQ: How to compress files into multiple files with specific sizes?
I have several files in one folder, these files are already . zip files, . 7zip, . rar... To facilitate the work of handling these files, I wanted to divide them into smaller files using c#. Is…
c#asked Bruno Warmling 1,540 -
0
votes1
answer1174
viewsA: How to pass Json parameters, to consume a C#API
Try to do something like that. It’s simpler and it should work: public string FazerTransferencias() { var data = new { receiverEmail = "[email protected]", amount = 1, description =…
-
4
votes2
answers405
viewsA: Daylight saving time at Jenkins
Youngsters, I solved the problem by updating JDK timezones using Tzupdater. The problem isn’t really with Jenkins, it’s with his JDK. Following link:…
-
4
votes2
answers405
viewsQ: Daylight saving time at Jenkins
I have an instance of Jenkins running on a Windows Server 2016 and this server is on time. I have some Jobs set up to run with specific time, but they are running a one hour early, as if with…