Maintain Panel/Div Scroll Position in UpdatePanel On Postback ASP.NET

  <form id="form1" runat="server">  
  <asp:ScriptManager ID="ScriptManager1" runat="server" ScriptMode="Release" />  
   <script type="text/javascript">  
     // It is important to place this JavaScript code after Ajax ScriptManager / Toolkit Script  
     var xPos, yPos;  
     var prm = Sys.WebForms.PageRequestManager.getInstance();  
     function BeginRequestHandler(sender, args) {  
       if ($get('<%=Panel1.ClientID%>') != null) {  
        // Get X and Y positions of scrollbar before the partial postback  
        xPos = $get('<%=Panel1.ClientID%>').scrollLeft;  
       yPos = $get('<%=Panel1.ClientID%>').scrollTop;  
     }  
   }  
   function EndRequestHandler(sender, args) {  
     if ($get('<%=Panel1.ClientID%>') != null) {  
        // Set X and Y positions back to the scrollbar  
        // after partial postback  
        $get('<%=Panel1.ClientID%>').scrollLeft = xPos;  
        $get('<%=Panel1.ClientID%>').scrollTop = yPos;  
      }  
    }  
    prm.add_beginRequest(BeginRequestHandler);  
    prm.add_endRequest(EndRequestHandler);  
  </script>  
  <asp:UpdatePanel ID="UpdatePanel1" runat="server">  
   <ContentTemplate>  
    <asp:Panel ID="Panel1" runat="server" Height="300px">  
     <%--Data--%>  
    </asp:Panel>  
   </ContentTemplate>  
  </asp:UpdatePanel>  
 </form>  

[Solved] Ajax async postback end does not work Script Error : Uncaught Sys.ScriptLoadFailedException: Sys.ScriptLoadFailedException: The script failed to load. Check for: Inaccessible path. Script errors. (IE) Enable 'Display a notification about every script error' under advanced settings. Missing call to Sys.Application.notifyScriptLoaded().

Solution For ajax async postback end does not work

 <script type="text/javascript">  
      function pageLoad(sender, args) {  
        //$(document).ready(function () {  
        Sys.WebForms.PageRequestManager.getInstance().add_beginRequest(beginReq);  
        Sys.WebForms.PageRequestManager.getInstance().add_endRequest(endReq);  
        Sys.Browser.WebKit = {}; //Safari 3 is considered WebKit  
        if (navigator.userAgent.indexOf('WebKit/') > -1) {  
          Sys.Browser.agent = Sys.Browser.WebKit;  
          Sys.Browser.version = parseFloat(navigator.userAgent.match(/WebKit\/(\d+(\.\d+)?)/)[1]);  
          Sys.Browser.name = 'WebKit';  
        }  
        var xPos, yPos;  
        function beginReq(sender, args) {  
          //  $find(ModalPopup).show();  
        }  
        function endReq(sender, args) {  
          //  $find(ModalPopup).hide();  
        }  
        //});  
      }  
 </script>  

Use this script inside the page. :)

Send SMS From SQL Server Using SMS API

                Declare @MobileNo varchar(12)='Mobile Number', @smstext as varchar(300)='Message'  
                Declare @iReq int,@hr int   
                Declare @sUrl as varchar(500)   
                DECLARE @errorSource VARCHAR(8000)  
                DECLARE @errorDescription VARCHAR(8000)   
                EXEC @hr = sp_OACreate 'Microsoft.XMLHTTP', @iReq OUT                  
                if @hr <> 0   
                  Raiserror('sp_OACreate Microsoft.XMLHTTP FAILED!', 16, 1)   
                set @sUrl='http://sapteleservices.com/SMS_API/sendsms.php?username=YourUserName&password=YourPassword&mobile=#MobNo#&sendername=YourCode&message=#Msg#&routetype=1'  
                set @sUrl=REPLACE(@sUrl,'#MobNo#',@MobileNo)   
                set @sUrl=REPLACE(@sUrl,'#Msg#',@smstext)   
                EXEC @hr = sp_OAMethod @iReq, 'Open', NULL, 'GET', @sUrl, true   
                if @hr <> 0   
                     Raiserror('sp_OAMethod Open FAILED!', 16, 1)   
                EXEC @hr = sp_OAMethod @iReq, 'send'   
                if @hr <> 0   
                  Begin   
                    EXEC sp_OAGetErrorInfo @iReq, @errorSource OUTPUT, @errorDescription OUTPUT  
                    Raiserror('sp_OAMethod Send FAILED!', 16, 1)   
                  end   
                else   
                Begin  
                  EXEC @hr = sp_OAGetProperty @iReq,'responseText'  
                  /*SMS LOG IF ANY*/  
                end  

*IF THERE ANY ERROR PLEASE EXECUTE THIS FIRST THEN TRY AGAIN

 exec sp_configure 'show advanced options', 1  
 go  
 reconfigure  
 go  
 exec sp_configure 'Ole Automation Procedures', 1 -- Enable  
 -- exec sp_configure 'Ole Automation Procedures', 0 -- Disable  
 go  
 reconfigure  
 go  
 exec sp_configure 'show advanced options', 0  
 go  
 reconfigure  
 go  

How To do Case Sensitive String Match in SQL Server

Using:

 COLLATE SQL_Latin1_General_CP1_CS_AS  

Example:

 select * from tblUser where userpwd='aBcD.123' COLLATE SQL_Latin1_General_CP1_CS_AS ;