Posts Tagged ‘ASP.NET/C#’

C#: Break vs. Continue in Foreach Loops

Tuesday, March 16th, 2010

A C# Quick Tip: You’ve probably seen ‘break’ before in Switch Case statements, but it also plays an important role in Foreach Loops.

To break completely out of a foreach loop (foregoing all the remaining loops), use: break;

To go to the next iteration in the loop, use: continue;

(more…)

Popularity: 1%

C#: That Pesky DBNull Error in Datatables

Monday, March 15th, 2010

Datatables and Tableadapters are one of the most beautiful things about C# and Visual Studio, until you’re processing rows in your datatable and you get something that reads like “The value for column ‘your_column’ in table ‘your_table’ is DBNull.”  If you go a little further, you may get:  “Exception Details: System.InvalidCastException: Specified cast is not valid.”  You may go to your Datatable in your Dataset and start trying to change the NullValue for the offending column or trying to change the DefaultValue in the column properties, but chances are that the data type will not let you change that NullValue.  It will insist on “(Throw Exception)”. (more…)

Popularity: 1%

C# – SQL Server Foreign Key, Unique constraints

Wednesday, May 27th, 2009

unique_key_constraintI got tripped up today with a particularly nasty Join statement that worked perfectly form 90% of the queries, but was blowing up at times.  The error message was: 

(more…)

Popularity: 11%

Get ASP.NET DropDownList Selected Value with jQuery

Friday, October 31st, 2008

With Microsoft’s recent announcement that they will begin shipping jQuery with Visual Studio, the little Javascript framework is about to hit the big time (it was already sort of big time, but this is BIG TIME).  And rightfully so.

(more…)

Popularity: 72%

ASP.NET – C# – Emulating the VB Control Array – Pt. 1

Wednesday, October 29th, 2008

For you veterans of VB6, the control array probably became an old friend, or at least an annoying neighbor if you didn’t like them.  You couldn’t help run across the concept in VB6 because every time you copy and pasted a control for the first time, you got asked if you wanted to create a control array.

(more…)

Popularity: 31%

ASP.Net C# – PHP Equivalents

Wednesday, September 17th, 2008

ASP.netphp_snow_2008

(more…)

Popularity: 8%

ASP.NET/C#: Convert HTML Colors to System.Drawing.Color

Wednesday, May 14th, 2008

HTML colors come in all sorts of flavors: hexadecimal (#0066ff), named colors (e.g. LightSkyBlue…here’s the link).

Many people may be very comfortable with working with HTML colors, so if you’re in C# and needing to get the .Net equivalent, you can translate directly from HTML colors with System.Drawing.ColorTranslator.FromHtml(). Here’s the usage: (more…)

Popularity: 13%