I created a report with SQL Server Reporting Services. It displayed some data and the toolbar with list of checkboxes that defined which columns should be displayed on the report (see the screenshot below). The problem was the font on the toolbar didn’t match the font on the report, i.e. it was huge in comparison to the report. In short it needed resizing…

Solution

I used Firefox and Firebug to find out the container that kept the toolbar (see below).

Once I learned the identifier of that container I know what CSS definition should be added to the page that contained the ReportViewer:

That’s it!

Basically I had a table which looked like this

What I wanted was to select all as one row as a set of items separated with a comma, where an item was ‘id: name’. The items had to be sorted by the id. So the result was supposed to look as below:

Solution

Initially I tried to write one SELECT:

SELECT
STUFF
(
	(
	SELECT ', ' + cast(id AS NVARCHAR(max)) + ': ' + name
	FROM People
	ORDER BY Id
	FOR XML PATH ('')
	),1,1,''
)

The problem here was FOR XML PATH escaped characters that could break the XML (e.g. ‘<' was replaced with '<'), which was not acceptible for me.

I looked for another solution but whatever I tried didn't work because of the ORDER BY statement which can't be used in a subquery or inline view.
Finally I decided to use a temporary table filling it with correct data and then create the final result. Here is the code:

DECLARE @res NVARCHAR(max)
SET @res = ''

CREATE TABLE #Result ( item nvarchar(max) )

INSERT INTO #Result
SELECT CAST(Id AS NVARCHAR(max)) + ': ' + Name AS item
FROM People
ORDER BY id

SELECT @res = @res + item + ', ' from #Result
SELECT substring(@res,1,len(@res)-1) as Result

If you find a better solution can you please post it as a comment? I could use in in future Thanks in advance!

Wireless Configuration
Incorrect MFC DLL version installed on this system; minimum requirement is MFC SP4 Dlls.

The message wouldn’t stop popping up, rebooting didn’t help.

Solution

Google was not much of help there. The best advice found was this; it didn’t help though. Finally I decided to remove Dell Wireless Manager because… it had the same icon that this annoying pop-up This helped!

At the moment I can’t do much more about the wireless because my router is in the service. When it’s back I’m going to reinstall the software for wireless and I hope all works grand. If I have any problems I’ll update this post.

Dziś postanowiłem zrobić upgrade swojego fotobloga z Wordpress 2.6.1 na 2.8. Wszystko poszło sprawnie ale okazało się, że kodowanie polskich znaków totalnie się posypało – zamiast nich kwadraciki i krzaczki.

Pomimo mocnego zaplecza, przyznam, że zabawa z kodowaniem znaków totalnie mi nie odpowiada. Miałem już kiedyś problem z ukraińską stroną znimky.net, która stała się nieczytelna po zmianie MySQL z 4.0 na 4.1. Po długich bojach problem został rozwiązany poprzez dodanie poniższych 3 linii kodu PHP po ustnawieniu połączenia z bazą danych:

mysql_query("SET character_set_results=\"utf8\"");
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES \"utf8\"");

Zacząłem szukać ale nie znalazłem zbyt wiele…

Dwa najciekawsze zasoby to Polski Support WordPress oraz post Polskie znaki w Wordpress na serwerze home.pl. Ten ostatni okazał się strzałem w dziesiątkę, chwila zabawy i blog znów był czytelny!

W moim przypadku rozwiązaniem było edycja pliku /wp-includes/wp-db.php. Tak jak radził Luke Szkudlarek, na końcu funkcji select($db) dodałem ustalanie kodowania połączenia z bazą danych:

mysql_query('SET NAMES latin2');

W moim przypadku musiałem użyć innego kodowania. Zmiana ustawień Wordpresa (Options -> Reading) nie była konieczna.

XML documentation comments are also important, particularly for public members/methods. Even if your project doesn’t require generating full XML documentation of the code, using Intellisense can be much more effective if it summarizes the method you are trying to use. If you want to generate XML documentation for C# in the twinkling of an eye you MUST install Roland Weigelt’s GhostDoc plugin for Visual Studio. Let me cite the author:

GhostDoc is a free add-in for Visual Studio that automatically generates XML documentation comments for C#. Either by using existing documentation inherited from base classes or implemented interfaces, or by deducing comments from name and type of e.g. methods, properties or parameters.

Once the plugin is installed and you have restared Visual Studio, go inside a method and press Ctrl + Shift + D. The XML documentation for the method appears just like that; it contain the summary, description of parameters, and information what the method returns. The only thing you have to do is to give a method a descriptive name and eventually polish what’s been generated. BTW, it works too for attributes and classes.

