|
|||
|
Data AccessThis section contains articles covering ADO.NET, SQL Server, MSDE, Access and other data access methods and technologies.
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... Compacting an Access Database While Using ADO.NET - 3/22/2004 How do I compact and repair a Microsoft Access Database (.MDB) when using ADO.NET? more... Efficient ADO - Part III - 3/20/2004 In the First and Second segments of this article, I walked you through doing many tasks with Cached data that used to be in the sphere of hitting the database. This allows increased efficiency on both the client and server as well as the network. In this segment, I'm going to walk through a few more such techniques. Since every time I start writing I think of more to cover, I'm probably going to include a Part IV. more... Efficiently Using ADO.NET - Part II - 3/10/2004 In Part I of this article, I showed you a few ways that you can maximize the power of ADO.NET objects like the DataView to simplify your code, negate the need to constantly query your database and provide functionality that may be otherwise difficult to achieve. In this article, I want to build upon that base, and further explore some advanced uses of Expressions. more... Building SQL Tables at Runtime - 3/9/2004 One of the more common questions I see on the newsgroups is whether or not it's possible to issueData Definition Language [DDL] queries with ADO.NET and if so, how to do it. In this article, I'm going to show you how to do it with various scenarios. In the first situation, we'll use a Hard Coded Table Definition and build a Table in SQL Server 2000 with it. Then, we'll allow the user to specify a .sql file , we'll read in the contents, and build the table from there. Finally, we'll use .NET's Embedded Resources to load a SQL Definition and create a file from it. more... Efficiently Using ADO.NET - Part I - 3/7/2004 If you've read my other articles on fitlering data with ADO.NET 's DataView object, you know that ADO.NET gives you some really powerful filtering capabilities. If you haven't, I'd suggest you read up on Sorting or Filtering first. more... Using ADO.NET to Serialize and Deserialize ListBox and ListView Controls to XML Files - 1/14/2004 With ADO.NET, it is a simple task to Serialize (save the contents of a ListBox or ListView) to an XML file, and later DeSerialize (reload the controls) from the XML file. more... Stored Procedures - 1/12/2004 You have probably heard to old adage "If you know one programming language, you know them all." While it's certainly an oversimplification, the spirit of it is probably quite true, after all, many langauge features are similar regardless of what you are coding in. more... Your First PL/SQL Function - 1/11/2004 PL/SQL is a pretty powerful langauge that allows you to do many things. One of those things is creating functions. You can do some amazing things with them, and the complexity level is up to you. However, the intent of this article isn't to show you how hard it is to create Functions, it's to show you how easy it is. more... |
|
 |
|
|