Silverlight Resolve Static Resource

Having trouble once again to resolve a static resource in Silverlight code, even though Styles.xaml is located inside the Assets directory?

Have a look at app.xaml if Application.Resources contains the following entry:

<ResourceDictionary>
  <ResourceDictionary.MergedDictionaries>
    <ResourceDictionary Source=”Assets/Styles.xaml”/>
   </ResourceDictionary.MergedDictionaries>
</ResourceDictionary>

XML Data Row Truncation At 2,033 Chars When Using SqlDataReader

When you read Extensible Markup Language (XML) data from Microsoft SQL Server by using the SqlDataReader object, the XML in the first column of the first row is truncated at 2,033 characters. You expect all of the contents of the XML data to be contained in a single row and column.

This behavior occurs because, for XML results greater than 2,033 characters in length, SQL Server returns the XML in multiple rows of 2,033 characters each.

To resolve this problem, use the ExecuteXmlReader method to read FOR XML queries. For additional information about how to use ExecuteXmlReader with SQL Server FOR XML queries, click the article numbers below to view the articles in the Microsoft Knowledge Base:
316016  (http://support.microsoft.com/kb/316016/ ) How to use the ExecuteXmlReader method of the SqlCommand class in Visual Basic .NET

316701  (http://support.microsoft.com/kb/316701/ ) How to use the ExecuteXmlReader method of the SqlCommand class in Visual C# .NET

307224  (http://support.microsoft.com/kb/307224/ ) How to use XML in connected and disconnected ADO.NET application

or: Use SqlDataReader an iterate through all the lines.

Calculate WeekOfYear from DateTime

using System;
using System.Globalization ;

namespace ConsoleApplication1
{
    class Class1
    {
        [STAThread]
        static void Main(string[] args)
        {
            DateTime dt = DateTime.Now;
            System.Globalization.Calendar objCal = CultureInfo.CurrentCulture.Calendar;    
            int weekofyear = objCal.GetWeekOfYear(dt, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday);
            
            Console.WriteLine(weekofyear.ToString() ) ;
        }
    }
}