GhostDoc really saves your time and makes you a better developer – yet you care about the XML documentation, which is something of a higher level of understanding than your perfect code

This tool is much better – now code looks more fancy and you can always show/copy to clipboard the very code (without additional characters that need removing). If you’re running a blog where you publish fragments of code – don’t wait and install this tool now!

The only problem that change introduced was I had to change all old posts so that code is picked up by this plugin. It took an hour but was worth it.

Solution (tested on Windows 2003)

RDC to another server in the same workgroup as the one you cannot access and go to Administrative Tools / Terminal Services Manager.

From the menu select Actions / Connet to Computer… and provide the name of the server you couldn’t reach. Press OK and you will see open sessions on that server – users who logged in but for some reason haven’t logged out. Right click on the desired user and choose Log Off.

That should solve the case.

2009-05-19 11:01:45,078 ERROR [5232] XXX - Speaker already deleted: Castle.ActiveRecord.Framework.ActiveRecordException: Could not perform Delete for Speaker ---> NHibernate.Exceptions.GenericADOException: could not delete collection: [XXX#XXX][SQL: SQL not available] ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'SpeakerId', table 'XXX.dbo.lnk_Session_Speaker'; column does not allow nulls. UPDATE fails.
The statement has been terminated.
   ...
   at SpeakerProxy3e9fd3b0e82745c2b91b8a353acaa93d.DeleteAndFlush()

Background

I had three tables and classes representing them: Session / app_Session, Speaker / app_Speaker, and SessionSpeaker / lnk_Session_Speaker.

Speaker declared collection of links session-speaker as follows:

[HasMany(Lazy = true, Table = "lnk_Session_Speaker", ColumnKey = "SpeakerId", Cascade = ManyRelationCascadeEnum.Delete)]
public virtual IList SessionSpeakers
{
   get { return _sessions; }
   set { _sessions = value; }
}

The above described problem occured when I tried to delete a speaker who was assigned to a session – there was a row in lnk_Session_Speaker which represented this connection. Speakers who were not linked could be deleted just fine.

Solution

The reason for the difficulties was lack of Inverse = true declaration for collection of links session-speaker in Speaker class. This statement means that this side (from Speaker’s perspective) is the inverse side – that a Speaker is pointed by SessionSpeaker.

[HasMany(Lazy = true, Table = "lnk_Session_Speaker", ColumnKey = "SpeakerId", Cascade = ManyRelationCascadeEnum.Delete, Inverse = true)]
public virtual IList SessionSpeakers
{
   get { return _sessions; }
   set { _sessions = value; }
}

With this link objects (rows from lnk_Session_Speaker table) could be removed first and and then the speaker themselves could be removed.

Since I received Nokia e51 I’ve been browsing web pages with Opera Mini. This is a decent browser which makes reading pages easier but it can’t do all. The best case is when not only the browser cares to display the page best it can, but also the owner of the page does so, i.e. only important content is downloaded so that the page is lighter and loads faster (which is important if you are not having a free WI-FI connection).

Thus I’ve decided to adapt my blog for mobile devices. Because I’m using Wordpress engine I looked for a plugin which can do this work for me. I’ve found a couple of plugins and I desided to install WordPress Mobile Pack. Now this blog looks on a mobile devices as a sample screen shot displayed above.

Happy reading, even on a phone

P.S. Let me know if you use a different plugin. Maybe there’s something even better than WordPress Mobile Pack. Thanks in advance!

Related articles by Zemanta

• Mobilepress.co.za – Making Your Blog Go Mobile (killerstartups.com)
• Think Mobile Wordpress – Think MobilePress! (netwala.blogspot.com)
• Looking at web browsers on the Nokia 5800 (allaboutsymbian.com)
• 3 Reasons Why Mobile Browsing Doubled Last Year (jkontherun.com)
• MobilePress: Wordpress Plugin To Turn Your Blog Mobile Compatible (crenk.com)
• Plugin: Render Your WP Blog on Mobile Handsets (blogperfume.com)

For those who work with C# I’d like to recommend a book which is a kind of summary of knowledge on C# 3.0. The book is quite short (and small by the way – yet pocket reference) but it covers lots of details on C# and describes what’s new in C# 3.0. Everything in short and simple, with code snippets.

I read this book as a first step towards TS: Microsoft .NET Framework – Application Development Foundation. Basically, I’ve started wondering if passing this exam is not a good step in my .NET career and this is the entry point.

Anyway this book is not a C# bible, but it can really help as a knowledge reresher.

Recommended.