|
|||
|
Data AccessThis section contains articles covering ADO.NET, SQL Server, MSDE, Access and other data access methods and technologies.
A cool new feature of the DataAdapter in ADO.NET 2.0 - 7/12/2004 Just came across something that was totally by accident - the SqlDataAdapter's .AcceptChangesDuringUpdate method. Back in the day, as in now, when you call the Update method, the AcceptChanges method of the DataSet / DataRow class(es) is called as each row is updated. more... Binary Serialization of a DataSet - ADO.NET 2.0 - 7/12/2004 There's just so much cool new stuff in the new framework to really go through it all. I'm still just fumbling around the ADO.NET libraries and playing with some of the goodies. One cool feature is the Binary Serialization support in addition to XML Serialization. One caution though, it's not exactly as intuitive as you might think. When you hear that there's binary serialization, you may assume that it's simply a matter of calling a WriteBinary or ReadBinary method. more... Using the SqlBulkInsert in ADO.NET 2.0 - 7/10/2004 ADO.NET 2.0 is packed full of new goodies like the TransactionScope and MARS. Another REALLY cool feature is the SqlBulkCopy feature. If you want to transfer data, it's so fast it's scarry. more... Getting feedback from your data objects - 6/15/2004 In most applications, you'll want to provide your users with feedback of one sort or another whenever a process runs. Sometimes this takes the form of changing the screen's cursor or incrementing a ProgressBar or whatever you think your users will like. more... Convert Dynamic SQL to Use SQLCommand Parameters Automatically - 6/12/2004 Now you can convert your antiquated and dangerous Dynamic SQL to use Named Parameters automatically. Stop Injection Attacks and SQL failures from the use of aposthrophes in string variables. more... Dynamic SQL Needs to die - 5/30/2004 For two years now, I've espoused the point that there's NO, as in 0, reason to use concatenated dynamic SQL any more. I'm by no means the only one and if you asked anyone who really understands the subject, there's no doubt there's unanimity on this subject. Yet just about every day, in one newsgroup/forum or another, there's someone who posts code with Dynamic SQL/Concatenated SQL that's the source of their trouble. And there's even more people who have code that's next to impossible to debug b/c they are using it. more... Walking through a DataView - 5/1/2004 One of my favorite objects in ADO.NET is DataView Class. Basically, ADO.NET uses a Database metaphor where the DataSet object corresponds to a "database", the DataTable class corresponds to a table in that database and the dataview corresponds to a "view" object. more... Efficiently Using ADO.NET - IV - 4/29/2004 There are some very very common mistakes that newbie and midlevel ADO.NET programmers make. They happen every day and they are caused by a fundamental misunderstanding of how updates work. Hopefully this will be no more more... Performance Issues in ADO.NET DataTable Usage. - 4/6/2004 Use Enum to Access DataColumns in a DataRow for Performance. Integer indexes are faster than String indexes for accessing an Item in a DataRow. more... DataSet.Merge and Transferring Data - 3/31/2004 Just about every week on the newsgroups I see a post that looks something like this: "Please help. I have a table and I want to transfer the data into another table. I have my dataadapters configured, I merge the to datasets into one, then call update but nothing happens" more... |
|
 |
|
|