View All Pending Changes in TFS

To view all pending changes (checked out files) in TFS you need to do the following:

1. Open a Visual Studio Command Prompt (or ensure that the “Microsoft Visual Studio 9.0\Common7\IDE” folder - usually in C:\Program Files - is available in your path).
2. Change to the root directory of the project you want to search for pending changes (eg. C:\Projects\MyCustomProject)
3. Run the following command:
   [sourcecode language='jscript']tf.exe status /r /user:*[/sourcecode ]

Quickly Generating GUIDs in Visual Studio 2008

One of the common tasks involved when creating sharepoint solutions is the generation of GUIDs. Visual Studio comes with a tool called GuidGen that lets you create GUIDs however it is annoying having to leave the Visual Studio environment.

I believe Visual Studio 2005 used to have it as an option under the Tools menu however i haven’t found where i can add the same shortcut in Visual Studio Team System 2008 (though i do notice that Visual Studio 2008 Professional DOES have a “Create GUID” shortcut under Tools - i’d still prefer the macro shortcut for ease of use especially when creating a lot of features).

I have however found a nifty alternate solution by Leon Zandman that describes creating a Macro to insert a guid into your current file. I’d just like to clarify some of the steps for those that haven’t dealt with Macros in Visual Studio 2008 before.

1. Load Visual Studio 2008 and goto Tools -> Macros -> Macro Explorer (Alt-F8 for short)
2. Right-click on “Macros” then select New Macro Project
3. Name your project (eg. GUIDGenerator) and choose a location to save it (note no space allowed in Project Name).
4. This should give you a new project with a “Module1″ sitting underneath it. Right-click on “Module1″ and select “Rename” to give it a more meaningful name (eg. GUIDGenModule).
5. Double-click on the newly renamed module and you should be shown the Visual Studio Macro IDE.
6. Enter the following code (the “D” in ToString can be customised see Leon’s article):

   •    Sub Create_GUID()
             DTE.ActiveDocument.Selection.Text = System.Guid.NewGuid().ToString("D").ToUpper()
         End Sub
     

7. Save and close the Macro IDE.
8. Back in the main Visual Studio window goto Tools -> Options
9. Goto the “Keyboard” option under the “Environment” tab.
10. In the “Show Commands Containing” text box type in “Create_GUID”
11. Select the Macro sub that you just created from the list (it should be the only one)
12. Click inside the “Press Shortcut Keys” textbox then press your desired keyboard shortcut for inserting a GUID (eg. Alt+G as Leon suggested makes a lot of sense).
13. Ensure the “Use Shortcut in” option is “Global” and click on “Assign”
14. Close the options window and you should be able to start using your keyboard shortcut to quickly insert GUIDs into text!
15. If you have any other Visual Studio windows open at the time you will need to close them and reload for the macro for the macro to be loaded (or you can goto the Macro Explorer window and manually load your Macro project)

Retrieve location of Temp folder for Current User

To determine the location of the Temp folder of the current user (generally for writing temporary files) use the following bit of c#:

string tempFolder = System.IO.Path.GetTempPath();

Remove Non-Alphanumeric Characters from a String

A colleague was looking for an easy way to remove all non-alphanumeric characters from a string and it took some time to find the easiest way was to use RegEx.Replace() as follows:

Regex.Replace(stringToCleanUp, "[\W]", "");

while /w (lowercase) matches any ‘word’ character, equivalent to [a-zA-Z0-9_]
/W matches any ‘non-word’ character, ie. anything NOT matched by /w

As an alternative if you don’t want to allow the underscore you can use [^a-zA-Z0-9].

The following regular expression quick reference helped in finding this solution:
Regular Expressions Quick Reference

Checking if a SPWeb Exists

Ran into a problem today where we were incorrectly trying to check if a web existed. We were trying:

private bool ChildWebExists(SPWeb parentWeb, string childWebName) {
    return null != parentWeb.Webs[childWebName];
}

however this always returns an actual SPWeb object, turns out the correct way is to check the Exists property of the returned object ie:

private bool ChildWebExists(SPWeb parentWeb, string childWebName) {
    using (SPweb childWeb = parentWeb.Webs[childWebName]) {
        return childWeb.Exists;
    }
}

Installing SQL Server 2005 Management Studio

For some reason Microsoft decided to ‘hide’ the installation of the Management Studio in 2005. In Sql Server 2000 you simply choose to install the “Client Tools” only. For SQL Server 2005 to just install the Management Studio as a standalone you need to browse to the “Tools\Setup” folder underneath the SQL Server install folder (eg. in my case of an English 64-bit install “DVD-ROM:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Tools\Setup”) and execute “SqlRun_Tools.msi”. The Mangmenet Studio is part of the Client Tools -> Management Tools.

Hello world!

Obligitary first post. Time to start blogging!