place a div just below a textbox

Using Database:

var HG_ServiceUrl = HG_fnCallWebService, HG_LoadingImg = HG_LoadingText, HG_bg = '#D9E3D2', HG_callBack = HG_helpGridCallback;
$(document).ready(function () {
    var inputs = document.querySelectorAll('.helpgrid');
    for (var i = 0; field = inputs[i]; i++) {
        HG_createHelpGridEvent(field);
    }
});
function HG_loadHelpGrid(param) {
    $('#' + param.tblId + ' thead th').each(function () {
        $(this).css("padding-left", "0px");
        $(this).css("padding-right", "5px");
        var title = $(this).text();
        var append = '<label style="float:left">' + title + '</label>';
        if (param.cussrch != "no") {
            append = append + '<br /><input style="float:left;width:120px;" type="text" />';
        }
        $(this).html(append);
    });
    $('#' + param.tblId + ' tbody tr td').each(function () {
        $(this).css('padding', '5px');
        $(this).css('width', $(this).css('width'));
        $(this).css('overflow', 'hidden');
        $(this).css('max-width', '100px');
        $(this).css('white-space', 'nowrap');
        $(this).css('text-overflow', 'ellipsis');
        $(this).mouseout(function () {
            $(this).attr('title', "");
        });
        $(this).mouseenter(function () {
            $(this).attr('title', $(this).text());
        });
    });
    if (param.click != 'no') {
        $('#' + param.tblId + ' tbody tr').css('cursor', 'pointer');
        $('#' + param.tblId + ' tbody').on('click', 'tr', function (event) {
            HG_sendToHelpGridCallback(this);
        });
    }else {
        $('#' + param.tblId + ' tbody').on('dblclick', 'tr', function (event) {
            HG_sendToHelpGridCallback(this);
        });
    }
    var table = $('#' + param.tblId).DataTable({
        "scrollY": "200px",
        "scrollCollapse": true,
        "paging": false,
        "ordering": false,
        "info": false,
        "columnDefs": param.colDef,
        "createdRow": function (row, data, rowIndex) {
            $(row).attr('tblid', param.tblId);
            $(row).attr('outputid', param.outputId);
            $(row).attr('selcolumn', param.selcolumn);
            $(row).attr('tblCols', param.tblCols);
            $(row).attr('assigntotxtbox', param.assignToTxtBox);
        }
    });
    table.columns().every(function () {
        var col = this;
        $('input', this.header()).on('keyup change', function () {
            if (col.search() !== this.value) {
                col.search(this.value).draw();
            }
        });
    });
    try {
        if (param.defsrch == "no") {
            $("#" + param.tblId + "_filter").css("display", "none");
            if (param.cussrch != "no") {
                $($('thead')[0]).find('tr th:first input[type="text"]').focus();
            }
        } else {
            $("#" + param.tblId + "_filter input[type='search']").focus();
        }
    } catch (ex) { };
}

function HG_createHelpGridEvent(field) {
    $(field).keyup(function (event) {
        if (event.keyCode == 8 && $(this).val() == '') {
            if (this.suggestion) {
                this.suggestion.style.display = 'none';
            }
        } else {
            if ($(this).val() != '') {
                this.suggestion.style.display = 'block';
            }
        }
    });

    $(field).mouseup(function (event) {
        HG_createTxtboxDiv(this);
    });

    $(field).focus(function (event) {
        HG_createTxtboxDiv(this);
    });
}

function HG_createTxtboxDiv(sender) {
    var inp = document.querySelectorAll('.helpgrid');
    for (var j = 0; field = inp[j]; j++) {
        if (inp[j].suggestion != undefined) {
            inp[j].suggestion.style.display = 'none';
        }
    }
    if (!sender.suggestion) {
        var rect = sender.getBoundingClientRect();
        var left = rect.left;
        var top = rect.bottom;
        sender.suggestion = document.createElement('DIV');
        sender.suggestion.innerHTML = HG_LoadingImg();
        sender.suggestion.setAttribute('style', 'background: ' + HG_bg + ' ; padding: 6px; position: absolute; top: ' + top + 'px; left: ' + left + 'px;');
        sender.parentNode.appendChild(sender.suggestion);
        HG_ServiceUrl(sender, HG_webServiceCallback);
    } else {
        sender.suggestion.style.display = 'block';
    }
}

