Browse by Tags
All Tags »
Code Samples (
RSS)
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...
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...
This post explains a little about using OleDb Jet Engine for import of delimited files, such as comma (CSV) and tab delimited files. A demo application can be downloaded to show how it works....
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
More Posts
Next page »