Format String with String.Format and C#
January 3rd, 2009
<%# String.Format("{0:#####-####}", Convert.ToInt32(Eval("ZipCode"))) %>
It is necessary to convert the ZipCode field to an integer in this instance because the Format class expects an integer to properly format a number, otherwise it will only return the string or value that you passed to the Format class.
I am using this in conjunction with the MaskedEditExtender, which removes [...]
GoDaddy Now Allows Direct Access to MySQL on Shared Hosting Plans
December 25th, 2008
GoDaddy.com has recently added the ability for shared hosting plans owners to access their MySQL databases directly.
Once you start the MySQL creation process you will have the option to Allow/Disallow direct access.
This is very useful if you do not want to use phpMyAdmin to administer your MySQL database such as an initial import that exceeds [...]
Backup Windows Mail on Vista with xcopy
December 25th, 2008
I know you can backup your email directly from within Windows Mail but this script saves me a few clicks and I can run it in a scheduled task so I can set it and forget it.
Download
For impatient you can download the batch file here.
Find Windows Mail Store Location
Open Windows Mail and open Tools/Options.
[...]
No New Text Document with Right Click on Vista
December 21st, 2008
One of the features I use frequently in XP is the Create New X feature with the right click within Explorer. Vista does not have the option to create a new text document.
I found a forum post over at vistax64.com that has a fix.
Open notepad (Windows + r, notepad, enter) and copy the following:
Windows Registry [...]
Quickly Jump In Code with Zend Studio and Bookmarks
December 17th, 2008
This is a cool feature in Zend Studio for Eclipse (might be available for the base Eclipse Project as well) that allows you to bookmark your code to quickly jump from section to section for those large files.
Open a file to work with and right click the line you want to place a bookmark on.
[...]
101 Useful Web Developer and Web Designer Links
December 4th, 2008
Design
Color Pallete
Color Schemer
Colour Lovers
Color Combos
CSS
Forms
Spruce up Your Search Box with CSS and a Background Image
Fancy Form Design with CSS
Layouts
Fluid 3 Column – Content First in Code
Three Column Layouts
Perfect multi-column CSS liquid layouts – iPhone compatible
The Perfect 3 Column Liquid Layout (Percentage widths)
Layout Gala
[...]
Free Outlook PST Backup Tool
December 4th, 2008
Microsoft has a great Outlook PST backup tool. It’s main function is to backup your Outlook.pst file, which is your entire Outlook profile; Calendar, Emails, Contacts, Journals, everything.
Download
http://www.microsoft.com/downloads/details.aspx?FamilyId=8B081F3A-B7D0-4B16-B8AF-5A6322F4FD01&displaylang=en
Usage
http://office.microsoft.com/en-us/outlook/HA010875321033.aspx
Return Single Value with ExecuteScalar, Stored Procedures and C#
December 3rd, 2008
A common query is to return a single value from a SQL query such as an aggregate to get the total number of rows in a table. I will show you how to do just that with SQL Server Stored Procedures and C#.
Preparation
You will need some table data to query against. I am using the [...]
How to Download an Entire Web Page Screenshot
December 2nd, 2008
Firefox has a great plugin called Screengrab. It gives you several options if you want to copy the entire page, a small portion or what viewable.
Usage
Download
https://addons.mozilla.org/en-US/firefox/addon/1146
Download, install and restart Firefox.
How to Import Pictures from your iPhone on Vista
November 30th, 2008
If you are Windows user and need to import your pictures from your iPhone here is how you do it.
Plugin your iPhone to your computer with the supplied USB cable.