function HG_webServiceCallback(sender, data) {
    var tblCol = '', colDef = [], table = '<table id="' + sender.getAttribute("tblid") + '" class="cell-border" width="50%" cellspacing="0" >', thead = '<thead><tr>', tbody = '<tbody>';
    for (var i = 0; i < data.length; i++) {
        var cnt = 0;
        tbody = tbody + '<tr>';
        $.each(data[i], function (index, value) {
            if (i == 0) {
                tblCol = tblCol + index + ",";
                thead = thead + '<th>' + index + '</th>';
                if (index.toLowerCase().indexOf("hdn") != -1) {
                    colDef.push({ "targets": [cnt], "visible": false, "searchable": false });
                }
                cnt = cnt + 1;
            }
            tbody = tbody + '<td>' + value + '</td>';
        });
        tbody = tbody + '</tr>';
    }
    thead = thead + "</thead>";
    tbody = tbody + '</tbody>';
    table = table + thead + tbody + '</table>';
    tblCol = tblCol.replace(/^,|,$/g, '');
    var opcol = (sender.getAttribute("appcolumn") != undefined || sender.getAttribute("appcolumn") != null || sender.getAttribute("appcolumn") != "") ? sender.getAttribute("appcolumn") : sender.getAttribute("id");
    var sglclk = sender.getAttribute("sglclk") == 'no' ? 'no' : 'yes';
    var opapp = sender.getAttribute("opapp") == 'no' ? 'no' : 'yes';
    var defsrch = sender.getAttribute("defsrch") == 'no' ? 'no' : 'yes';
    var cussrch = sender.getAttribute("cussrch") == 'no' ? 'no' : 'yes';
    sender.suggestion.innerHTML = table;
    var param = { tblId: sender.getAttribute("tblid"), outputId: opcol, selcolumn: sender.getAttribute("selcolumn"), assignToTxtBox: opapp, click: sglclk, defsrch: defsrch, cussrch: cussrch, colDef: colDef, tblCols: tblCol };
    HG_loadHelpGrid(param);
}

function HG_sendToHelpGridCallback(sender) {
    document.getElementById($(sender).attr("outputid").split(',')[0]).suggestion.style.display = 'none';
    var table = $('#' + $(sender).attr("tblid")).DataTable();
    var rowresult = {};
    var col = $(sender).attr("tblCols").split(',');
    for (var i = 0; i < col.length; i++) {
        rowresult[col[i].toLowerCase()] = table.row(sender).data()[i];
    }
    if ($(sender).attr("assigntotxtbox") == 'yes') {
        var appendoutputid = $(sender).attr("outputid").split(',');
        var selectedColumn = $(sender).attr("selcolumn").split(',');
        for (var i = 0; i < appendoutputid.length; i++) {
            $('#' + appendoutputid[i]).attr("hdnfk", rowresult["hdnfk"]);
            $('#' + appendoutputid[i]).val(rowresult[selectedColumn[i].toLowerCase()]);
        }
    } else {
        HG_helpGridCallback($(sender).attr("outputid").split(',')[0], $(sender).attr("tblid"), rowresult);
    }
    return false;
}


Textbox Attribute:
*class="helpgrid"  ---->  Draw HelpGrid
*tblid="example1"   ---->  Draw HelpGrid using with table id
*selcolumn="office,age"  ----> HelpGrid Columns values
appcolumn="test,test1"   ----> selected values append more then two textbox.(Default it takes Textbox Id)
opapp="yes"  ---->   HelpGrid click append to corresponding textbox (Default "yes")
"hdnfk" ----> set;get; row reference.
callback -----> function HG_helpGridCallback(outId, tblId, rowdata)
defsrch & cussrch   -----> default "yes"
HG_webServiceCallback(sender, data)  ---> result callback
HG_fnCallWebService(sender, callback)  ---> web service
HG_LoadingText()  ---> loading waiting gif.

Sample : <input type="text" id="test1" class="helpgrid" tblid="example2" selcolumn="loc cd" appcolumn="test1" cussrch="no" />

SQL Server : OPENXML vs SELECT..FROM when dealing with XML

SET NOCOUNT ON;
DECLARE @BankXml VARCHAR(MAX) = '<ROOT><ITEM BAF="HI" /></ROOT>'
DECLARE @ErrMsg VARCHAR(MAX) ='',@XmlId INT,@TranCount INT
CREATE TABLE #tmptbl(BAF VARCHAR(10))
IF (@BankXml IS NOT NULL)      
    BEGIN      
        EXEC SP_XML_PREPAREDOCUMENT @XmlId OUTPUT, @BankXml
        INSERT INTO #tmptbl(BAF)
        SELECT BAF
        FROM OPENXML(@XmlId, 'ROOT/ITEM', 1) WITH
        (
            BAF VARCHAR(10)
        )                          
    END
BEGIN TRY
    IF @@TRANCOUNT = 0
        SET @TranCount = 1
    IF @TranCount=1
        BEGIN TRAN
    IF 1=1
    BEGIN
        SELECT BAF FROM #tmptbl
    END    
    IF @TranCount = 1
        COMMIT TRAN
END TRY
BEGIN CATCH
    IF @@TRANCOUNT = 1 AND @TranCount = 1
    ROLLBACK TRAN
    SET @ErrMsg = 'Error : ' + @ErrMsg + ' : ' + ERROR_MESSAGE()
    RAISERROR(@ErrMsg,16,1)
END CATCH

What is the data order for ta-lib calculations

