-
In my current project, we have a tables where the primary key consists of two values. Based on the result of a query, we needed to delete a few rows from that table. The query returned the two key values and we needed to join that information in the delete statement. It's not rocket science, but...
-
I was running into this just now and found a quick way to solve it, so I just posted it for future reference. I have an ASP.Net web application project in .Net 2.0 which was migrated from .Net 1.1 some time ago. I noticed that a few aspx pages did not have a designer.cs file. All controls on those pages...
-
Introduction I have been browsing the web for a good and simple class to handle delimited file imports. My current assignment has an import option that needs to deal with that. However, the current implementation (using StreamReader) is not good enough. It doesn't handle all the exceptions you encounter...
-
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. However, sometimes our users complain that they...
-
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 status. That update procedure first checked...
-
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 application. I extracted the method and removed...
-
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 server. Below are a few things you may want to check...
-
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 the System.IO.Compression.DeflateStream class...
-
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 is 'PARSE'. An internal error has occurred...
-
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 'grady' operator. Now what in heavens...
-
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 tool. I know a lot of you have trouble setting...
-
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 new stuff. The class library can be used to handle...
-
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 to the calendar. The begin and end date for a calendar...
-
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 status of Sandcastle, because I feel the tool...
-
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. I used information from that article to create a...