August 2010 – Knowledgebase

How to mix generic classes in a generic list in C#

31 August, 2010 Roel van Lisdonk 3 Comments 1 category

If you create a class like Setting<T>, you might think you can create a generic list, like: List<Setting<T>> List = new List<Setting<T>>(); ,but this is not possible in .Net 4.0. If you want objects of

Mouse pointer disappears, when over textboxes or texteditor in VMWare

27 August, 2010 Roel van Lisdonk 36 Comments 1 category

When I use a Windows 7 x64 computer and start a Remote Desktop session to a machine running Windows 7 x64 with VMWare 7. De mouse pointer disappears in the VMWare guest running Windows XP,

SSIS error: Column "…" cannot be found or is not specified for query (13865)

26 August, 2010 Roel van Lisdonk 0 Comments 1 category

When I refreshed a SSIS package OLE DB Source, I got the error: column "test" cannot be found or is not specified for query (13865). This was caused by the fact, that the query contained

Change recovery model for all SQL server database to Simple, truncate and shrink log files with T-SQL

26 August, 2010 Roel van Lisdonk 5 Comments 1 category

When you have many databases on a database development SQL server and these databases are re-creatable, you can save space by setting the recovery model for all databases to Simple, truncate and shrink the log

Changing the proofing language in OneNote 2010

25 August, 2010 Roel van Lisdonk 4 Comments 1 category

Install the proofing tools for your language (English, French, Spanish are installed by default) for example Dutch. Then if you want to change the proofing language of a piece of text in OneNote 2010. Select

How to generate a table of contents for an OneNote 2010 exported to Word 2010

25 August, 2010 Roel van Lisdonk 0 Comments 1 category

If you create all your software documentation in OneNote 2010 and want to export it to Word 2010, for a customer. You will miss a table of contents. You can automatically generate this table of

New features in ASP .NET 4.0 that I use

25 August, 2010 Roel van Lisdonk 0 Comments 1 category

After doing some projects for customers with ASP .NET 4.0, what are the new features that I used in the real world? SQL cache invalidation: this means that when the result set from SQL Server

How to determine the week number of a date in C#

24 August, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to get the week number of a date in C#, use the following function: private int GetWeekNumber(DateTime date) { return CultureInfo.CurrentCulture.Calendar.GetWeekOfYear(date, CalendarWeekRule.FirstFourDayWeek, DayOfWeek.Monday); }

Close sessions (connection) to a Microsoft SQL Server instance, from other users with TSQL

23 August, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to close all connections to a database, you can use the following TSQL code: USE MyDatabase GO ALTER DATABASE MyDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE GO — Set some options or

Copy and Paste – latitude and longitude values from Google Maps

13 August, 2010 Roel van Lisdonk 0 Comments 1 category

If you want to copy the latitude and longitude values from Google Maps, you can use the little LatLng Marker application in Google Maps. 1. Go to http://maps.google.com 2. Click on “New!” 3. Enable LatLng

Month: August 2010