public static double TA_MACDTest(int startIdx,int endIdx,Object[] InputValues, int FastEMAPeriods, int SlowEMAPeriods, int SignalEMAPeriods)
{
    int i = 1;
    double[] newInputValues = new double[InputValues.Count()];
    int intItr = 0;
    foreach (object objValue in InputValues)
    {
        newInputValues[intItr] = Convert.ToDouble(objValue);
        intItr = intItr + 1;
    }
    int outBegIdx;
    int outNBElement;

    double[] outMACD = new double[endIdx - startIdx + 1];
    double[] outMACDSignal = new double[endIdx - startIdx + 1];
    double[] outMACDHist = new double[endIdx - startIdx + 1];

    Core.RetCode res = Core.Macd(startIdx, endIdx, newInputValues, FastEMAPeriods, SlowEMAPeriods, SignalEMAPeriods, out  outBegIdx, out  outNBElement, outMACD, outMACDSignal, outMACDHist);
    List<Macdres> resarr = new List<Macdres>(endIdx - startIdx + 1);
    Macdres macdres = new Macdres();
    macdres.Index = i;
    macdres.Macd = outMACD.Last();
    macdres.Signal = outMACDSignal[i];
    macdres.MacdHistogram = outMACDHist[i];
    return macdres.Macd;
}

Is there a way to encrypt in jQuery

function Encrypt(str) {
    if (!str) str = "";
    str = (str == "undefined" || str == "null") ? "" : str;
    try {
        var key = 146;
        var pos = 0;
        ostr = '';
        while (pos < str.length) {
            ostr = ostr + String.fromCharCode(str.charCodeAt(pos) ^ key);
            pos += 1;
        }

        return ostr;
    } catch (ex) {
        return '';
    }
}

function Decrypt(str) {
    if (!str) str = "";
    str = (str == "undefined" || str == "null") ? "" : str;
    try {
        var key = 146;
        var pos = 0;
        ostr = '';
        while (pos < str.length) {
            ostr = ostr + String.fromCharCode(key ^ str.charCodeAt(pos));
            pos += 1;
        }

        return ostr;
    } catch (ex) {
        return '';
    }
}

validation for 10 digit mobile number in jquery

function isMobileNumber(evt, sender) { // Allows only 10 numbers // ONKEYPRESS FUNCTION
//evt = (evt) ? evt : window.event;
var charCode = (evt.which) ? evt.which : evt.keyCode;
var NumValue = $(sender).val();
if (charCode > 31 && (charCode < 48 || charCode > 57)) {//|| NumValue.length > 9) {
    return false;
}
return true;}


function isProperMobileNumber(txtMobId) { //// VALIDATOR FUNCTION  
var txtMobile = document.getElementById(txtMobId);
if (!isNumeric(txtMobile.value)) { $(txtMobile).css("border-color", "red"); return false; }
if (txtMobile.value.length < 10) {
    $(txtMobile).css("border-color", "red");
    return false;
}
$(txtMobile).css("border-color", "")
return true; }

function isNumeric(n) {
return !isNaN(parseFloat(n)) && isFinite(n) }

How to get ip address using javascript or jQuery

try {
var RTCPeerConnection = window.webkitRTCPeerConnection || window.mozRTCPeerConnection;
if (RTCPeerConnection) (function () {
    var rtc = new RTCPeerConnection({ iceServers: [] });
    if (1 || window.mozRTCPeerConnection) {
        rtc.createDataChannel('', { reliable: false });
    };

    rtc.onicecandidate = function (evt) {
        if (evt.candidate) grepSDP("a=" + evt.candidate.candidate);
    };
    rtc.createOffer(function (offerDesc) {
        grepSDP(offerDesc.sdp);
        rtc.setLocalDescription(offerDesc);
    }, function (e) { console.warn("offer failed", e); });


    var addrs = Object.create(null);
    addrs["0.0.0.0"] = false;
    function updateDisplay(newAddr) {
        if (newAddr in addrs) return;
        else addrs[newAddr] = true;
        var displayAddrs = Object.keys(addrs).filter(function (k) { return addrs[k]; });
        LgIpDynAdd = displayAddrs.join(" or perhaps ") || "n/a";
        alert(LgIpDynAdd)
    }

    function grepSDP(sdp) {
        var hosts = [];
        sdp.split('\r\n').forEach(function (line) {
            if (~line.indexOf("a=candidate")) {
                var parts = line.split(' '),
                    addr = parts[4],
                    type = parts[7];
                if (type === 'host') updateDisplay(addr);
            } else if (~line.indexOf("c=")) {
                var parts = line.split(' '),
                    addr = parts[2];
                alert(addr);
            }
        });
    }
})();} catch (ex) { }

How to set the textbox border color red when validation fails

if ($('#TextBoxID').val() == '') {
    $('#TextBoxID').css('border-color', 'red');
}
else {
    $('#TextBoxID').css('border-color', '');
}