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>

Ajax Mask Delimiters in asp.net

//HTML

<asp:ToolkitScriptManager ID="toolkitM" runat="server"></asp:ToolkitScriptManager>

<asp:TextBox ID="txt_code" runat="server" Width="130px" Height="22px" />

<asp:MaskedEditExtender ID="MaskedEditExtender2" runat="server"

            TargetControlID="txt_code"

             Mask="9,999,999.99"

             MessageValidatorTip="true"

             OnFocusCssClass="MaskedEditFocus"

             OnInvalidCssClass="MaskedEditError"

             MaskType="Number"

             InputDirection="RightToLeft"

             AcceptNegative="Left"

             DisplayMoney="Left"

             ErrorTooltipEnabled="True">

             </asp:MaskedEditExtender>

//Result - only numeric with decimal

<asp:TextBox ID="txt_code" runat="server" Width="130px" Height="22px" />

<asp:MaskedEditExtender ID="MaskedEditExtender2" runat="server"

            TargetControlID="txt_code"

             Mask="LL/999,999.99"

             MessageValidatorTip="true"

             OnFocusCssClass="MaskedEditFocus"

             OnInvalidCssClass="MaskedEditError"

             MaskType="Number"

             InputDirection="RightToLeft"

             AcceptNegative="Left"

             DisplayMoney="Left"

             ErrorTooltipEnabled="True">

             </asp:MaskedEditExtender>

//Result - Alpha/numeric,numeric.numeric

Mask Type-

None – No validation
Number – Number validation
Date – Date validation
Time – Time validation
DateTime – Date and time validation

1) Mask Characters and Delimiters
9 - Only a numeric character
L - Only a letter
$ - Only a letter or a space
C - Only a custom character (case sensitive)
A - Only a letter or a custom character
N - Only a numeric or custom character
? - Any character

/ - Date separator
: - Time separator
. - Decimal separator
, - Thousand separator
\ - Escape character
{ - Initial delimiter for repetition of masks
} - Final delimiter for repetition of masks