|
|||
|
Data AccessThis section contains articles covering ADO.NET, SQL Server, MSDE, Access and other data access methods and technologies.
All roads lead back to Rowstate - 1/21/2005 Well, not really, but if you don't get the concept of DataRowState, you'll have little fun with ADO.NET. I've written about this several times before, but it's a very persistent problem. I had my share of problems with it at first, until one day I 'got' it. more... Data Access Patterns [Retryer] - 1/1/2005 There are many books dedicated to the subject of Software Design Patterns and the subject is becoming increasingly hard to ignore. Microsoft for instance has dedicated an entire Community dedicated to the subject of patterns and practices. I'm not going to try to hard sell the concept of Pattern based design on you. All I will say is that for a while, I had a somewhat difficult time understanding the real world applicability of using patterns but as I became more and more familiar with them - it's hard to imagine life without them. more... Controls created on one thread cannot be parented to a control on a different thread - 12/20/2004 Error: Controls created on one thread cannot be parented to a control on a different thread. How do I fill a DataGrid on a form from a thread that did not create the control? more... BackgroundWorker Class in the 2.0 Framework - 12/10/2004 Recently, I've had a little bit of time and started playing with Visual Studio .NET 2005 again. One of the features that I really like is the BackgroundWorker Class. Now, you could always create your own background thread and process whatever you felt like with it, but it got a lot easier. more... Use a DataView to Print the Contents of a Sorted Grid - 10/26/2004 How can I print the contents of a DataGrid, which has been sorted by the user? The DataView.Table returns the original, unsorted table, and does not reflect any sorting done by the user. more... Use Convert Class Instead of Casting or CType - 9/27/2004 How can I handle DBNull in both C# and VB.NET when I don't necessarily know the type of the data without looking up the type of every field in the query result? more... Use ADO.NET Transactions to Perserve Data Integrity - 9/8/2004 Preserve the integrity of your data through the use of Database Transactions in ADO.NET. It's easy and the payoff is win-win. more... ADO.NET SQL Shortcut - If Exists - 8/13/2004 Is there a faster way to determine if a record exists in a database table than using a "Select * From Table" query. Yes; use an "If Exists" Dynamic Sql or Stored Procedure to increase performance of the query. more... Playing with the SqlCeResultSet - 8/11/2004 As Sam has pointed out, there's not a whole lot out there on this guy (see nothing). I'm going to get pretty in depth with it tomorrow if the audience is interested. If not, oh well. Anyway, this is a totally different beast then what you're used to with Data Access. Why? more... A Hodge Podge of ADO.NET 2.0 - 7/14/2004 Eariler tonight I started playing with some more ADO.NET 2.0 code and just started mixing it up. It appears the ASP.NET 2.0 team has done such a good job with ASP.NET 2.0 that you don't really need to write any code for it anymore, so I can spend my time elsewhere. There are two new ADO.NET 2.0 Features that are pretty cool - although I probably won't be using the first much: more... |
|
 |
|
|