Visual Studio Tips and Tricks
Alternate Case/Format selection:
Have you ever been asked to update some code from a long time ago only to find that almost every tag is in capital letters? AGHH!
<HTML> <HEAD> <TITLE>My Really Old Site</TITLE> </HEAD> <BODY> <P> Lots of body test </P> <P> Lots of body test </P> <P> Lots of body test </P> <IMG SRC="mypic.jpg" width=351 height=113> </BODY> </HTML>
Highlight all that code and press CTRL + K then CTRL + F and you will format all the code. It would then look something like this
<html> <head> <title>My Really Old Site</title> </head> <body> <p> Lots of body test </p> <p> Lots of body test </p> <p> Lots of body test </p> <img src="mypic.jpg" width="351" height="113"> </body> </html>
Granted your code may still be far from perfect, but it is definitely a huge help.
Key Launcher (Like Alt + Tab on Windows)
Are you someone that lives by keyboard shortcuts? I know I am. Are you familar with Windows Alt + Tab keyboard shortcut and toggling through all active programs? Well a similar feature exists within Visual Studio press Ctrl + Tab and toggle through your active Windows and Files.

Intellisense
Control + Spacebar will bring up intellisense if you are in code view. Great if you click out by accident or you just want to see what is available in the scope of the code.

Break Points
Have a bunch of break points scattered over a couple of files in a solution. Just want to delete them all and start fresh. Ctrl + Shift + F9 will delete all current break points in a solution. Don’t worry Visual Studio will prompt you with a confirmation first.
Get Visual Studio Professional for free!
Well maybe. If you are a student like myself you can head over to https://www.dreamspark.com/which is run by Microsoft. They offer full versions of some of the newest Microsoft products, like Visual Studio. Why? Because they know we are the future and they think we are an investment. Take them up on the opportunity and get ahead of the competition.
Shortcut key posters:
Microsoft Visual Studio has a bunch of keyboard combinations that can be very helpful, to get a more complete list check out some of the resources Microsoft offers:
Visual C# 2008 Keybinding Reference Poster
Visual Basic 2008 Keybinding Reference Poster
Visual C++ 2008 Keybinding Reference Poster
Visual C# 2005 Keyboard Shortcut Reference Poster
Overwriting an Excel file destination using SSIS
This was a problem I racked my brains over for a while when I first started using SSIS. I found a few possible including using a File System task to copy a “Template” Excel file over the existing on, or generating unique files by appending the date. I simply wanted to overwrite the existing data just like the Flat File Destination gives you that option.
My work around was as flows:
Create the Data flow the way you normally would, then go to the Control View Then add two Execute SQL Tasks before your data flow is called so it looks like this

Step 1: Add Execute SQL Task 1 to Control Flow
Set both Execute SQL Tasks to use the Excel file

Step 2: Set Connection Manager
Set your first Execute SQL Task’s SQL Command drop your table which is also known as the sheet name of your Excel file.

Step 3: Drop Table
Repeat step 3 on the second Execute SQL Command this time create your tables.
That’s it. Good luck.
C# .NET and LyricWiki to lookup lyrics
Music is everywhere with today’s high speed internet is most home it is no wonder that music is even moving to the World Wide Web. Many radio stations allow you to stream their stations over the internet. Many websites have been developed around music, like www.jango.com, www.pandora.com, and www.last.fm. I recently released my second version of Jango Desktop and one of the features I implemented was the ability to look up lyrics. Before I started I was thinking about all the ways I could parse the lyrics out of an existing lyric’s websites database. During my searching I stumbled upon http://lyricwiki.org/. Here is a small description of LyricWiki from the website:
LyricWiki is a free site which is a source where anyone can go to get reliable lyrics for any song, from any artist, without being hammered by invasive ads.
At this point you are probably thinking to yourself the same thing I did “Great, but where do I start?” So today I am writing a step by step tutorial on how to use Lyric wiki in your .NET program.
Creating a simple lyric demo program:

Step 1: Create the Form
Open visual studio and setup your form to look similar to mine.
Adding the web service:
Because LyricWiki offers a web service, you will want to add it to your program as a web reference. Right click on your solution and select add a web reference, or in .net 3.5 add a service reference -> then go to advance and add a web reference. The service’s URL is http://lyricwiki.org/server.php?wsdl you will want to add it like below if you press go you should see the available methods.

Adding a Web Reference
Writing the code:
Double click on your button on the form and let’s right some code to handle the lookup.
Add this to the top of your code:
using LyricsLookup.org.lyricwiki;
Then add this to the button clicked method:
private void LyricsButton_Click(object sender, EventArgs e)
{
LyricWiki wiki = new LyricWiki();
LyricsResult result;
string artist = artistTextBox.Text;
string song = SongTextBox.Text;
if(wiki.checkSongExists(artist,song))
{
result = wiki.getSong(artist, song);
Encoding iso8859 = Encoding.GetEncoding("ISO-8859-1");
LyricsRichTextBox.Text = Encoding.UTF8.GetString(iso8859.GetBytes(result.lyrics));
}else{
StatusLabel.Text = "Lyrics not found in database";
}
}
Then run and test.
Stop Google from indexing your Facebook account.
Login to Facebook and go to your privacy settings.

Select the Search Settings

Uncheck: “Create a public search listing for me and submit it for search engine indexing”

Edit: As Dan pointed out in the comments. Make sure your Search Visibility is set to everyone for the “Create a public search listing” option to show up.
It may take a week or more for search engines to completely remove your listing from their indexes. However Facebook is a popular site so I am sure it gets index quite frequently.


