Software Development

No Image

Excel

August 18, 2017 hung-nb 0

[Idea]How to compare values of 2 columns? [Solutions]Use formula to return match/ un-match results in a separate column [Techniques]Comparison [js]=IF(A2=B2), "Match", "Unmatch")[/js] [Techniques]Case sensitive comparison […]

No Image

Ebook – JavaScript

August 9, 2017 hung-nb 0

The Modern Javascript Types Use “null” to write an “empty” or an “unknown” value into the variable “undefined” is only used for checks, to see […]

No Image

Form

August 8, 2017 hung-nb 0

How to detect if fields in form are changed or not? Method 1 (JS) Use hidden text box to store the initial value, then compare […]

No Image

Questions

August 7, 2017 hung-nb 0

ASP.NET What does ASP stand for? How to create a data binding between server controls and data source? What is the difference between Page State […]

No Image

Coding Basic

August 7, 2017 hung-nb 0

Coding templates Template 1 Get/ Validate/ Do/ Return Example [js] function test { var elms = document.getElementsByTagName(‘table’); for (var i = 0; i < elms.length; i++){ […]

No Image

Page Loading

August 4, 2017 hung-nb 0

How to create a loading bar? Create a hidden (display:”none”) block This block has a loading bar (gif image) This block freeze the whole screen […]

No Image

Menus

August 4, 2017 hung-nb 0

Fixed menu in every page Show a menu at mouse cursor when left/ right click

No Image

Cron jobs

August 2, 2017 hung-nb 0

How to find jobs calling a certain stored procedure? SQL Server [sql] DECLARE @Search varchar(255) SET @Search=’keyword’ SELECT j.name as job_name, s.step_id, s.step_name FROM msdb.dbo.sysjobsteps […]