Posts by FabioIn • 714 points
36 posts
-
0
votes0
answers23
viewsQ: The button click event fires Modalpopupextender but does not turn off
MODAL appears, but NO longer wants to leave! How do I fix this? I have a code in ASP.Net, . Net Framework 4 with Visual Studio 2010. <asp:button ID="hButton1" runat="server"…
-
0
votes1
answer32
viewsA: Recover Milliseconds of a date recorded in an MSSQL Server 2019 BD with VB.Net + ADO.Net
The problem is that I mounted in tblHistorico a primary key composed of two fields: "System Code" + "Date Change". (maybe help someone out) The best I could do was this: *** Function call to test…
-
1
votes1
answer32
viewsQ: Recover Milliseconds of a date recorded in an MSSQL Server 2019 BD with VB.Net + ADO.Net
I would like to know how to recover a date as given from the recorded Milliseconds in a MS SQL Server 2019 database using VB.Net + ADO.Net. Whenever I try to rescue the date, comes in the fomrmato…
-
0
votes0
answers45
viewsQ: Enable Javascript in the ABA Console in Internet Explorer (F12) Developer Tools
Please, I’m trying to make a combobox visible within a page. I am using Internet Explorer with "F12" (Developer Tools) TAB "Console" triggering command on the command line below. For this Combobox…
-
1
votes1
answer214
viewsA: Field validation problem in ASP.NET Core
Try it like this: [Required(ErrorMessage = "O campo Valor Unitário é obrigatório.")] [Column("ValorUnitario")] [DataType(DataType.Currency)] [Display(Name = "Valor unitário *")] public float?…
-
0
votes1
answer79
viewsA: Statuscode = 407, Reasonphrase: 'authenticationrequired under development only
Anderson Oliveira, look at this, maybe it’ll help you: This method can avoid the need for HARD CODE (failed code) or configure proxy credentials, which may be desirable. Put this in your app…
-
0
votes1
answer40
viewsA: Database occupied
To find out if the database is currently in use, the most accurate way would be to find out if any session has any specific database lock, by consulting sys.dm_tran_locks. Here is an auxiliary…
-
0
votes1
answer143
viewsA: Picturebox with round corners without serration?
Lucas Pedro, try using the "Antialias". It would be something like this: // Set the SmoothingMode property to smooth the line. e.Graphics.SmoothingMode =…
-
2
votes1
answer284
viewsA: Load database information into a textbox using the layers template with C#
Chris_rodrigues, your query "Consultacep" is giving error, because it is VOID and has a Return... Switch from VOID to Datatable, like this: public DataTable ConsultaCep(string cep) { DataTable…
-
2
votes1
answer108
viewsA: Problems with Activex control (option button), counting values according to button marking
Elienay Junior, I set this little routine down real quick... please see if it helps you: Private Sub OptionButton1_Click() Range("A30").Value = "" Range("A31").Value = "" preencherCelulas (29) End…
-
1
votes1
answer206
viewsQ: Changing Database of a system that is using EF code first
Please, I need to change the BD of an application using Mysql to use MS SQL Server. I have already migrated tables, data and relationships. The problem is that the system was made, I believe, in the…
-
0
votes2
answers1499
viewsA: Bingo booklet in c
Username 7873, I’ve set up a function that might help you. The idea is to NOT repeat the numbers ever. I assemble two lists: A list of all the numbers that will be drawn (this list always decreases…
-
1
votes2
answers121
viewsA: How to verify that the executable has been changed? C#
Rodrigo Pretti Fantin, the Process class has a method called Getcurrentprocess that returns a reference to the process that is currently running (its application). With this reference in hand, just…
-
0
votes3
answers261
viewsA: CRUD Object Oriented Programming
Gabriel, I believe this is what you seek: There are several ways to map the inheritance relationship in the bank. The best strategy will depend on the situation (types of queries that will be…
-
1
votes3
answers261
viewsA: CRUD Object Oriented Programming
What I’m understanding you’re saying is about "Inheritance" or is it about "Composition" in OO. It’s easier for you to read the article below, but basically it’s as follows: You have a "main" object…
-
0
votes1
answer96
viewsA: Which component should I use?
Adolfo Moro, I’m not sure if this is it, but once I made a "list of controls". I have an example, but it’s on VB6 and only has a Textbox in which I added several new properties to it. ACTIVEX…
-
0
votes1
answer30
viewsA: Replace Database in Visual Basic 2010
Good morning Tdking, it depends a lot on the amount and complexity of changes you will have to make. It is not possible to know without seeing the whole project. You can do a new project and copy…
-
0
votes3
answers517
viewsA: Take information from a Website and Label it?
Sergio Wilker, if you’re talking about "Webcrawler" or "Webscraping" I did so to return the Commercial Dollar from a site called "The Money Converter": using HtmlAgilityPack; /// <summary> ///…
-
1
votes1
answer242
viewsA: C# calculator and keyboard interaction
Sidsan, If you are using Windows Forms you need to put a Textbox on the screen as well. Then you associate the textbox value into your "first" variable. Example: double primeiro; primeiro =…
-
0
votes2
answers197
viewsA: How to open external process on second Monitor
System, you need to know if the machine has two monitors... Use "System.Windows.Forms": if (Screen.AllScreens.Length > 1) { //Estendido } else { //Duplicado, ou apenas 1 tela } See in: How to…
-
3
votes1
answer114
viewsA: Detect date change in Windows [C#]
Matheus, follow an example... but it’s in VB.Net... may be? Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Define classe SystemEvents para…
-
1
votes1
answer601
viewsA: How to print Qrcode on Epson TM T20 VB.NET printer
Matheus Ribeiro, please see this example (if you do not have, you need to register in Vbmania): S@T - PRINT QRCODE/BARCODE Code example for printing QRCODE with Esc/pos on non-fiscal Epson printer…
-
2
votes1
answer154
viewsA: Problem with exporting to Excel using C#
Itasouza, please see the example: using System.Collections.Generic; using Excel = Microsoft.Office.Interop.Excel; namespace ConsoleApplication2 { class Program { static void Main(string[] args) {…
-
3
votes1
answer65
viewsA: String Connection to access sql remotely
Diogo, I think that’s what you’re looking for: Data Source=10.0.0.1;User ID=seu_usuario;Initial Catalog=seu_banco;pwd=sua_senha Data Source = IP of your server that is installed SQL Server User ID =…
-
0
votes1
answer64
viewsA: Leftover space in Datagridview c#
No... maybe that’s it: int s1 = 0; int s2 = 0; s1 = (Int32)dataGridView1.RowCount; for (int i = 0; i < s1; i++) { s2 += dataGridView1.Rows[i].Height; } dataGridView1.Height = s1 * s2; See also:…
-
1
votes1
answer55
viewsA: add blank line to a list
Rafael Veloso, you can make a "mod" that in C# is the "%" symbol in this way: eCT01 lx = new eCT01(); if(num % 3 == 0) lst.Add(lx); ... but you will need an "num" counter to know which line you are…
-
3
votes1
answer93
viewsA: Alternative to IF and Else in a specific problem
Why don’t you use a set of boolean "flags" for each of your thirty-two variables and then submit to a "SWITCH", it would be something +/- like this (requires adjustments): class Program { static…
-
0
votes1
answer98
viewsQ: Web Scraping or Web Crawler isolate Node
Please, I’m trying to retrieve the following information: "value bra": (<span class="value bra">3,666</span>) <div class="ticker-financial-market" initiated="true"> <div…
-
2
votes3
answers196
viewsA: Growth ranges of an array’s values
Code example: class Program { static void Main(string[] args) { int[] intNum = new int[11]; intNum[0] = 0; intNum[1] = 1; intNum[2] = 2; intNum[3] = 3; intNum[4] = 4; intNum[5] = 3; intNum[6] = 2;…
-
2
votes1
answer78
viewsA: How to copy data from one gridview to the other?
Please Rafael Veloso, you can analyze the code below? private void btnCopiar_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); DataTable dt = new DataTable(); dt.TableName =…
-
0
votes1
answer1247
viewsA: Share workbook with VBA
fernandosavio, It may be that the bid is not code, but features Excel document... ... please see this: Share a workbook 1 - Create a new workbook or open a workbook existing that you want to make…
-
2
votes1
answer4196
viewsA: Copy and Paste Special with VBA
Miguel, Just one example: Private Sub Worksheet_Change(ByVal Target As Range) Dim KeyCells As Range ' The variable KeyCells contains the cells that will ' cause an alert when they are changed. Set…
-
2
votes1
answer679
viewsA: Rows in Columns without Column Preset - SQL Server
Leooso, you need to do a PIVOT on top of an INNER JOIN, it would be something like this... example SELECT equ.Id, equ.Equipamento, def.* FROM equipamento equ INNER JOIN defeito def ON equ.Id =…
sql-serveranswered FabioIn 714 -
0
votes2
answers55
views -
0
votes2
answers55
views -
8
votes3
answers586
viewsA: What does the 3-bar C++ comment mean?
If the 3-bar comment is equal to the C#, I believe it is to document in a way that generates XML documents. Behold at this link how to insert XML comments for documentation generation.…