VB.NET
CODES:
DIM VINT_I AS INTEGER
VINT_I = CType (me.edit1.text, integer)
Me.edit2.text = VINT_I.TOSTRING
RESULT:
Me.edit1.textme.edit2.text 0.50 0.61 0.5011
Conclusion: Use CType to convert the decimal of less than or equal to 0.5, and convert to an integer result is 0.
2. VB.NET
IF Elseif elseif else endif problem
If not string.equals (.imb_con.text, string.empty) THEN 'IF NOT EMPTY
.SPR_INFO_LST_SHEET1.SETTEXT (VINT_I, 2, .IMB_CON.TEXT)
'Elseif string.equals (.imb_con.text, "TXRF Engineering Value Mus)"
'.SPR_INFO_LST_SHEET1.SETTEXT (VINT_I, 2, "TXRF Engineering 検")
'Elseif string.equals (.IMB_CON.TEXT, "Minimum Number of Empty ス ス ッ ト") THEN
'.SPR_INFO_LST_SHEET1.SETTEXT (VINT_I, 2, "Minimum Number of Empty ス ス ッ ト")
END IF
Description: The code that is commented will never be executed. Elseif is inspected in conditions other than the IF conditions above.
3.vb.net
When the function is called, there is a comma after the parameter list, there is no error. It may be in the case of an optional parameter.
4. Excel
Adjacent two units inputs 1, 2, put the mouse to the lower right corner, then drag it.
5. About .NET memory recycling
A Timer is defined in the form, including the instance of this Form in other classes, and use the AddHandler method to add the executed code. Another code calls this class. When Form = Nothing, Timer's code is still executed, and then "unusually" instances that do not set object references ".
5. Oracle SQL (Group by)
All columns in SELECT must be listed in Group By, except for count (). He will group in the order of the listed columns.
SELECT
Max (a.kotei_cd), - after groupage, the max value in it's group.
A.chokkei,
A.Line,
Count (*) AS XXX
From TMMC003 A
GROUP BY
A.chokkei,
a.Line
--Having count (*) / 5 = 5 or count (*) / 5 = 2 - It's right.
Order by a.chokkei DESC,
A.Line DESC
--A.xxx desc - it's wrong.
