February 2012
-
ASP.NET Overview of Binding a DropDownList to a FormView
If you use (or want to use) .NET WebForms databinding then you know that dropdown lists can be tricky to populate and mange. For example, say you have a FormView control with an embedded DropDownList control that you want to bind and pre-select when someone views the form. It’s not immediately intuitive how to do…
-
No-SQL vs Relational Databases Overview
There is a lot of hype around No-SQL databases, even to the point where people are saying that the relational database (RDBMS) model is obsolete. I develop corporate applications and use relational databases to do this, so the talk about how relational databases are obsolete has prompted me to look further into both technologies. At the most…
-
SQL OpenRowSet Excel Query Returns Null Values
In an earlier article I reviewed how to query an Excel spreadsheet from SQL Server Management Studio (SSMS). I’ve found that this functionality is very useful, especially when working with data maintained by business users outside of a database system. For an overview of how to connect SSMS with an Excel WorkSheet, please see my detailed article covering…