Jan Schreuder on .Net

.Net code samples, experiences, observations

View my professional profile on LinkedIn

Recent Posts

Tags

News

  • Inappropriate comments will be deleted at my discretion.

    The information and code samples in this weblog is provided "AS IS" without warranty of any kind, either expressed or implied, including but not limited to the merchantability and/or fitness for a particular purpose.

Community

Email Notifications

Tool suppliers

Tools

General

Microsoft

Favorite blogs

Archives

Browse by Tags

All Tags » Code Samples (RSS)
Keep track of data changes using a SQL trigger
In my current project, we calculate the status of tasks that a user needs to do and store the status in a table. This happens on a daily basis. Once every week, we calculate which items are overdue and inform the user by email to take appropriate action...
How to: Quickly check if data exists in your SQL table
I was confronted with a slow performing stored procedure in SQL server this week. The procedure was to retrieve one row from a table. But before that row could be retrieved, an update procedure was called to make sure all rows in that table had the correct...
How to: Check if the specified URL really exists
I think a lot of people need to do this, and we do in our project. We created a method that will check if URLs specified in our database (a couple of hundred) actually exist. Our support team uses the result of that check to update incorrect URLs in our...
Crystal Reports for Visual Studio 2005 deployment trouble
I just spent 4 hours of figuring out why the reports we developed using Crystal Reports would not show the graphs after being deployed to our production server. We checked everything from access rights to proper installation of Crystal reports on the...
.Net Zip library
The MSDN blogs are a really great source for all sorts of information. I browse the main blog page regularly, just to get a feeling of what is happening on the Microsoft side of things. This morning I found a link to a Codeplex project which encapsulates...
Another "What the F**K" moment
I tried compiling my application just now and got this error message from the compiler: Preparing resources... Updating references... Performing main compilation... error CS0583: Internal Compiler Error (0xc0000005 at address 77FCD43E): likely culprit...
What the F**K is the 'Grady' operator
The web application I'm working on logs errors in a log file using Log4Net. Nothing new, loads of applications do that. But I was surprised when I found the following error message: System.Data.SyntaxErrorException: Syntax error: Missing operand after...
How to: Change settings in CopySourceAsHtml for use with Community Server
I've been using CopySourceAsHTML for some time now to add source code to my blog posts. Until recently, you could find it on GotDotNet.Com. But that site has now shut-down. Fortunately, the author sent me the new link for a download of this excellent...
Crystal Reports helper class updated.
In this weblog, I've regularly posted examples of stuff I created to help me use Crystal Reports in .Net applications. To make life easier I created a small class library which contains the code from all the posts I've done sofar, as well as some...
How to: Calculate the time difference between the internet client and your ASP.Net application
At my current project we use aspNetEmail for sending emails. One of our applications allow the users to register for a training course. We use the component to send invitations for Outlook and Exchange clients which automatically add the training course...
How to: Generate source documentation using Sandcastle
I've blogged about Sandcastle a few times already (see these links ) in the past year. Sandcastle is the Microsoft solution for generating Help files using the XMl documentation tags in your .Net code. I've decided I needed to post an update on the current...
Useful T-SQL Date functions
I was looking for a quick way to calculate the last day of the month in T-SQL and bumped into an article written by Gregory A. Larsen on DatabaseJournal.com . The article describes a number of T-SQL methods to calculate different date and time values...
How to: Code Service Dependencies
On my current assignment we develop and maintain a number of Windows services. Some of these service depend on others. The problem we faced when we needed to deploy new versions, is that services did not start in the correct order. Some services depend...
How to: Change casing in Text to TitleCase
At Tech-Ed 2006 I attended a session about hidden treasures in .Net. One of the treasures mentioned there was the ToTitleCase() method. This method changes the case of the first character of each word in a text to Upper case: System.Threading.Thread.CurrentThread...
Centralizing AssemblyInfo settings, or simplify versioning of solutions
I'm working on a solution in Visual Studio 2003 at the moment, which contains about 15 assemblies. All these assemblies have a AssemblyInfo.cs file which contains more or less the same information. In general, when you look at larger solutions, you will...
More Posts Next page »