Contact Bill at
 

• Doing the Impossible with ADO.NET
  They said it couldn’t be done but, of course, they were wrong. Yes, you can create and manage your own server-side, fully scrollable and updatable cursors on SQL Server with ADO.NET. And in this article Bill Vaughn shows you how.
• Doing the Impossible with ADO.NET: Part 2
  The said it couldn’t be done - but they were (still) wrong. Yes, you can create pessimistic locks on rows, pages, or even entire tables with SQL Server and ADO.NET.
• Understanding Gazinta and Gazouta Parameters
  When executing queries or calling stored procedures, it’s important to know how and when to fetch the other stuff returned by SQL Server—besides the rowset.
• Sorting, Seeking, Filtering, and Finding
  With disconnected architectures, you’re supposed to manipulate your data without that expensive SQL database. Here’s how it’s done.
• Putting Stored Procedures and DBAs to the Test: Part 1
  Stored procedures form the core of many three-tiered applications. Knowing how best to write, debug and test them is an essential skill for .NET developers—assuming your DBA grants you permission to do so.
• Putting Stored Procedures - and DBAs - to the Test: Part 2
  In Part 1 of this article I pointed out that it's not just tables you have to grant privileges on, but also some stored procedures and even extended stored procedures. For example, I said that "If your developers want to step through or debug T-SQL stored procedures, you (or the DBA) will need to grant permission on the Extended Stored Procedure, sp_sdidebug" Now that the groundwork has been laid, let’s write some code to execute a typical stored procedure. I’ve written several articles on executing stored procedures so I won’t go into much detail here—and there’s lots more detail in my book if you need more depth.
• Keeping your cool when your stored procedures talk back
  Most of us execute stored procedures, but when they get in trouble, they sometimes complain, kick the seat and cry. This article discusses how to handle those complaints without having to turn the car around and return home.
• What to do when (column) size matters
  One of the features I found particularly useful in the first Visual Studio .NET Beta was the ability to automatically size a DataGrid control based on its contents using a single Boolean property setting. For some reason, this feature was dropped from the .NET Framework in V1.0 and 1.1. I expect that we’ll see it reappear someday, but until then, this article discusses how to return this functionality to your own application.
• Doing the Impossible (Again)
  There are still a lot of Visual Basic 6.0 applications out there that call middle-tier objects that return ADO classic Recordsets. While ADO.NET can read a Recordset, it can’t create one. This article shows how to use XML to create a Recordset from an existing DataTable.
• Strongly typed data revisited
  One of the ways developers can leverage the power of Visual Studio and the CLR is to create strongly typed data structures.