SuperWasp

Productivity tips, reviews, tools, software and gadgets.

How-To: Build Language dropdown with ASP.NET MVC and LINQ

Here's a quick way to build a language dropdown box with ASP.NET MVC Preview 3, without using a database table. In total we need only 3 lines of code.

1. Controller:

In our controller, we add the following code to the controller action:

List<System.Globalization.CultureInfo> Locales =
    System.Globalization.CultureInfo.GetCultures(
        System.Globalization.CultureTypes.NeutralCultures).ToList();

ViewData["Locales"] = new SelectList(
    Locales
    .OrderBy(lc => lc.Name.Length)
    .ThenBy(lc => lc.DisplayName),
    "Name",
    "DisplayName");

First we create a list of CultureInfo and store it in a variable Locales. For this example I've used NeutralCultures to limit the entries to the most used languages, otherwise you'll get a very long list.

Next we create a ViewData object and fill it using SelectList, passing along our Locales variable.

Note: I've sorted Locales twice, first with OrderBy and then with ThenBy. As parameter we throw in a Lambda expression to transform our Locales and get the member we want. The reason I sort on Name.Length first is that the Invariant CultureInfo has an empty Name and thus it will be sorted to the top of the list.

After that we simply render our View (in this case passing along a Contact record from the database.

2. View:

The code in our view is even simpler. With the help of Extensions and MVC HtmlHelper objects we have our dropdown box in no time:

The only line of code to render the fully functional html select dropdown box is this:

<%=Html.DropDownList("Locales") %>

Here is the final result:

A quick look at the produced code shows us the clean XHTML underneath:

<select name="Locales" id="Locales">
<option value="">Invariant Language (Invariant Country)</option>
<option value="af">Afrikaans</option>
<option value="sq">Albanian</option>
<option value="ar">Arabic</option>
<option value="hy">Armenian</option>
<option value="az">Azeri</option>
<option value="eu">Basque</option>
<option value="be">Belarusian</option>
<option value="bg">Bulgarian</option>
...

Ps: in the screenshots above I've used a test version of TheSansMono OpenType by Luc(as) de Groot. This font will be published soon on the LucasFonts website, together with TheSansCondensed OpenType. Typographer Luc(as) de Groot is also known for the Calibri and Consolas fonts in Windows Vista and Microsoft Office 2007.

Labels: .NET, asp.net, how-to, LINQ, MVC

» Full Article

  Posted by oVan on Wednesday, May 28, 2008 | PermaLink | 0 comments

How-To: Copy SQL table with identity to other database

If you ever wanted to copy a database table with contents to a different database, including the identity columns used for primary and foreign key relations, you might encounter an error message similar to this:

Msg 8101, Level 16, State 1, Line 2
An explicit value for the identity column in table 'D:\Db\Target.MDF.dbo.Languages' can only be specified when a column list is used and IDENTITY_INSERT is ON.

Here is the working SQL Query code to solve this problem:

SET IDENTITY_INSERT [D:\Db\Target.MDF].dbo.Languages ON
GO

INSERT INTO [D:\Db\Target.MDF].dbo.Languages (LanguageID, LanguageCodeID, CountryID, NameType, Name)
SELECT LanguageID, LanguageCodeID, CountryID, NameType, [Name]
FROM [D:\Db\Source.MDF].dbo.Languages AS SourceTable
GO

SET IDENTITY_INSERT [D:\Db\Target.MDF].dbo.Languages OFF
GO

Note the use of IDENTITY_INSERT and the list of columns before the SELECT statement.

Labels: how-to, SQL, tip

» Full Article

  Posted by oVan on Wednesday, May 28, 2008 | PermaLink | 0 comments

Dell UltraSharp 2709W Review & Driver

Update: a little bird pointed me to the first review of Dell 2709W.

Update 2: here's a link to the Dell 2709W User Manual

Dell has released drivers for the upcoming Ultrasharp 2709w LCD monitor. Download here: DELL_2709W_A00-00_R186104. This also means that an 2708w or 2708wfp will not be released.

Labels: Dell, driver, LCD, monitor

» Full Article

  Posted by oVan on Friday, May 16, 2008 | PermaLink | 2 comments

Microsoft Bluetooth 2.1 drivers for Vista SP1

Microsoft silently released Windows Vista Feature Pack for Wireless, which enables Bluetooth 2.1 support, a user interface for Unified Pairing and Windows Connect Now updates. Note: You must have Vista Service Pack 1 installed.

Update: Apparently you must contact your hardware manufacturer to obtain this feature pack. When I called Dell Gold Technical Support today, they had not heard of this update yet, and after an hour I got an email where they state that it will take another 3 to 4 weeks before it will be available from them.

Labels: Bluetooth 2.1, Microsoft, SP1, Vista

» Full Article

  Posted by oVan on Wednesday, May 14, 2008 | PermaLink | 0 comments