https://www.developerfusion.com/t/ado.net/code/sort/popularity/ ADO.NET Sample code from Developer Fusion http://www.rssboard.org/rss-specification en-GB Sat, 25 Feb 2006 08:59:00 GMT Since a connection cannot be used until a DataReader has been closed, it is quite often necessary to read the results of a DataReader into an array, then close the DataReader, then you can process the data in the array while you use the connection for something else. This shows you how. http://www.developerfusion.com/code/4390/placing-results-from-datareader-into-an-array/ http://www.developerfusion.com/code/4390/placing-results-from-datareader-into-an-array/ Wed, 04 Feb 2004 11:32:00 GMT Edward Tanguay Demonstrates how to connect to a MySQL database with C#. http://www.developerfusion.com/code/4596/how-to-access-a-mysql-database-with-net/ http://www.developerfusion.com/code/4596/how-to-access-a-mysql-database-with-net/ Thu, 01 Apr 2004 14:47:00 GMT Edward Tanguay This code shows you how to delete records with an SQL statement and get the number of records deleted returned back as an integer. http://www.developerfusion.com/code/4391/how-to-delete-records-with-sqlcommand/ http://www.developerfusion.com/code/4391/how-to-delete-records-with-sqlcommand/ Wed, 04 Feb 2004 11:36:00 GMT Edward Tanguay You can save code by piling SQL statements into one SqlCommand and then getting a DataReader with multiple result sets. http://www.developerfusion.com/code/4638/how-to-run-through-multiple-datareader-results/ http://www.developerfusion.com/code/4638/how-to-run-through-multiple-datareader-results/ Fri, 17 Dec 2004 15:16:00 GMT Edward Tanguay One of the more significant improvement in .NET 2.0 is the transactions area. Now with a single line it becomes extremely easy to support transactional code blocks using the concept of “ambient” transaction thanks to TransactionScope in the System.Transactions namespace. http://www.developerfusion.com/code/5282/transactions-made-easy-with-net-20/ http://www.developerfusion.com/code/5282/transactions-made-easy-with-net-20/ Wed, 25 Jan 2006 01:18:00 GMT Xavier Larrea This class includes some useful methods for working with Misrosoft SQL Server in .NET simply and quickly. http://www.developerfusion.com/code/5445/sql-data-provider-vbnet-class/ http://www.developerfusion.com/code/5445/sql-data-provider-vbnet-class/ Sat, 25 Feb 2006 08:59:00 GMT A simple helper class to make generating an RSS feed a piece of cake - its the one we use on Developer Fusion too! http://www.developerfusion.com/code/4597/rss-feed-helper-class/ http://www.developerfusion.com/code/4597/rss-feed-helper-class/ Fri, 02 Apr 2004 05:44:00 GMT James Crowley ADO.NET 2 has new classes that makes it quite easy to write data-programs independent of the database engine. Learn how here. http://www.developerfusion.com/code/5264/database-independent-adonet-20/ http://www.developerfusion.com/code/5264/database-independent-adonet-20/ Sat, 21 Jan 2006 22:31:00 GMT Xavier Larrea How to create PDF files from ASP.NET pages with Crystal Reports without using Visual Studio.NET http://www.developerfusion.com/code/4266/how-to-create-pdf-files-from-aspnet-pages/ http://www.developerfusion.com/code/4266/how-to-create-pdf-files-from-aspnet-pages/ Tue, 06 Jan 2004 06:44:00 GMT Edward Tanguay Learn how to use the little-known Http Handler functionality of ASP.NET to serve images from a database. http://www.developerfusion.com/code/5223/using-ashx-files-to-retrieve-db-images/ http://www.developerfusion.com/code/5223/using-ashx-files-to-retrieve-db-images/ Sun, 15 Jan 2006 12:37:00 GMT Harry Pierson