Wednesday 18 July 2018

Single checked inside gridview using jquery

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


function SingleCheckInside_Table(th) {
                        var userType = $(th).closest('tr').find('td').eq(1).html();
                        var selectedIndex = $(th).closest('tr').index();
                        $('[id*=TableID] tr').each(function (index, item) {
                            if (index > 0) {
                                if (selectedIndex != index) {
                                    $('[id*=TableID] tr').eq(index).find('[id*=CheckboxID]').prop('checked', false);

                                }
                            }
                        });
                    }

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

  <table><tr><td>


<asp:CheckBox runat="server" ID="Checkboxid" onclick="return SingleCheckInside_Table(this);" />


 </td></tr></table>


Monday 16 July 2018

Get Name of the month in sql query

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

select left(DateName( month , DateAdd( month , month(Getdate()) , -1 )),3)

//////////// Jul

Disable Mouse Right Click, F12 and Ctrl+Shift+I, redirect to login page using jquery

////////////////////
http://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js

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

<script type="text/javascript">
                    $(document).ready(function () {
                        $(document)[0].oncontextmenu = function () { return false; }
                        $(document).mousedown(function (e) {
                            if (e.button == 2) {
                                alert('Sorry, This functionality is not enable!');
                                window.location.href = "Default.aspx";
                                return false;
                            } else {
                                return true;
                            }
                        });
                    });
                    $(document).keydown(function (event) {
                        if (event.keyCode == 123) { // Prevent F12
                            alert('Sorry, This functionality is not enable!');
                            window.location.href = "Default.aspx";
                            return false;
                        } else if (event.ctrlKey && event.shiftKey && event.keyCode == 73) { // Prevent Ctrl+Shift+I  
                            alert('Sorry, This functionality is not enable!');
                            window.location.href = "Default.aspx";
                            return false;
                        }
                    });

Disable Cut, Copy & Paste on page using jquery

///////////
http://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js

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


    <script type="text/javascript">
          $(document).ready(function () {
              // Prevent full page
              $('body').bind('cut copy paste', function (e) {
                  e.preventDefault();
              });

              //Prevent particular part of the page
              $('#Control-id').bind('cut copy paste', function (e) {
                  e.preventDefault();
              });
          });
</script>

Disable Mouse Right Click using jquery

////////// using jquery liv-

http://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js


      <script type="text/javascript">
                $(document).ready(function () {
                    //Disable full page
                    $("body").on("contextmenu", function (e) {
                        return false;
                    });

                    //Disable particular part of the page
                    $("#id").on("contextmenu", function (e) {
                        return false;
                    });
                });
            </script>

///////////////////////// or

<script type="text/javascript">
                    $(document).ready(function () {
                        $(document)[0].oncontextmenu = function () { return false; }
                        $(document).mousedown(function (e) {
                            if (e.button == 2) {
                                alert('Sorry, This functionality is not enable!');
                                return false;
                            } else {
                                return true;
                            }
                        });
                    });

                </script>

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...