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 so, but it’s really quite straightforward.
Here’s how: (more…)
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 basic level people make the mistake of assuming that it’s a one or the other arguement. This sort of thinking is incorrect though. No-SQL is not a replacement for relational databases and the two technologies are designed to address very different issues.
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 the subject. I continue to use the method of saving my SpreadSheet as a .xls format file which I then connect to using the OpenRowSet command with the Microsoft Jet OLEDB 4.0 driver. Once the Excel worksheet is query-able by SSMS it’s quite simple to work with this data just like you would work with a regular table.
However, one important caveat is that if your worksheet contains numeric as well as alphabetic data, this will confuse the driver and depending on the order of the data in your Spreadsheet, null results will be returned instead of the numeric data.
This behavior can be surprising when one first notices it, but happily it can be easily corrected so that you can properly query mixed data type columns.
I’ve heard about how pinging services can help to promote new content on one’s Web site. Basically a pinging service works by notifying a list of search providers when you post new content to your Web site or blog. My question is:
Do these work and are they needed for a WordPress.com blog?
While researching the issue I’ve read that these pinging services are no longer needed and can in fact lower your blog’s standing with the search engine.
For example, I took a look into Ping-o-Matic. This service appears to be integrated with WordPress so that a number of search providers are automatically notified as soon as you publish a new blog article (based on information I saw on the WordPress.com forums).
By default there is no HTML control that can act as both a dropdown list and an editable input area. The best resource to create such a control is the JQuery Combobox widget.
HTML and Web-based controls can cause confusion for users who are accustomed to using Windows applications. Often the look of Web-based controls is similar to the Windows-based equivalent, but then the behavior of the HTML control is sufficiently different to cause confusion with the user.
Case in point: drop-down lists in a Windows-based application often allow a user to either select from a list of options, or to enter free-form text themselves. There is no real equivalent for this on the Web which basically combines the functionality of a free-form text area with a select list.