Main contents

Note to self… Category Archive

Gotcha with OleDbConnection and SQL Server 2000 databases

9 August 2004

I was bug hunting today and ran across some weird behaviour with OleDbConnection. Before we go on, I’d like to point out that the code I was looking at was NOT mine (Who’d connect with an OleDbConnection, when there is a perfectly good SqlConnection?). Anyway, the thing I noticed was that when you have an [...] Read more »

Posted in Note to self... | No Comments »

Auto increment in MS Access

29 July 2004

This took me longer to find on Google than I wanted. If you want to have an auto-incrementing primary key in MS Access (sucks), then you want something like the following in the your create table statement: CREATE TABLE tablename (  id COUNTER NOT NULL CONSTRAINT constraintName_pk PRIMARY KEY,  intColumn INTEGER,  description MEMO) The primary [...] Read more »

Posted in Note to self... | 2 Comments »

Code Snippets in Visual Studio C# Express

19 July 2004

I know I said earlier that I would talk about the features in the upcoming Visual Studio 2005, but a certain something has occupied my time for the last few months. Right before I left for Brazil I downloaded some of the express editions that microsoft posted. I’ve only installed the C# edition, so far. [...] Read more »

Posted in Note to self... | 3 Comments »