Posts by Igor Carreiro • 1,917 points
140 posts
-
1
votes0
answers104
viewsQ: Html scripting with iframe
I have an application that serves with a HELP for the system, that is, the user clicks on the question mark and instantaneously opens a new tab with this HELP directly on the equivalent page, but as…
-
1
votes1
answer41
viewsQ: Problems with the responsiveness of a retractable menu
How can I format correctly so that the menu that is horizontal on your full screen, stand upright and show the sub-menus correctly? Follows code. <!DOCTYPE html> <html> <link…
-
1
votes1
answer540
viewsQ: How to leave the header from a fixed menu
I have the following menu: How do I stop when I click on some link it open the content under the menu, always leaving fixed ? <!DOCTYPE html> <html> <link rel="stylesheet"…
-
0
votes2
answers31
viewsQ: How to create a help Function
How can I implement a feature in jQuery / Javascript that a question mark type appears as soon as the user has 2 clicks on one TextBox and when he clicks on that question mark, Help how he can…
-
4
votes2
answers677
viewsQ: Is it mandatory to open and close connection when entering data?
In a *loop* que fazInsert` in an Excel spreadsheet it is mandatory to open and close the connection ? I analyzed the following, depending on the amount of registration it may take up to 1:30 to do…
-
1
votes1
answer687
viewsQ: Open and close connection each time you run the looping
I have an application that runs a procedure, saved in a DataTable and then do a looping to add the data in an excel spreadsheet. My question is, if I open and close the connection to each insert…
-
0
votes1
answer467
viewsQ: How to add social media buttons
How can I implement social networking buttons in my application(Facebook, Linkdin, Youtube) HTML/CSS/JavaScript ? Most of the examples I found are in PHP…
-
0
votes0
answers38
viewsQ: Insert is not working / Excel
I created a process to make a Insert in a spreadsheet on EXCEL but the data is not being entered. No error is returned. Code: private void AtualizarPerformanceEntrega() { try { DataTable dt =…
-
0
votes1
answer497
viewsQ: Data type Mismatch in criteria Expression + Excel data handling
Check to see if the logic is consistent, please. The procedure of this code is: Consult a procedure and store her data in a DataTable: private DataTable ExportPerformanceEntrega() { try {…
-
3
votes1
answer433
viewsQ: Data handling in excel
I need to get the generated data from a proc save in any variable that is and make a UPDATE in a worksheet already existing in a fixed path on the system. It is possible to do this process via code…
-
4
votes1
answer127
viewsQ: Problem for deletion of data from a spreadsheet
I have the following piece of code that connects to excel, where it will delete the data from a tab of a spreadsheet. private void AtualizarPerformanceEntrega() { try { string sFileXLSX =…
-
2
votes1
answer169
viewsQ: Problems with the excel connection string
I have the following code snippet that connects to Excel, but returns the error: string sFileXLSX = ConfigurationManager.AppSettings["ExportPerformanceEntrega"]; string strConnXLSX =…
-
3
votes1
answer219
viewsQ: How to evaluate which command to use between truncate/delete
I was reading about these commands Truncate table and Delete from, where I saw this explanation Truncate table - This command removes the watermark from the table by cleaning the same for a next…
-
0
votes2
answers67
viewsA: Select line in datagridwier and write to the database
The name of your column N_CHEKLIST is different where you are setting the parameter name @CHEKLIST. In case it would have to be the same for both. Answering your question, you would need to treat…
c#answered Igor Carreiro 1,917 -
5
votes4
answers13368
viewsQ: What are files with extension . cpp and . h?
What are these files with extensions .cpp and .h? How they interact with each other ?
-
-1
votes2
answers76
viewsQ: How can I create a list
I need to create a list, where it will list all existing items within an order. In the method below I can bring an item, but I can’t bring it if I have more than one. My doubt would be, I have to…
-
1
votes1
answer121
viewsQ: To create a list where you list all existing items within an order
I have the following screen that generates when making a request. On the field Order items, I need you to separate by items and not lump into one. Example as it is currently coming out It’s bringing…
-
7
votes1
answer3980
viewsQ: In which cases return the System Exception error.Outofmemoryexception
Which are the most frequent cases that can return this Exception?
-
2
votes1
answer674
viewsQ: Color change in graph with Chartjs not working
Could you help me in the case below? I’m trying to change the color of the chart to red, but the change isn’t working. Code: function Devolucao() { if (CicloAtual != "") { var codCli =…
-
1
votes1
answer169
viewsQ: How to leave the position of a fixed div according to the Raddiobutton change
I have the following screen that once changes the option of RaddioButton to div goes down or up. I wonder how to leave fixed in a position. Selected the Cycle option: Selecting the Year option:…
-
1
votes1
answer82
viewsQ: Field validation via jQuery correctly
I have the following validation for the TextBox justification. But even returning the message and clicking the OK button the system validates the deletion. The right, should return the message and…
-
0
votes1
answer33
viewsQ: How to unlock accordions even when some exceptietion
I have a screen that releases the accordions once the client’s code is validated with the personal information, etc. But if any exception he locks up accordions, how could you do to leave released…
-
0
votes2
answers234
viewsQ: How to make a query using SUM correctly SQL
I have the following query: SELECT YEAR(NFDtEmis) AS 'Ano', MONTH(NFDtEmis) AS 'Mes', ItProduto AS 'Produto', SUM(ItQtde) AS 'Quantidade total' FROM NotasItens INNER JOIN NotasFiscais ON NFEmpresa =…
sqlasked Igor Carreiro 1,917 -
0
votes1
answer1933
viewsQ: How to handle the Object reference error not set for an object instance
Create 2 new columns in my table dbo.FormaPgto - FPNFCeCpnjCred and FPBandeira both Allow Null When I consult a payment method, give the following error in the fields txtFPCnpj.Text =…
c#asked Igor Carreiro 1,917 -
0
votes0
answers530
viewsQ: Unable to find table 0 ASP.NET
I’m developing a screen that exports processed data from a Procedure for PDF/Xls. Debugging it returns the following error: Unable to find table 0 From what I understand he can’t read the…
-
1
votes0
answers62
viewsQ: Error while deleting line in Gridview ASP.NET C#
I have the following GridView: If I delete a line from Grid and try to save, it returns the following error Input string was not in a correct format. This error occurs as soon as it enters the…
-
0
votes1
answer62
viewsQ: How to correctly apply String.Format
I have the following event: protected void Page_Load(object sender, EventArgs e) { this.tituloTela.InnerText =…
c#asked Igor Carreiro 1,917 -
0
votes1
answer251
viewsQ: RPT file conversion to PDF c#
Good morning I have the following file on .rtp and, I need to convert/transform the data in that report to pdf. Saldoestoqueempresa.rpt I need it done through a click event.…
-
0
votes1
answer21
viewsQ: Questions about installing and using PHP
Good night How can I make the language work PHP, and which version to choose? S.O Windowns 10, for local use.
phpasked Igor Carreiro 1,917 -
0
votes1
answer51
viewsQ: Sql server 2008 connection
Good night I installed Microsoft Sql Server Management Studio 2008 on my machine to do local tests, but I cannot access it. Even if it’s free, how do I instantiate access, I have to reinstall the…
sql-serverasked Igor Carreiro 1,917 -
0
votes1
answer93
viewsQ: ASP.NET C# Dropdownlist doubt
I have a module that generates reports on excel, being one of these reports, the module called Occurrences. Where through DropDownList it informs me all the records of the table OcorrTipoEntr, that…
-
0
votes2
answers301
viewsQ: Direct subtraction in a view query?
I have the view dbo.ViewExportItensNotasFiscais, have the field NFValIcmsSubs, where it is necessary to subtract the field value NFValFCP and keep the column name as NFValIcmsSubs How could I do a…
sqlasked Igor Carreiro 1,917 -
2
votes2
answers2067
viewsQ: Order change of Sql columns?
Good morning Could you instruct me to change the order of the columns in a table? Example: I have the Table IcmsMvaUF in the following order: I’d like to pass the column MvaEmpresa to come first, to…
-
8
votes3
answers13782
viewsQ: Changing the data type of an sql column
Good morning. I have the spine CliTelCel char(10) on the table of Clientes, need to change char(10) for char(11). However this column already exists data, what would be the best way to proceed in…
-
0
votes1
answer43
viewsQ: Statement of 2 PK Sql
Good afternoon. I have the table Icms that has as PK the columnIcmClaFiscal, need to pass the column IcmEmpresa also as PK, but SQL gives me an alert. As I have been able to do this procedure in…
-
5
votes2
answers14121
viewsQ: SQL query for nonnull records only
I have a table NotasFiscais and I’m searching all the records it contains in the column NChave. But some result contains this information and others do not, in the case are as NULL. How could I…
sqlasked Igor Carreiro 1,917 -
2
votes0
answers442
viewsQ: NULL field in date, passing as parameter to the database
I am willing to treat a field in my program to accept data NULL if this field is not completed, it would be CliDtNasc. I did the treatment in class with the if ternary and in the class properties I…
-
0
votes1
answer25
viewsQ: Assignment of Function Jquery to Imagebutton
Good morning! How can I assign a Jquery Function to a buttom image ? I have this line of code that is to export a report in excel and I want to call a Function Jquery to load a processing screen…
-
1
votes0
answers29
viewsQ: Function Check initial and final product
Good afternoon, I’m developing an export screen to generate a product report per cycle and low area. However I need to filter between initial product and final product, in case I have a Function to…
-
1
votes0
answers29
viewsQ: Add 2 or more email in txt using as separator to ','
Good afternoon, How can I add 2 or more emails in the same field using a ',' tab by the jQuery Blur event? The code is already mounting, but I need to modify so that it accepts the new record…
jqueryasked Igor Carreiro 1,917