October « 2007 « Bernds blog

Device filter error

Testing device filters on a mobile form I encountered the following error:

Can find neither a device capability named ‘IsNotMobile’ nor a public non-static method on the page named ‘IsNotMobile’ that returns a System.Boolean and takes System.Web.Mobile.MobileCapabilities and System.String as arguments.

I check the web.config and figured that the deviceFilters were properly declared:

<filter name="IsMobile" compare="IsMobileDevice" argument="true" [...]

Webparts do not work

Trying to use my first webpart I got this unfriendly error message from the run-time:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, [...]

Favourite database scripts

Here are the T-SQL database scripts I most frequently use when trouble-shooting.

– Empty transaction log (log file)
USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO

– Restore database from file
restore filelistonly from disk = ‘c:\temp\Name.bak’
restore database [Name] from disk = ‘c:\temp\Name.bak’ with move ‘name_dat’ to ‘c:\Program Files\Microsoft SQL Server\MSSQL\Data\Name.mdf’, move ‘name_log’ to ‘c:\Program [...]

Headset dimensions

Another off-topic bicycle blog entry. This time I figured out how to measure head sets. See the attached picture. Dimensions for my steel frame bikes are: 1" diamenter and 25.4 mm and 25.7 mm stack height.

57 mm breaks

This is off topic but I just found what I have been looking for. There are various options for high quality break with long calipers to use with old bikes.

Model
Reach
Shop [...]

.NET Refactoring tools

Refactoring

Jeg har fundet følgende kommercielle værktøjer, som har et Visual Studio PlugIn. Prisen i parentes er for fem licenser. Derudover er Martin Folwer refactoring hjemmeside http://www.refactoring.com/ en god resource.

ReSharper, 199 USD (995 USD), http://www.jetbrains.com/resharper/

C# Refactory, 99 USD (299 USD, site: 549 USD), http://www.xtreme-simplicity.net/CSharpRefactory.html

Refactor Pro, 99 USD (445,50 USD), http://www.devexpress.com/Products/NET/Refactor/

JustCode!, 199 USD [...]

To be null or not to be null

Når du indlæser data fra en database bliver du som regel nødt til at forholde dig til null problematikken, fordi alle kolonner i en database kan potentielt tillade værdien DBNull. Udfordringer ligger i:

Værdityper kan ikke være null.

Objekter kan være null, men der skal tjekkes mange steder for null værdi. Det er i mod [...]

Generic collections i .NET 2.0

Ved .NET 2.0 introducerede Microsoft generics, som er kendt som templates fra C++. Ved lejligheden fik collections klasserne et nytårskur. Der findes en række nye collections i 2.0 frameworket. Jeg vil prøve at give beslutningshjælp til hvilken collection man bedst anvender og giver nogle korte implementeringseksempler på sortering, søgning og ‘custom’ hashnøgler.

Navngivning af [...]

Slet al data i SQL Server database

Hvis det er nødvendigt at slette al data i alle tabeller i en SQL Server database kan følgende T-SQL script hjælpe:

– Source: http://vadivel.blogspot.com/2006/07/easiest-fastest-way-to-delete-all.html Set nocount on

Exec sp_MSForEachTable ‘Alter Table ? NoCheck Constraint All’

Exec sp_MSForEachTable ‘ If ObjectProperty(Object_ID(”?”), ”TableHasForeignRef”)=1 [...]

Debugging custom controls design time

Når du udvikler dine egne webcontrol’s og windows forms control’s, vil du som regel bygge en designer klasse per control. Designer klassen anvendes af Visual Studio for at bestemme control’s udseende i designer view i Visual Studio. For at debugge evt. fejl i designer klasse skal der startes en ny instance af Visual Studio, hvor [...]

Bernds blog

Search Blog

Categories

Archives