Posts by Evandro • 410 points
40 posts
-
0
votes1
answer34
viewsA: Add Count to a query
Simple solution using OVER() SELECT D.NM_DIETA, count(*) total_dieta, SUM(COUNT(*)) OVER() total, obter_ds_setor_atendimento(s.cd_setor_atendimento) DS_SETOR FROM ATENDIMENTO_PACIENTE_V V INNER JOIN…
-
0
votes1
answer34
viewsQ: Add Count to a query
Good morning, I’m trying to sum up a Count in a query that returns three columns in the oracle the total diet column being the event count for that group! NM_DIETA TOTAL_DIETA DS_SETOR Extra: fruit…
-
2
votes2
answers75
viewsQ: Get specific value in a txt file
I am trying to get two specific values on each line of a txt file. As an example: 15/06/2016 R$ 638,69 R$ 2.562,46 15/07/2016 R$ 672,43 R$ 2.533,51 15/08/2016 R$ 658,93 R$ 2.504,75 15/09/2016 R$…
-
0
votes0
answers400
viewsQ: Webdriver Firefoxdriver Selenium download file
I am automating the download of a file .xlsx of a website with Selenium with the FirefoxDriver but I can’t interact in the download pop-up of the site! There’s how I interact with the pop-up by…
-
0
votes1
answer406
viewsQ: Webdriver Firefoxdriver, run checkbox click
I am creating a robot to log into a page, mark a checkbox and download an export file. However I am not able to run checked in a checkbox. I am using Selenium Webdriver with Firefoxdriver with the…
-
0
votes1
answer146
viewsQ: SELECT GROUP BY AND ORDER BY Sql
I have two tables Tb_process and Tb_costs united by key Numeroprocesso. I need lists of their union information sorted by Urgency and Date status. When urgent, they should be listed at the top of…
-
1
votes0
answers22
viewsQ: Ajax Control Toolkits does not run on the Azure Web App
I have an app WebForms .aspx with Ajax component controls Ajax Control Toolkits, that runs perfectly on the local machine! But when I publish on the Azure Web App server, the controls don’t work…
-
1
votes1
answer2568
viewsQ: String size exceeds the value set in the maxJsonLength property
I’m trying to generate a file Json from a SELECT of the SQL SERVER 2016 table. There are about 4713 rows, this is exceeds the value set in the property maxJsonLength. I can exceed that set value?…
-
0
votes1
answer646
viewsQ: Modal boostrap inside Updatepanel after event click dark background
I have a modal boostrap Poup within a component ASPX UpdatePanel inside that modal I have a button ASP btnEditar with event click to perform a update. After executing the event the modal closes but…
-
3
votes2
answers5957
viewsQ: Print HTML page keeping the page CSS
Good afternoon guys, I have a report that is generated on a page aspx with bootstrap and CSS. The content of the report is within a div <div id="pdf2htmldiv">...</div> where I call…
-
0
votes0
answers465
viewsQ: Problems with OPENROWSET in SQL Server 2016 Express (64bit)
Good morning, I’m trying to read an Excel file . xls by the OLEDB driver used in SQL Server for integrations with Microsoft.ACE.OLEDB.12 files. 0 in SQL Server 2016 Express (64bit). Using command…
-
0
votes2
answers1024
viewsA: Update Updatepanel after running ajax without page refresh
As the tips of @Virgilio I solved the issue in a way not very elegant but functional: I added the event OnTextChanged in the TextBox within the Repeater: <asp:UpdatePanel ID="UpdatePanel1"…
-
0
votes2
answers1024
viewsQ: Update Updatepanel after running ajax without page refresh
Good afternoon, I need to update components that are inside a UpdatePanel page aspx after insertion via Ajax. The Ajax performs a function on code-behind in C#, and happens to reload the entire…
-
0
votes1
answer695
viewsA: Webcontrol input text mask
You could use javascript example: <script language="JavaScript" type="text/javascript"> function mascaraData(campoData){ var data = campoData.value; if (data.length == 2){ data = data + '/';…
-
0
votes1
answer272
viewsA: Referencing non-static object in a static method
According to the staff tip I set the table html with the information in return JSON of the call Ajax, see how it turned out: <script type="text/javascript"> function GetData(andamento_id) {…
-
1
votes1
answer1732
viewsQ: Return Datetime Json /Date(1519339100637)/
Good evening, I’m working with Ajax to return a json containing a data in the format Datetime but I’m getting in string format /Date(1519339100637)/. How can I convert to date and time format…
-
0
votes1
answer272
viewsQ: Referencing non-static object in a static method
Good evening, I need to reference a component PlaceHolder Asp.Net in a static method in the code-behind C#, this method is called via AJAX for front-end see the code: Method call by the Form aspx…
-
0
votes2
answers436
viewsA: Bootstrap message, apply Location.Reload upon termination message
I made a redirect as wmsouza comment, worked as wanted thank you! setTimeout(function () { $("#alert_div").fadeTo(500, 0).slideDown(500, function () { $("#alert_div").remove(); window.location.href…
-
0
votes2
answers436
viewsQ: Bootstrap message, apply Location.Reload upon termination message
Good afternoon, I’m trying to apply location.reload at the end of a messagebox after effect .remove() 2 seconds but I’m not familiar with the javascript someone could help me with the code: function…
-
0
votes1
answer174
viewsQ: Get Textbox value inside the Repeater with Javascript Event Onchange
Good afternoon, I’m not getting past the value of a TextBox asp.net created within a Repeater as a parameter for a function javascript event onchange. I need to pass two parameters the first is one…
-
1
votes1
answer221
viewsQ: Block typing Textbox field with Calendarextender
Good afternoon, I need to block the typing of the date in a field Textbox Asp.net. It can only receive the date selected in the Xtender application to the Textbox. Would someone have some way via…
-
0
votes0
answers145
viewsQ: Website slowness when using Signalr for notifications
Good morning, I’m developing a website to run in local intranet format on IIS. With technologies asp.net ADO in format WebForms, I’m using the library SignalR to monitor a simple table on SQL Server…
-
0
votes0
answers90
views -
0
votes2
answers322
viewsQ: Procedure delete Join between tables
Good afternoon, I have the following Tb environment.Client where a client has N processes in Tb.Process, N movements in Tb.Progress and N attachments in Tb.Annex. I need to mount an sql statement…
-
-1
votes3
answers158
viewsA: Doubt about sql query
Just add one more filter: SELECT * FROM Paciente WHERE ClinicaID = 3 AND Ativo = TRUE
-
-1
votes2
answers1487
viewsA: Save Image in Database with C#
Try like this Diego: // Getting URL of the file to be downloaded and destination path // of the same string urlArquivo = "http://www.minhapagina.com.br/imagens/foto.png"; string caminhoArquivo =…
-
2
votes1
answer142
viewsQ: Ratio 1:N check date, difference 6 month
I am developing a SQL Server Database, which lists two tables: Where a process has N movements, I need to return the following data: all Process that have the column Irrecuperavel(int) = 1 and that…
-
2
votes2
answers1142
viewsA: How to Increase Time Timeout webForm
Anderson if you change the value <sessionState timeout="1440"></sessionState> will have 24 hours... 360 6 hours. <sessionState mode="InProc" timeout="1440"/> <customErrors…
-
1
votes1
answer3034
viewsA: IIS - Access denied directory
Italo you have already given full permission to the IIS_IUSRS user in the Pacotesserialized folder. Also see if there is the MIME type. xml or extension used in IIS.…
-
4
votes1
answer533
viewsA: SQL Select highest value item
If you order DESC you will have the largest number of products per category: SELECT TOP 1 CategoryID, COUNT(ProductID) AS 'Produtos por categoria' FROM Products GROUP BY CategoryID ORDER BY…
-
0
votes2
answers1443
viewsA: GROUP BY with 2 tables
I changed my logic to select so: SELECT Andamento.NumeroProcesso FROM Andamento LEFT OUTER JOIN Processo ON Andamento.NumeroProcesso = Processo.NumeroProcesso WHERE (Processo.Irrecuperavel = 1) AND…
-
0
votes1
answer34
viewsA: Web components for searching database data
You can pass the parameter to your query that populates the Dropdrownlist: <asp:SqlDataSource id="Prod" runat="server" ConnectionString="<%$ ConnectionStrings:myBase %>"…
-
2
votes2
answers1443
viewsQ: GROUP BY with 2 tables
I need to make a select with JOIN in two tables but I am not able to group to not repeat the lines. Follows the expression SQL: SELECT Andamento.NumeroProcesso, Andamento.Chave, Andamento.Codigo,…
-
1
votes1
answer821
viewsA: Get row and column item from a dynamic html table
Solution: Icon code: html.AppendFormat( "<td style='vertical-align: middle;'>" + "<a href= \"#\"" + "class=\"btn btn-default\" " + "onclick='myFunction(\"{0}\")' data-toggle='modal' " +…
-
0
votes1
answer821
viewsQ: Get row and column item from a dynamic html table
Good morning guys, I’ve set up a dynamic html table with information from an SQL table. In the following structure: This table has a filter field of the agencies listed code: <script> function…
-
1
votes3
answers257
viewsA: Event onclik button in dynamic html Stringbuilder table
Thanks guys for your help! I solved otherwise without using javascript, in html itself so: html.AppendFormat( "<td>" + "<a href = \"Processo.aspx?NumeroProcesso={0}\"" + "class=\"btn…
-
0
votes3
answers257
viewsQ: Event onclik button in dynamic html Stringbuilder table
Good afternoon people of the forum, I’m trying to add a button in a dynamic html table to redirect to another page by passing parameter through the url. But I’m not getting it via javascript. I’m…
-
1
votes3
answers1195
viewsA: Convert nvarchar(50) field to SQLSRV table datetime
Thank you guys, I was able to convert the nvarchar field to datetime simply as follows: UPDATE tb_Processo SET DataParcelaAntiga = TRY_CAST(DataParcelaAntiga AS DATETIME)…
-
1
votes3
answers1195
viewsQ: Convert nvarchar(50) field to SQLSRV table datetime
I need to change a field in the SQL database table whose format is in nvarchar(50) and data were saved in date format 07/09/2017, containing values NULL also! I need to convert this field directly…
-
0
votes2
answers310
views