How to change the title of a jquery dialog

Here is an image that a user can click to get help

   <img src="/Content/images/Help.png" style="cursor:pointer" onclick="javascript:ShowHelp('My Title')" />

Here is the jquery dialog

   <div id="dialog-help" title="" style="background:white">
      <div id="divHelpContents"></div>
   </div>

Javascript function to set up the dialog

      $(document).ready(function ()
      {
         //Help popup
         $("#dialog-help").dialog({ autoOpen: false
            , modal: true
            , width: 415
            , height: 300
            , show: "blind" //animation effect
            , hide: "clip" //animation effect            
            , draggable: true
            , resizable: false
            , buttons: {
               Ok: function ()
               {
                  $(this).dialog("close");
               }
            }
         });
      });
Here is a function that will update the title, help contents, and open the dialog
      function ShowHelp(topic)
      {
            $("#dialog-help").dialog('option', 'title', topic);
            $("#divHelpContents").html("Show some help contents here");
            $("#dialog-help").dialog("open");
      }

How to get paste to work with Remote Desktop Connection

You can copy things to the clipboard and paste them into your remote desktop connection.

What do you do when paste stops working ?

1.  Close your remote desktop connection (you don't need to log out).

2.  Reconnect.

How to re-insert deleted records when there is an identity field

My customers like to delete important records and then have me restore them from a backup when they realize their mistake.

When the column has an identity field, and you want to restore the records with the same number as they had before deleted, you must turn on identity insert with this TSql command

SET IDENTITY_INSERT {YourTableName} ON 

insert the deleted records

SET IDENTITY_INSERT {YourTableName} OFF 

How to detect if an element is hidden in jQuery

This will work when myID was hidden using .hide( ) and displayed using .show( )

if($("#myID").is(":visible"))
   $("#myID").hide();
else
   $("#myID").show();

How to get rid of Unexpected error 0x8ffe2740 occurred in IIS 5

Running XP, I stopped my Default website and rebooted my computer.

Then when I tried to restart my website, I was getting the error "Unexpected error 0x8ffe2740 occurred".

This was because Skype started before IIS.

To resolve, quite Skype, restart IIS, start your site, then restart Skype

How to refresh Intellisense in SQL Server 2008

Intellisense in SQL Server 2008 Management Studio is a great feature. When adding a table, column etc, your Intellisense doesn't know about the change right away.

To fix this

Edit > Intellisense > Refresh Local Cache

How to find the value of a dropdown in a user control using jQuery

you may have an asp:Dropdown control with an id="ddViewBy" like below.

<asp:DropDownList class="ddList" runat="server" ID="ddViewBy" AutoPostBack="true" OnSelectedIndexChanged="ddViewBy_Changed"><asp:DropDownList>

If your dropdownlist is in a user control and the usercontrol is in a content place holder, then when you view source, on the web page the id of the control would change to something like this:

id="ctl00_phContent_ucSearchFilter_ddViewBy"

To find the value of the dropdown using jQuery, use the following selector

$('select[id$=ddViewBy]').val();

This is reliable, because your user control could be in different place holders which would cause the first part of the id to be different. The controls id will always end with your original name.

The $= means "ends with"

Just an FYI, ^= means "begins with"