SQL Server / T-SQL Snippets

New Snippets

Update Content Label Text From Master Page ASP.Net - C# Miscellaneous

The following code snippet demonstrates how to update the Text property of a Label control located in a page which uses a master page from within the master page code behind file.

HTML Table Paging Javascript Navigation

The following code snippet demonstrates how to apply paging to a HTML table element.

Get Textarea Data Length Javascript Miscellaneous

The following code snippet demonstrates how to display the data length of a textarea element as the user types in data.

Custom TextBox Control With BackColor Hover C# Controls

The following code snippet demonstrates how to create a custom TextBox control, which can change its background color when a user hovers over the TextBox control.

TextBox Validating Event C# Controls

The following code snippet demonstrates how to validate TextBox controls using the Validating event.

Bing Map Control C# - Windows Mobile Controls

This simple code snippet demonstrates how to set the latitude and longitude for the Bing Map control.

Count Down Timer C# - Windows Mobile Miscellaneous

This code snippet demonstrates how to use the DispatcherTimer class to create a count down timer.

Edit And Update A listView Control ASP.Net - C# Controls

The following code snippet demonstrates how to bind a ListView control to a DataTable object and allow the user to edit rows using the ItemEditing and ItemUpdating events of the listView control. This example uses a Microsoft SQL Server and connects to the sample AdventureWorks database.

Remove All Options From Select Javascript Miscellaneous

The following code snippet demonstrates how to clear a select element and remove all options from it.

ListView With DataPager ASP.Net - C# Controls

The following code snippet demonstrates how to page through a ListView control using the DataPager control.

Bind ListView To DataTable ASP.Net - C# Controls

The following code snippet demonstrates how to bind a ListView control to a DataTable object. It also shows how to use the ItemTemplate to display the data.

XmlWriterSettings Example ASP.Net - C# XML

The following code snippet shows how to indent Xml data when using the XmlWriter class.

Deserialize Object From Xml File ASP.Net - VB XML

The following code snippet demonstrates how to deserialize an object from an Xml file and cast the object back into its original type.

Serialize Object To Xml ASP.Net - VB XML

The following code snippet demonstrates how to serialize an object and save it to an Xml file using the XmlSerializer class.

Save And Load Images Drawn On Canvas C# - Windows Mobile Graphics

The following code snippet demonstrates how to draw on a canvas. The canvas image can then be saved and loaded. Images are saved to isolated storage.

Top SQL Server / T-SQL Snippets

This code snippet gets a list of database users.

This code snippet gets a list of all stored procedures

Set database to multi user mode.

This code snippet shows how to convert a varchar string into an MD5 hash

This code snippet gets the total days in a month.

This code snippet sets a database to single user mode.

This code snippet can be used to return Xml data of a selected table.

This code snippet shows how to reset the identity seed for a table. The third argument is the reset seed value.

This code snippet enables the Sql Server Service Broker

This code snippet gets a list of databases.