How to generate alpha numeric random numbers using function in MS SQL Server

///////////// Sql query

SELECT LEFT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),10)+RIGHT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),10)

--------------- for more secure string

SELECT LEFT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),4) + RIGHT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),4) +

LEFT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),4) +

RIGHT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),4)

--------------- Result

A6A1B0FA27A405B38515

CBB8E0390AF48984

Folder Names with Spaces in XCOPY doesn't work using batch or .bat file

//////////////////////////

Solution : ==>

 It's working if the source and destination folder and file with DIR is in the DOUBLE QUOTATION MARKS like given below-


xcopy "E:\ Folder name 1\Folder name 2\Folder name 3\file 2007130100.txt" "E:\Folder name 11\Folder name 12\Ftp\Folder name 13\"

Calculate Day Difference in 2 dates using jquery

/////////////// html

var days = DateDiff_BetweenTowDates("23/03/2020",  "24/05/2020", "dd/mm/yyyy");

              or

var days = DateDiff_BetweenTowDates("2020/03/23",  "2020/05/23", "yyyy/mm/dd");

              or

var days = DateDiff_BetweenTowDates("03/23/2020",  "05/25/2020", "mm/dd/yyyy");

////////////// js

function DateDiff_BetweenTowDates(dateFrm, DateTo, CurrentFormat) {

    var start, end;

    if (CurrentFormat.toLowerCase().substring(0, 2) == "dd") {

        var d1 = dateFrm.split('/');

        var d2 = DateTo.split('/');

        start = d1[1] + '/' + d1[0] + '/' + d1[2];

        end = d2[1] + '/' + d2[0] + '/' + d2[2];

    }

    else if (CurrentFormat.toLowerCase().substring(0, 2) == "mm") {

        start = dateFrm;

        end = DateTo;

    }

    else if (CurrentFormat.toLowerCase().substring(0, 2) == "yy") {

        var d1 = dateFrm.split('/');

        var d2 = DateTo.split('/');

        start = d1[1] + '/' + d1[0] + '/' + d1[2];

        end = d2[1] + '/' + d2[0] + '/' + d2[2];

    }

    else {

        return false;

    }

    var dt1 = new Date(start);

    var dt2 = new Date(end);

    return days = (dt2 - dt1) / (1000 * 60 * 60 * 24);

}

The source contains no DataRows OR filter datatable datetime in c#

///////////////////////////

///////// Method 1

            DataTable dt = new DataTable();

            DataTable dt2 = dt.Clone();

            var rows = dt.Select().Where(p => (Convert.ToDateTime(p["DateTime"]).Date >= System.DateTime.Now.AddDays(-50)) && (Convert.ToDateTime(p["DateTime"]) <= System.DateTime.Now.Date));

            foreach (var row in rows)

                dt2.ImportRow(row);

///////// Method 2

            DataTable dtn = new DataTable();

            dtn = dt.Clone();

            dtn = dt.Select().Where(p => (Convert.ToDateTime(p["DateTime"]).Date >= System.DateTime.Now.AddDays(-50)) && (Convert.ToDateTime(p["DateTime"]) <= System.DateTime.Now.Date)).CopyToDataTable();

 ///////// Method 3

            DataTable dt3 = new DataTable();

            dt3 = dt.Clone();

            var reRows = dt.Select().Where(m => ((DateTime)m["DateTime"]).Date >= DateTime.Now.Date);

            if (reRows.Any())

                dt3 = reRows.CopyToDataTable();

Reset all input value inside a control using jquery

///////////////js

function Reset_Controls(CtrlID_Cls, IsCtrlClass) {

    let ctlrid;

    if (IsCtrlClass) {

        ctlrid = $("." + CtrlID_Cls);

    }

    else {

        ctlrid = $("#" + CtrlID_Cls);

    }

    $(ctlrid).find("input[type=text], textarea").val("");

    $(ctlrid).find("input[type=checkbox]").prop(":checked", false);

    $(ctlrid).find('select').val($('select option').eq(0).val());

    /////// ******************** Set Null for all

    // $(ctlrid).find('select').val($('select').val([]);

    /////// ******************** Set value 0 for all

    //$(ctlrid).find("select").val("0");

}

Maintain Gridview Scroll Position Inside div and Update Panel in asp.net

/////////////// JS

<script type="text/javascript">

            var scrollTop;

            Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(BeginRequest);

            Sys.WebForms.PageRequestManager.getInstance().add_endRequest(EndRequest);

            function BeginRequest(sender, args) {

                var m = document.getElementById('TabledivGrid');

                scrollTop = m.scrollTop;

            }

            function EndRequest(sender, args) {

                var m = document.getElementById('TabledivGrid');

                m.scrollTop = scrollTop;

            }

        </script>

Not able to install bootstrap 4.0.0 (beta) nuget package to .Net MVC (.Net version 4.6.1)

////////////////////

 Manually add the popper.js package in to your packages config below-

<package id="WebGrease" version="1.6.0" targetFramework="net461" />

Now install package again. Its working fine