March 2005 - John Papa [MVP C#]

John Papa [MVP C#]

Sponsors

The Lounge

Wicked Cool Jobs

News

Advertisement

  • Don't forget to Close that ADO.NET Connection

    Here's a quick tip in response to some questions I recently have been asked by several readers & bloggers: When using the Command.ExecuteReader method to get a DataReader, pass it the System.Data.CommandBehavior.CloseConnection argument. This argument closes the Connection when the DataReader is closed...
    Filed under:
  • ADO.NET 2's DataTable.Merge

    OK, so its not ground breaking, earth shattering nor will it solve world hunger ... but I am pretty stoked over the addition of the Merge method to the DataTable object in ADO.NET 2. It has always been an annoyance of mine that when I want to merge a DataTable into another one that I have to have a DataSet...
    Filed under:
  • Reflector is Cool!

    I ran into a situation today where I wanted to know why ADO.NET's DataSet.Merge method worked the way it did. Then it occurred to me that I could use reflection to find out. Using the Reflector software found on Lutz Roeder's site I examined the DataSet.Merge method and got my answers. I know this software...
  • Sharing Mistakes

    With VB 6 and ADO 2.x I can't tell you how many times I wrote the following type of code and only realized what I had done after I had pressed F5: The Infamous Infinite Loop Blunder '--- Using VB 6 and ADO 2.x oRs.Open Do While Not oRs.EOF Debug.Print oRs(0) Loop Usually the moment after I ran this code...
    Filed under:
  • Heading to Boston

    Just confirmed that I'll be at VSLive in Boston this June. If you plan on attending VSLive, drop by. I'll be presenting 2 topics: Get Ready for ADO.NET 2 (5:45 pm to 6:45 pm, Wednesday, June 29, 2005) Data access using ADO.NET is at the core of most .NET enterprise applications. While ADO.NET 1.x is...
    Filed under: ,
  • Finding NUnit

    Microsoft's Enterprise Library (Ent Lib) was developed using the oft spoken of Test Driven Development methodology (TDD). But of course if you are new to TDD or are aware of it but have not used it yet, you'll want to download and install nUnit to try it out. You can find NUnit here http://www.nunit...
    Filed under:
  • There's Only One First Time

    Well, I finally did it. Today I joined the ranks of bloggers everywhere. I am grateful that the crew at codebetter.com was gracious enough to accept me into their community. Thanks guys! I'll be posting code samples, random thoughts, links, research and some personal musings in my blog ... that is, once...
Devlicio.us