Mittwoch, 30. März 2011

Windows Phone 7 - Nodo Update Gotcha

After reading some blogs about forcing the NoDo Update for Windows Phone 7, I had today the idea to deactivate the data connection and wlan at my HTC Mozart. After I have done this and I connected my phone via USB to my notebook – Surprise, surprise: The message for the NoDo Update appears.

After this I activated the celluar data connection again and everything goes his normal way. After 15 minutes with backup and installation I had the NoDo update on my phone.

Samstag, 26. März 2011

Donnerstag, 24. März 2011

Windows Phone 7: Touch behaviour for every control

Some controls at Silverlight for Windows Phone does not have any touch behaviour. I you have the need to implement this, the following sample code show you a good way:

Windows Phone: Touch | Jesse Liberty

WP7: WPConnect Tool for debug wo zune

Using the device debugger with a zune connection is a great advantage of Windows Phone 7 development. But if you want to test some choosers ( for example the PhotoChooserTask) you can not do this with a running zune connection.

Fortunately there's a tool that solves the problem by removing the need to have the Zune software running while debugging. It's called the Windows Phone Connect Tool. It was released as part of the recent update to the Windows Phone Developer Tools. This tool allows you to close the Zune software, after your phone device is connected. After this it is possible to debug choosers such as the PhotoChooserTask.

Here you can get a batch file to do the work for you:

Daniel Vaughan | A Batch File for Closing Zune and Launching the WPConnect Tool

Mittwoch, 9. März 2011

Artikel in dot.net-Magazin 4.2011

Mein Artikel “Windows Phone 7 – Alles unter Kontrolle” mit einem Überblick über die Windows Phone 7 Controls und deren Einsatz ist jetzt im dot.net-Magazin 4.2011 erschienen.

Cover_dotnetmagazin04211

Mittwoch, 23. Februar 2011

SQL Server 2008–Recompile all Stored Procedures

Just a useful script to recompile and check all Stored Procedures in a SQL Server Database, if you have done a lot of refactoring.

declare @Schema_Pattern nvarchar(776) = NULL -- Owner name Pattern for Like, Null for all 
declare @Proc_Name_Pattern nvarchar(776) = Null -- Proc Pattern for Like, Null for all
 
SET NOCOUNT ON 
 
-- First do the user databases specified in the control table DECLARE ProcCur CURSOR READ_ONLY FOR
            SELECT ROUTINE_SCHEMA
              , ROUTINE_NAME 
            FROM INFORMATION_SCHEMA.ROUTINES
            WHERE 0=OBJECTPROPERTY(object_id(ROUTINE_SCHEMA + '.' 
                                     + ROUTINE_NAME), 'IsMsShipped')
                        AND ROUTINE_TYPE = 'PROCEDURE'
                AND (@Schema_Pattern IS NULL 
                       OR ROUTINE_SCHEMA LIKE @Schema_Pattern)
              AND (@Proc_Name_Pattern IS NULL 
                       OR ROUTINE_NAME LIKE @Proc_Name_Pattern) 
 
DECLARE @Owner nvarchar(776)
      , @Proc  nvarchar(776)
      , @SQL   nvarchar(4000)
      , @NumP  int
      , @NumE  int
      , @myError int
      , @myRowcount int 
 
SELECT @NumP = 0 , @NumE = 0
 
OPEN ProcCur
FETCH NEXT FROM ProcCur INTO @Owner, @Proc 
 
WHILE (@@fetch_status <> -1) BEGIN
    IF (@@fetch_status <> -2) BEGIN
        SELECT @SQL = 'exec sp_recompile ''' + @Owner + '.' + @Proc + ''''
        PRINT 'Running: ' + @SQL
        EXEC (@SQL)
        SELECT @myError = @@Error        
        IF @myError = 0 BEGIN
              SET @NumP = @NumP + 1
            END
        ELSE BEGIN
             PRINT 'Error Marking ' + @Owner + '.' + @Proc + ':' + convert(varchar(20), @myError)
             SET @NumE = @NumE + 1
        END
    END
 
   FETCH NEXT FROM ProcCur INTO  @Owner, @Proc END
 
CLOSE ProcCur
DEALLOCATE ProcCur
 
 
 
 

Donnerstag, 17. Februar 2011

Mobile Technology WP7 unter Kontrolle

 

mobile-technology-cover

Heute ist in der Mobile Technology in der Ausgabe 01.2011 mein neuester Windows Phone 7 Artikel erschienen.Der Artikel gibt einen Überblick über die Windows Phone 7 Controls, zeigt Unterschiede zur Handhabung gegenüber den normalen Silverlight Controls und gibt wichtige Nutzungshinweise zu deren effektiven Einsatz.