Posts by hard123 • 2,329 points
176 posts
-
0
votes0
answers27
viewsQ: How to scroll through one or more table html and your table html daughters?
How to go through all the tables and their daughter tables, because I need to make a sum of the columns "Value"? Tables are created dynamically according to the return of the Ajax function. I can…
-
0
votes0
answers22
viewsQ: Serialization error while loading google chart Charts
I have the method JsonResult called "Carregarchart" which returns a DataTable for a request Ajax where I’m trying to popular data on a google graphic Maps, and the problem is that the following…
-
0
votes1
answer41
viewsQ: Turn row into columns using pivot
I have this list that is the result of the query below: This is the query: SELECT PERIODO, ST_NOME_SUPERVISOR, Sum (NU_TOTAL_VENDA) AS NU_TOTAL_VENDA FROM ( SELECT UPAI.ST_NOME AS…
-
0
votes0
answers40
viewsQ: How to verify if a value exists in an Oracle Process input parameter and make a decision?
I have a trial that has a type VARCHAR2 of entrance parameter: PROCEDURE PRC_MINHA_PROCEDURE ( PI_ID IN TB_1.ID%TYPE PI_ID_ATRIBUIDO IN VARCHAR2 DEFAULT NULL, PO_TP_RESULT OUT t_cursor ) AS…
-
0
votes1
answer30
viewsQ: How to return a file to the client?
I need to return a file in my action so that the client can download it. In my current code, the file is being saved on server. [HttpGet] public JsonResult ExibirPrintRPA(int? id) { string _nameFile…
-
0
votes1
answer52
viewsQ: How to sort a list 1 to N with Expression lambda
I need to sort out a list and I don’t know where to start. I tried to apply the code below based on some posts, for example: https://stackoverflow.com/questions/298725/multiple-order-by-in-linq ,…
-
1
votes0
answers215
viewsQ: Error when deleting an Oracle table reference
I am trying to delete a record from my table TB_CONTATO who is the daughter of the table TB_CLIENTE: DELETE FROM TB_CONTATO WHERE ID_CLIENTE = 2999 But it occurs of violation of integrity:…
-
-1
votes1
answer46
viewsQ: How to delete the null string from the td tag?
How to remove "null" from tag ? I tried to use replace, but error occurs due to variable being null: Example: _st_versao_ofertada.replace("null",""); //Ná pode, ocorre erro. Como fazer ? <br>…
-
-1
votes1
answer376
viewsQ: View dialog screen to download with javascript
I have an MVC project where there’s a button that does the download of files but when clicking the button opens a new guide in the browser and the files are automatically downloaded, as in the…
-
0
votes1
answer2559
viewsQ: Set value for an oracle variable and use as parameter
What’s wrong when I try to set a value to an oracle11g variable and use it as parameter ? I found a post with the same doubt and adopted one of the solutions but the error continues: DECLARE ID…
-
1
votes1
answer47
viewsQ: Why can’t I map using Automapper?
I have a model called Client with many attributes and (for simplicity I put here only a few) I thought of creating Viewmodels to simplify the display of data in Views, the problem is that the…
-
6
votes4
answers1946
viewsQ: Incorrect Date/Time Formatting Nan/Nan/Nan Nan:Nan:Nan
The Field DateTime that returns from Database is formatted as dd/MM/yyyy hh:mm:ss, by now when you start looping ($each) the code below the format changes to: "/Date(1566322265000)/". I created this…
-
1
votes1
answer48
viewsQ: How to view a JSON file with dynamic key/value?
We have a JSON file that we will never know how many key/value will contain and need to display on the screen for the user, how to do this since I do not have the "key" example: In the 1st. call…
-
0
votes0
answers30
viewsQ: Type Datetime incorrect format /Date(1566916268000)/ how to solve?
The return of the Dt_start field returned from the Database is correct: 26/08/2019 11:08:10 But not in javascript is like this: /Date(1566916268000)/, see: $.each(response.listar, function (index,…
-
0
votes0
answers42
viewsQ: Error clicking Header to order Datatable.js
I’m using the api Datatable.js and I’m going through the following problem: When I click on any coluna da table html to make the ordenação the entire content of the tag tbody remain only one line…
-
0
votes1
answer31
viewsQ: Error with jquery array syntax
I didn’t put all the code to not pollute the text and the doubt is about the syntax below: I have 2 table html (tblPerguntas e tblRespostas) e preciso percorrer estas duas Tables e enviar para a…
-
1
votes1
answer103
viewsQ: Why does the model return null after using Automapper?
To model Endereco returns null after mapping (Automapper), why ? Example: using AutoMapper; using System; using System.Collections.Generic; using System.Linq; using System.Text; using…
-
2
votes0
answers23
viewsQ: Error displaying Time on Google Columnchart chart
The Example chart below displays the Hours correctly: HTML: <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <div id="chart_div"></div>…
-
0
votes1
answer484
viewsQ: How to resolve lambda expression conversion error of type Servicelifetime net core?
I am starting a very simple project with net core 2.2 and confronted myself with the following error: Cannot convert lambda expression to "Servicelifetime" type because it is not a delegated type…
-
1
votes2
answers137
viewsQ: How to treat Timestamp field return via AJAX?
How to convert this sequence of numbers: 1555506548000 into a valid date ? I need to make the following comparison: if (_valor[0] == item.DT_CRIADO_EM) { //Faz alguma coisa }; However the date is…
-
0
votes3
answers157
viewsA: Why doesn’t View see the javascript file?
I found the solution in this post: Where to put view-specific javascript files in an ASP.NET MVC application?, I had to add some tags to the web.config file.…
-
1
votes3
answers157
viewsQ: Why doesn’t View see the javascript file?
How to make the view run the javascript file: novo.js Directory structure: Views > Product > js > new.js Error: View Product.cshtml: @{ ViewBag.Title = "Index"; } <h2>Index</h2>…
-
1
votes1
answer418
viewsQ: Avoid simultaneous user access
I need to make the user not log in to the system (asp-net mvc) on different machines. The system is on the intranet and currently there is an Access table with date and time of access of the user…
-
2
votes0
answers78
viewsQ: List files from a folder via ftp with jquery ajax
I need to list files from a folder that sits in one ftp server, how do I access this folder ? The user must select a list item (<select><option></option></select>) called…
-
2
votes2
answers745
viewsQ: Pass more than one parameter in a request in Angular for Webapi
This is the web api: [Route("{pagina:int}/{tamanhoPagina:int}")] [HttpGet] public IHttpActionResult UsuarioPaginado(int pagina = 1, int tamanhoPagina=10) { var _aluno = iAluno.Listar() .Where(x…
-
7
votes2
answers173
viewsQ: Search range of numbers (string type) with Expression Lambda?
I have this data model and I don’t know how to do the instruction lambda: public class CidadeAbrangencia { [Key] public int CidadeAbrangencia_Id { get; set; } public string CEPInicial { get; set; }…
-
0
votes2
answers158
viewsQ: Incorrect formatting of string to decimal during Excel import
I am making an excel import for a dataGridView and the formatting of the field type Value does not bring the comma, period and decimal place, example: In the Excel it’s like this: 995.800,00…
-
1
votes0
answers225
viewsQ: Clear space between the Menu with div class navbar and a responsive Html table
I have a table html responsible for displaying system content to the user and the problem is that there is a space that persists between the Menu higher (which is a div class="navbar") and that…
-
4
votes1
answer46
viewsQ: Error mounting HTML table with jQuery
I need to create this screen: The problem is that the code I made generates 9 columns in a row instead of generating 3 columns per row: That is the code: @{ ViewBag.Title = "Home Page"; } <div…
-
0
votes1
answer90
viewsQ: How to mark a specific Checkboxlist item with jquery
I have seen several examples of how to mark and unmark all, but I have not seen how to mark a specific, see: <asp:CheckBoxList ID="ChkAcoesListarGrupo" runat="server" RepeatDirection="Horizontal"…
-
0
votes0
answers491
viewsQ: Error in the email field mask and validation
I am trying to implement a mask and validate the email field using the plugin inputmask unsuccessfully the mask does not appear and consequently does not validate, why ? That is the code:…
-
3
votes1
answer3890
viewsQ: How to make the HTML table inside another table occupy the entire screen?
I have an HTML table with 3 columns and 3 lines and for each cell of this table I have another HTML table with 3 columns and 2 lines and I’m trying to get her to uniformly occupy the entire screen.…
-
1
votes1
answer104
viewsQ: How to go through Checkbox in automatically generated Webforms with Jquery
How to scroll through several Checkboxes in the C# Button Click event where these Checkboxes were automatically generated with Jquery ? The automatically generated Checkbox HTML is this: <div…
-
1
votes1
answer40
viewsQ: Post with api aws
I’m trying to make a Post for a service of AWS. I have never worked with AWS and I am studying some links and uninterruptedly I am doing a connection test using this code: private static async void…
-
0
votes1
answer35
viewsQ: How to extract the SQL Server log file from the server?
I have an SQL Server and I need to send the Log file to one of our Clients, but this query has 24 Gigabyte, doubt: How to extract this logo file in csv format ?
sql-serverasked hard123 2,329 -
1
votes1
answer79
viewsQ: How to check and uncheck the Telerik component Checkbox?
I searched the website of Telerik and not found where it shows how to do to enable the Checkbox (mark and unmark) of this component ? 'Cause I’m gonna need to update the profile by sending it to the…
-
0
votes1
answer43
views -
-2
votes2
answers160
viewsA: How to get the difference in seconds with Sql Server
I did so: drop table #TB_OK DECLARE @TB_HORA as table ( ID int, ID_Servico int, DataExecucao datetime ) INSERT INTO @TB_HORA VALUES ( 1,49,'2018-10-19 18:18:30.313'), ( 2, 1,'2018-10-19…
-
0
votes2
answers160
viewsQ: How to get the difference in seconds with Sql Server
I know that to get the difference of seconds between Beginning and End is like this: Case 1: DECLARE @TB_DIFERENCA_INICIO_FIM as table ( ID int, DataInicio datetime, DataFim datetime ) INSERT INTO…
-
1
votes1
answer182
viewsQ: Select with PIVOT always returns null
I’m trying to do a query using the pivot based on this link insert link description here, but without success, as it always returns 2 Null lines: Query: DECLARE @registros as table ( ID int, Campo…
-
0
votes2
answers60
viewsQ: Error while reading a Json string
I’m trying to create a table for a football championship with the return of a json: To facilitate I will put the Json below refers only to a Team: { "id": "1", "nome": "Palmeiras", "Atleta": [ {…
-
0
votes0
answers34
viewsQ: Point in Model Class attribute is possible?
This is an xml request schema for a Webmethod: <RetrieveClienteRequest> <model query=""> <keys query="" > <cliente.cnpj type="String"></cliente.cnpj> </keys>…
-
0
votes1
answer38
viewsA: Structure of a Webservice X Model Class
I created a class called model, Keys and instance with the input attributes: Class model: public class model { public keys Keys { get; set; } public instance instance { get; set;} } Class Keys:…
-
0
votes1
answer21
viewsQ: How to expose only a few table columns in a Webservice via SOAP?
How to expose just a few columns of in a Webservice ? Example: I need to expose just the Name and Surname table: public class Cliente { public string Nome {get; set;} public string SobreNome {get;…
-
2
votes1
answer38
viewsQ: Structure of a Webservice X Model Class
I need to make a web service (asmx) where the Request Entry is in this structure: Input XML (Request) <RetrieveDeviceParentRequest> <model query=""> <keys query="">…
-
-2
votes1
answer50
viewsQ: How do I order a Complex List?
How do I sort a complex list ? I have this list below and I need to sort by Nometype and Nomesubtype: public class Tipo() { public int IdTipo {get; set;} public string NomeTipo {get; set;} public…
-
1
votes1
answer40
viewsQ: Database First approach with Lazy Loading disabled?
I’m starting a project and the Sql Server already exists so I will take the approach Database First as an example of that article Entity Framework Tutorial. I’ll create the file .emdx and import the…
-
1
votes1
answer123
viewsQ: How to ensure that the generated JSON does not return error to the Customer?
I created a Web API that returns a JSON and who is having a problem similar to the question JSONP: status code 200 OK and still returns $.Ajax(... error:Function()...). Client consumes the API with…
-
0
votes2
answers193
viewsA: Timeout Sql Server in a request via Web Api
As noted in the comments by Thiago Loureiro I switched the SqlDataReader for DataTable and it worked.
-
1
votes2
answers193
viewsQ: Timeout Sql Server in a request via Web Api
Running the query gives a Timeout Sql Server error: Connection Method: public SqlDataReader GetDataReader(string comando) { SqlConnection conn = criaConexao(); // Cria Comando SqlCommand cmd = new…