Thursday, 1 March 2018

How to call function after complete page load in javascript

Description : in this post how to call function after complete page load in aspx, html, cshtml page just add below code in script

Write below code and add your function in setInterval

<script>
        document.addEventListener("DOMContentLoaded", function () {
            setInterval(calculateTotalFees(), 0);
        }, false);
</script>

How to upercase / lowercase text in SQL query

Description : in this post how to get result of state name in upper case  or in lower case

Query Syntax for upper case text return in result

- SELECT UPPER(sta_StateName) AS State FROM StateMaster

Result :

DISTRICT OF COLUMBIA
TEXAS
NEW MEXICO

Query Syntax for lower case text return in result

- SELECT LOWER(sta_StateName) AS State FROM StateMaster

Result :

district of columbia
texas
new mexico

Screen Shot :