MS SQL Server 2005 Transactions

by Duane 20. January 2010 02:08
Transactions within Microsoft SQL Server 2005 and greater using Try and Catch. [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , , , ,

T-SQL

T-SQL Subquery on Another Table in the SELECT Clause

by Duane 23. August 2009 05:46
An example that uses a subquery in a SELECT statement. [More]

Currently rated 3.0 by 2 people

  • Currently 3/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

T-SQL

Metadata From Sitemap To Master Page

by Duane 20. August 2009 06:56
This article describes how to add meta tags to a Master page from a web.sitemap file using the asp:content page as an input parameter. [More]

Currently rated 5.0 by 2 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

ASP.NET | Master Pages

Password Field Case Sensitive in MS SQL Server 2005

by Duane 17. August 2009 14:13
MS SQL Server is case insensitive by default To make a column case sensitive for a password field is a straight forward process you can do within Visual Studio [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

ASP.NET | T-SQL

Add Default Value to Dynamic asp:DropDownList With T-SQL

by Duane 26. June 2009 03:28
Use UNION ALL and a Sub Query with T-SQL to set a default value in a dynamic asp:DropDownlist. [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

ASP.NET | T-SQL

DHTML Popups from Stored Procedure

by Duane 20. June 2009 02:46
One of my recent projects had a requirement which called for an upcoming events menu with a DHTML popup for each entry that had a short description of the event. Since I didn't need ordering or paging I decided to display the content via an asp:DataList enclosed within a user control as in figur... [More]

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,

ASP.NET | T-SQL

It works!

by Debra 3. February 2009 01:54
Testing.  This 'blog' thing works for our band.  This will be interesting.....

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Return HTML From T-SQL Using CASE and LEN

by Duane 27. January 2009 02:05
Using T-SQL to return HTML with the LEN and CASE functions. [More]

Currently rated 5.0 by 2 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Metadata From Content To Master Page

by Duane 25. January 2009 19:48
Describes how to pass metadata to an ASP.NET Master page from it's content page in VB.NET and C# [More]

Currently rated 5.0 by 5 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:

Welcome to my blog

by Duane 25. January 2009 09:49
A blog on music and ASP.NET, VB.NET and C# programming [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , , ,

General