Preserve scroll position of DIV in UpdatePanel through Postback in asp.net

<script type="text/javascript">

    window.onload = function () {

        var div = document.getElementById("divid");

        var div_position = document.getElementById("div_position");

        var position = parseInt('<%=Request.Form["div_position"] %>');

        if (isNaN(position)) {

            position = 0;

        }

        div.scrollTop = position;

        div.onscroll = function () {

            div_position.value = div.scrollTop;

        };

    };

</script>

  <div id="divid" style="width:97%; overflow:auto; min-height: 430px; max-height: 430px;">

// Your Code

</div>

<input type="hidden" id="Hidden1" name="div_position" />

Maintain Page Scroll Position On Partial Postback ASP.NET

// add in page directory

<%@ Page Title="" Language="C#" MasterPageFile="~/Master Pages/MainMaster.master"

    MaintainScrollPositionOnPostback="true" %>

Maintain Panel Scroll Position On Partial Postback ASP.NET

<script type="text/javascript">

            // It is important to place this JavaScript code after ScriptManager1

            var xPos, yPos; // Set X and Y positions

            var prm = Sys.WebForms.PageRequestManager.getInstance();

            function BeginRequestHandler(sender, args) {

                if ($get('<%=pnl_memgrid.ClientID%>') != null) {

                    // Get X and Y positions of scrollbar before the partial postback

                    xPos = $get('<%=pnl_memgrid.ClientID%>').scrollLeft;

                    yPos = $get('<%=pnl_memgrid.ClientID%>').scrollTop;

                }

            }

            function EndRequestHandler(sender, args) {

                if ($get('<%=pnl_memgrid.ClientID%>') != null) {

                    // Set X and Y positions back to the scrollbar

                    // after partial postback or full post back

                    $get('<%=pnl_memgrid.ClientID%>').scrollLeft = xPos;

                    $get('<%=pnl_memgrid.ClientID%>').scrollTop = yPos;

                }

            }

            prm.add_beginRequest(BeginRequestHandler);

            prm.add_endRequest(EndRequestHandler);

 </script>

Export multiple DataTable to multiple Excel sheets using OpenXml in ASP.Net

protected void Btn_MSExport_Click(object sender, EventArgs e)

    {

        DataSet ds = getDataSetExportToExcel();

                ds.Tables[0].TableName = "Customers";

                ds.Tables[1].TableName = "Employees";

        using (XLWorkbook wb = new XLWorkbook())

        {

            wb.Worksheets.Add(ds);

            wb.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Center;

            wb.Style.Font.Bold = true;

            Response.Clear();

            Response.Buffer = true;

            Response.Charset = "";

            Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";

            Response.AddHeader("content-disposition", "attachment;filename= EmployeeAndOrderReport.xlsx");

            using (MemoryStream MyMemoryStream = new MemoryStream())

            {

                wb.SaveAs(MyMemoryStream);

                MyMemoryStream.WriteTo(Response.OutputStream);

                Response.Flush();

                Response.End();

            }

        }

    }

Generate random string using sql server NEWID() method

declare @password varchar(30)

set @password=(SELECT RIGHT(REPLACE(CONVERT(VARCHAR(36),NEWID()),'-',''),26))

select @password

//REsult//

//B067EC4004AA96ED32476E0DC0

Generate random alphanumeric string using sql server Comma table exp

WITH n(n) AS (

SELECT 1 UNION ALL SELECT n+1 FROM n WHERE n<62

)

SELECT LEFT(

(SELECT ''+SUBSTRING('0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZqwertyuiopasdfghjklzxcvbnm',n,1)

FROM n ORDER BY NEWID() FOR XML PATH('')),25)

//result//

//zV0hOY7bpqNJcAMjUakg1BnyX

Calculate day,month and year using javascript

    <html>

<head>

<title>Date substraction</title>

</head>

<body>

<script language="JavaScript" type="text/javascript">

<!--

    var myVar = prompt("Please enter a date: ")

    var udate = Date.parse(myVar);

    var todate = new Date();

    var diffdate = user_date - today_date;

    var years = diffdate / 31536000000;

    var months = (diffdate % 31536000000) / 2628000000;

    var days = ((diffdate % 31536000000) % 2628000000) / 86400000;

    document.write("Number of years: " + Math.floor(years) + "<br>");

    document.write("Number of months: " + Math.floor(months) + "<br>");

    document.write("Number of days: " + Math.floor(days) + "<br>");

//-->

</script>

</body>

</html>