Posts by Marciano.Andrade • 1,205 points
39 posts
-
2
votes1
answer288
viewsQ: Doubt use of Sequence - Oracle
I have a table on oracle 11g which in turn has a CREATE TABLE "BANCO"."TEXTO" ("TEXTOID" NUMBER NOT NULL ENABLE, "NOME" VARCHAR2(4000 BYTE) NOT NULL ENABLE, "VALOR" VARCHAR2(4000 BYTE) NOT NULL…
oracleasked Marciano.Andrade 1,205 -
2
votes2
answers435
viewsQ: Convert String with AM/PM to Datetime
I have a variable that contains a date with AM/PM: string data = "01/08/2016 9:00 PM"; When I try to convert to DateTime using the method TryParse the result ignores the designator "AM/PM". string…
-
2
votes1
answer67
viewsA: How to open a meditation in c#
One way to visualize a dll method is by using a decompiler, such as the Reflector. To understand a little more about decompilers, I suggest you take a look at this question here: What is Reverse…
c#answered Marciano.Andrade 1,205 -
2
votes1
answer187
viewsA: Show div on onclick independent of clicked button
Add a class to the buttons and use this class in javascript, for example: <button type="submit" id="submitbtn" class="botaoMostraDiv"> and then change your javascript from…
-
1
votes2
answers127
viewsA: Loading Grid data with Checkboxcolumn
The estate Rows do Gridview is an array containing the rows of it, access to that array is by the row index, not by the product id as you are doing. To do what you want it will take a loop inside…
-
1
votes1
answer79
viewsA: Create Table in SQL Server 2008
One way to achieve this is by using a Computed Column with a function, and this function will perform a select on the table Produtos Example: CREATE FUNCTION dbo.getDescricaoProduto(@produtoID int)…
-
2
votes1
answer57
viewsA: Multithreading problems with C#
A way to access an object that belongs to another Thread is by means of a Delegate: private delegate void translateObjectDelegate(); private void translateObject(){ if (translate.InvokeRequired) {…
-
1
votes2
answers830
viewsA: Connection BD C# Sqlite
You will not be able to access the remote folder directly from C#. To do this, you need to modify the folder on your computer, and access it from the mapped address. Example: Make a folder mapping…
-
1
votes3
answers381
viewsA: Use query within the value of another query
You can use the quotes for such a need, thus creating a Subquery. One Subquery is basically one query within another. When working with subquerys, we should be aware of certain points, such as the…
sqlanswered Marciano.Andrade 1,205 -
4
votes4
answers4483
viewsQ: Extract decimal part of a decimal
I’m having trouble formulating a good means of extracting the decimal part of a variable decimal, so far the existing implementation in the system is that: public static bool…
c#asked Marciano.Andrade 1,205 -
0
votes3
answers278
viewsA: SQL query in wp_postmeta table
The problem with your query is that you are using the and between the two conditions. This way, the bank will understand that it should return the fields meta_key and meta_value of all lines…
sqlanswered Marciano.Andrade 1,205 -
1
votes2
answers4336
viewsA: How to run program in C# by cmd
If the method ReadCommand() and the method RunCommand send data to the Console using the method Console.Write and read Console data using the method Console.ReadXXX yes, it will work. To test, you…
c#answered Marciano.Andrade 1,205 -
0
votes2
answers139
viewsA: How to send object by radiobutton?
Instead of using this object creation in input value, why don’t you use a function that creates a new object? function makeObj() { var obj = { nome: # }; return obj; } <input type='radio'…
-
3
votes1
answer95
viewsA: Same different result code (Visual Studio 2012 X dotnetfiddle.net)
The difference exists because of the culture in which the program is running. Your VS show is cultured pt-BR, which has the decimal separator comma (','), while in dotnetfiddle the culture is…
-
2
votes1
answer369
viewsA: First letter of menu underlined for shortcut - WPF
To put a keyboard shortcut to a menu, the WPF uses the symbol '_', unlike Windows Forms using the symbol '&' before the letter corresponding to the shortcut. So your menu should look like this,…
-
6
votes4
answers2297
viewsA: Is it correct to use a table in the page layout?
The tag Table was created to display a table with data tabular. So using a table to control the layout of the elements on the page is bad practice. Because of that the concept of tableless was…
-
4
votes1
answer1926
viewsA: How to declare and initialize two-dimensional matrices?
To declare and initialize the array correctly you need to know how many rows and how many columns it will have, and then initialize it anyway: String[][] referencia = new…
-
4
votes3
answers377
viewsA: How do I work with responsive design?
To differentiate a 1024x600 resolution from a 1024x768 you can use a combination of Media Queries as the following example: @media (max-width: 1024px) and (max-height: 768px) { // } @media…
-
2
votes5
answers338
viewsA: Move background of text
You can use a file . gif like the background, removing all necessary implementation in CSS and Javascript. Example: body{ background-image: url('http://i.stack.imgur.com/kx8MT.gif');…
-
3
votes3
answers7123
viewsA: Disable windows form maximize and minimize
There are several ways to achieve this result: If you want to disable only minimize and maximize buttons, you can use the properties MaximizeBoxand MinimizeBox: If they are of value true: If they…
-
5
votes3
answers1608
viewsA: Is it possible to backup a remote bd sql server via c#?
If you want to back up a base on MS-Sql Server remotely so that the backup files are created on your computer, I am sorry to inform you that this is not possible. You can perform a remote backup by…
-
3
votes1
answer478
viewsA: E-mail to my account c#
Probably the door of SMTP that you are using is incorrect, I know it is possible to use the 25, the 465 and the 587, but I was only successful using the 587. System.Net.Mail.SmtpClient Smtp = new…
c#answered Marciano.Andrade 1,205 -
1
votes3
answers402
viewsA: Responsive Design - Text on img background
In fact, the paragraph keeps the font the same way the Nav keeps the font too, the size of your font is not changed based on the screen resolution. If you want the president text to be resized with…
-
4
votes2
answers377
viewsQ: Alternative to Exists()
I’m looking for an alternative to using the command Exists in procedures I need to perform a large query and check if it returns any data, if it does not return the search should return a select…
sql-serverasked Marciano.Andrade 1,205 -
3
votes1
answer1820
viewsA: Print EPL code with javascript
Javascript does not have direct access to the user’s printer, so it is necessary to use another medium for this printing. One way to do this using javascript is with the applet jzebra Code example:…
-
1
votes4
answers549
viewsA: Element does not take the parent background
The element <h2> is red background due to the rule *{margin:0; padding:0; font-family: 'arial'; background: red;} which is applied to all elements on behalf of the selector *, to change this…
cssanswered Marciano.Andrade 1,205 -
1
votes2
answers1729
viewsA: How to pass values of controls between different windows?
A way to access the data from form main in high school is setting the form main as secondary Parent. For this we can use the constructor of the form by passing as argument the form leading. It is…
-
1
votes4
answers1593
viewsA: Changing connectionStrings from the app.config physically in Runtime
The way I physically change Connectionstring on web.config is as follows: Configuration webConfigApp = WebConfigurationManager.OpenWebConfiguration("~");…
-
0
votes3
answers522
viewsA: Receive backgroud-image attribute from a div
To fetch the value of a css property of a given element using jQuery, we can use the function .css(). //Aqui retorna o valor do background-image $('#id').css('background-image'); //Enquanto aqui o…
-
2
votes1
answer849
viewsQ: How to select a port to connect to SQL-Server Remote
I have the following problem, my SQL server is with port 1433 open and communicating correctly, but my client has a firewall that blocks all incoming and outgoing ports of computers connected to the…
-
5
votes2
answers949
viewsA: How the "namespace" works in ASP.NET
According to the documentation: Namespaces organize objects defined in an Assembly. Modules (assemblies) may contain multiple namespaces, which in turn may contain other namespaces. Namespaces avoid…
-
1
votes3
answers5013
viewsA: Subtraction of multiple selects
It is simpler than it seems, it is only necessary to use the operator '-' between the two subquerys. Follow the operator documentation link: Operator "-" SELECT ( (SELECT sum (dr.valortitulo) from…
sqlanswered Marciano.Andrade 1,205 -
2
votes2
answers7608
viewsA: How to create a Rigger that is fired every time you have an insert event in the table?
@Edit CREATE TRIGGER Table_A_Update ON itensNota FOR INSERT AS DECLARE @IDPAI VARCHAR(200), @IDNOTA VARCHAR(200), @ID INT BEGIN DECLARE cur CURSOR FOR SELECT idPai, idNota, ID FROM inserted OPEN cur…
-
2
votes3
answers923
viewsA: Error ""AWT-Eventqueue-0" java.lang.Stringindexoutofboundsexception: String index out of range: 0" in Java when trying to do IF
The problem is that there is no char at position 0, as the string is empty. What you have to do is check before, to see if the String is empty or not. A possible example:…
javaanswered Marciano.Andrade 1,205 -
12
votes1
answer478
viewsA: Problem with Background Html/Css
Seeing your fiddle, the problem is in CSS itself. You have a rule *{ background-color: #FFF; margin: 0px; padding: 0px; } That’s the problem, because you are setting for all elements (operator *) a…
-
4
votes2
answers4329
viewsA: String to Double Asp.NET C#
You can use the overload of the method Convert.ToDouble who receives a IFormatProvider as a parameter. If Convert.ToDouble without this overload is used the culture in which the program is running.…
-
-1
votes2
answers829
viewsA: Httpclient releasing org.hibernate.Exception.Genericjdbcexception exception exception?
The problem is described in the exception, the maximum number of connections with the bank (20) was exceeded. You can configure the database and increase this number or use a kind of connection…
-
1
votes1
answer186
viewsA: Dropdownlist does not work within Detailsview
As I answered your other question: How to use the Dropdownlist Selectedvalue value? One way to do this is by getting the Dropdownlist from Detailsview and doing the update logic inside the…
-
1
votes3
answers9419
viewsA: How to use the Dropdownlist Selectedvalue value?
To update in the database each time you modify the selection, it is necessary to capture the Selectedindexchanged event and within it add a logic that connects in the database and update. Add the…