SQL Query - Optional "where" parametres
Create a SQL Select statement using an optional where parameter rather than having to convert the call into a TSQL dynamic query. [More]
Posted: Feb 09 2009, 21:37 by Adrian | Comments (371) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: SQL 2000 | SQL 2005 | SQL 2008 | TSQL | VS 2008
Missing Visual Studio 2008 Templates?
Missing Visual Studio 2008 Templates, re-install them using the instructions mentioned in this post. [More]
Posted: Feb 09 2009, 20:29 by Adrian | Comments (340) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: VS 2008
C# Thumbnail Generator
A C# version of the thumbnail generated as posted before on this blog. This is the raw code so you should be able to read C# already. [More]
Posted: Dec 02 2008, 18:54 by Adrian | Comments (409) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: ASP.Net 2.0 | C# | VB.Net
C# Select Case = Switch
Conversion of a VB.Net Select Case statement to a C# switch statement to perform the same task. Handy tip for people converting from one to the other. [More]
Posted: Nov 27 2008, 20:29 by Adrian | Comments (380) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: ASP.Net 2.0 | VB.Net | C#
Search DB for column names
Here is a handy bit of SQL used to search a database for tables that contain a specific column name. [More]
Posted: Oct 13 2008, 09:06 by Adrian | Comments (273) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: SQL
ASP.Net 2.0 - Display an RSS feed on your site
An ASP.Net 2.0 example of displaying an RSS feed from another source onto your website with minimal code whilst retaining some VB.Net for future developments. The example uses a GridView and XMLDataSource to bind an RSS feed which is assigned to the XMLDataSource in the VB. [More]
Posted: Sep 24 2008, 17:01 by Adrian | Comments (273) RSS comment feed |
  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: VB.Net | ASP.Net 2.0
Generate Thumbnail - VB.Net
A function that automatically creates a separate thumbnail of an uploaded/existing image on the file system. The code also takes into account the image quality loss that some image conversion examples have. The code is written in VB.Net and is called once the image has been uploaded and the logic checks to see if the conversion is required. [More]
Posted: Sep 23 2008, 14:28 by Adrian | Comments (795) RSS comment feed |
  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Filed under: VB.Net