I hope everyone had a good Thanksgiving week. Despite the holiday, there were a couple of good posts this week!
Adam pointed out the issue with dates in the database. One thing to keep in mind, is that a date is a date (meaning a complete date with time and date), even if you mask it as short time or short date. If just the time is stored, really also a default date is stored. If you retrieve dates from the database and would only like to see the time part, a formatting string needs to be applied (i.e., {0:t}).
Also, there are times when you want to remember what object (i.e., user) you selected (i.e., from a drop down list). Obviously, you first have to retrieve the user based on the selection in the drop down list (i.e., username) and then store it in, for instance, a session variable.
Russell, probably getting more experience in DB connectivity than he wanted, summarized his database issues and the solutions pretty well in his latest post and thus is turning this into great learning experience for himself and possibly others reading his post.
And Sarah reached the limits of the Data Source control in the context of Master Pages. The data source control is nice, as it can be simply dropped on the Web Form (.aspx page) and then be configured with a Wizard. So no programming ... Well, this may actually be a good example of the concept of "leaky abstraction". The coding gets abstracted into a control and a configuration Wizard and thus requires less programming knowledge. However, it breaks down in master pages with more than one content placeholders (which is rare, but possible). As it turns out, the data source control in the first content place holder cannot "see" the textbox control in the other content place holder. However, it is no problem accessing controls from a different content placeholder in code (see example below).
Dim ws as New wrefBookService.BookService
myBooks = ws.getBooks(txtKeyword.Text) 'txtKeyword is in different content placeholder
myGridView.datasource = myBooks
myGridView.databind()
Last but not least, Paul found some interesting security articles that, for instance, question if Vista's focus on security is really paying off.
Now it is on to mobile applications!
MH