Blog

Articles, code snippets and news worth sharing.

SnippetApr 11, 2012
C# Reading Outlook Contacts
Read the default Outlook contacts folder from C# using the Outlook interop assembly and return them as a DataSet.
```
using Microsoft.Office.Interop.Outlook;
```
1 min read#C##Office
SnippetMar 30, 2012
jQuery KeyDown Event
A generic JavaScript function to capture a key press and run logic, such as clearing a field on backspace.
```
function CheckKey(e) {
    var keynum;
    if (window.event) // IE
    {
        keynum = e.keyCode;
    }
```
1 min read#ASP.NET#JavaScript#jQuery

SnippetMar 29, 2012

SharePoint Configuring WAS

PowerShell script to create the Word Automation Services service application in SharePoint 2010.

$serviceName = "Word Automation Service"
$appPool = $null

Add-PSSnapin Microsoft.SharePoint.PowerShell
$appPool = Get-SPIisWebServiceApplicationPool -Identity <appPoolName>
if ($appPool -eq $null)

1 min read#PowerShell#SharePoint#SharePoint 2010

SnippetMar 28, 2012
Visual Studio 11 Beta
A first look at the Visual Studio 11 Beta, with the splash screen and the main IDE window.
1 min read#Tools#Visual Studio
SnippetMar 27, 2012
SQL List All Triggers In Database
A query that returns every trigger in a database with its table, type and whether it is disabled.
```
USE YourDBName
GO
SELECT trigger_name = sysobjects.name,
      trigger_owner = 'x',
      table_schema = s.name,
      table_name = OBJECT_NAME(parent_obj),
```
1 min read#SQL
SnippetMar 23, 2012
SharePoint 2010 Modal Dialog
Open a page in a SharePoint 2010 modal dialog from JavaScript and handle the result when it closes.
```
var options = SP.UI.$create_DialogOptions();
options.width = 450;
options.height = 450;
options.url = "/_layouts/PageName.aspx";
options.showClose = true;
options.title = "Dialog Title";
```
1 min read#JavaScript#SharePoint#SharePoint 2010
SnippetMar 22, 2012
SQL List All Tables In Database
Return all tables in a SQL Server database by querying sys.tables.
```
USE YourDBName
GO
SELECT *
FROM sys.tables
```
1 min read#SQL
SnippetMar 20, 2012
SQL List All Stored Procedures
List every stored procedure in a database using INFORMATION_SCHEMA.ROUTINES.
```
SELECT * FROM
DatabaseName.information_schema.routines
WHERE routine_type = 'PROCEDURE'
```
1 min read#SQL

SnippetMar 19, 2012

jQuery getJSON

Populate a dropdown list from a JSON service using $.getJSON and $.each.

$.getJSON("URL", null,
   function (data) {
      $.each(data.d, function (i, result) {
         var optionText = "<option value='" + result.value + "'>"
            + result.text + "</option>";
         $('#ddlSelectTagId').append(optionText);

1 min read#JavaScript#jQuery

SnippetMar 19, 2012

jQuery Clearing DropDown

The fastest way to empty a select element: replace it with a shallow copy of itself.

function ClearOptions(id) {
    var selectObj = document.getElementById(id);
    var selectParentNode = selectObj.parentNode;
    var newSelectObj = selectObj.cloneNode(false); // shallow copy, no options
    selectParentNode.replaceChild(newSelectObj, selectObj);
    return newSelectObj;

1 min read#JavaScript#jQuery

SnippetMar 19, 2012
jQuery Ajax Call
A reusable $.ajax template for calling a JSON service with success and error callbacks.
```
$.ajax({
   url: GETURL,
   type: "GET",
   contentType: "application/json; charset=utf-8",
   dataType: "json",
   success: successCallback,
```
1 min read#JavaScript#jQuery
SnippetMar 19, 2012
C# Abstract Class
How to declare abstract classes and abstract members in C#, and how a derived class overrides them.
```
abstract class Stream
{
    public abstract void Write(char ch);
    public void WriteString(string s)
    {
        foreach (char ch in s) Write(ch);
```
1 min read#.NET#C#

Blog

Posts