Code Nuggets: A Side-effect of Using DropDownList AppendDataBoundItems With Databound Items

Picture this: You have a webform with two DropDownLists, both of them are databound to some data you get from a database. Now the first DropDownList’s selection determines the contents of the second dropdown. So you simply do a AutoPostBack = true for the first dropdown and populate the second dropdown in the handler function. [...]

Code Nuggets: Getting two SQL column values in a single column

Well this type of thing doesn’t come up very frequently (at least to me) and if you’re like me working on multiple databases it gets very frustrating when it does come up. Since I don’t use it very frequently, I tend to forget how to do it properly in the database system I am using [...]