https://www.developerfusion.com/t/database/code/sort/popularity/ Database Sample code from Developer Fusion http://www.rssboard.org/rss-specification en-GB Sat, 21 Jan 2006 22:25:00 GMT Learn how to encrypt any section of your Web.config file on-the-fly and programatically; plain-text connection strings in your config file are no more! http://www.developerfusion.com/code/5263/encrypting-webconfig-sections-in-aspnet-20/ http://www.developerfusion.com/code/5263/encrypting-webconfig-sections-in-aspnet-20/ Sat, 21 Jan 2006 22:25:00 GMT Xavier Larrea Eliminating duplicate rows of data from an Oracle database http://www.developerfusion.com/code/1976/deleting-duplicate-rows-in-a-table/ http://www.developerfusion.com/code/1976/deleting-duplicate-rows-in-a-table/ Fri, 01 Mar 2002 09:41:00 GMT Kevin Saitta 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 Discusses some unexpected implications of using the 'On Error Resume Next' statement in Visual Basic applications. http://www.developerfusion.com/code/4325/on-error-resume-next-considered-harmful/ http://www.developerfusion.com/code/4325/on-error-resume-next-considered-harmful/ Wed, 21 Jan 2004 04:23:00 GMT Palo Mraz This sample code demonstrates how to save and retrieve pictures from a database using PHP. http://www.developerfusion.com/code/2667/storing-retrieving-pictures-from-database/ http://www.developerfusion.com/code/2667/storing-retrieving-pictures-from-database/ Fri, 05 Sep 2003 08:56:00 GMT Imthiaz Rafiq Just supply your database connection string and this code will give you a radio button list of all your SQL Server tables and will show their fields. http://www.developerfusion.com/code/3243/display-sql-server-table-data-in-a-browser/ http://www.developerfusion.com/code/3243/display-sql-server-table-data-in-a-browser/ Sat, 11 Jan 2003 09:51: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 How to create a running total column in an SQL query http://www.developerfusion.com/code/1734/running-total-in-an-sql-query/ http://www.developerfusion.com/code/1734/running-total-in-an-sql-query/ Mon, 15 Oct 2001 18:02:00 GMT James Crowley This code shows you how to create a table and it's indexes in a database at run time. http://www.developerfusion.com/code/3039/create-table-in-a-database/ http://www.developerfusion.com/code/3039/create-table-in-a-database/ Sun, 09 Mar 2003 06:58:00 GMT amoibade An example of how to get metadata - such as all the databases on the server, all of their tables, and the corresponding field information for that table. http://www.developerfusion.com/code/3945/get-metadata-on-mysql-databases/ http://www.developerfusion.com/code/3945/get-metadata-on-mysql-databases/ Wed, 13 Aug 2003 10:26:00 GMT Edward Tanguay How to evaluate string formulas in VB http://www.developerfusion.com/code/198/evaluate-string-formulas-in-vb/ http://www.developerfusion.com/code/198/evaluate-string-formulas-in-vb/ Sat, 14 Jul 2001 14:48:00 GMT ElementK Journals Demonstrates a useful debugging technique taking advantage of traces in ASP.NET. http://www.developerfusion.com/code/4649/debug-aspnet-pages-using-tracing/ http://www.developerfusion.com/code/4649/debug-aspnet-pages-using-tracing/ Fri, 07 Jan 2005 08:48:00 GMT Julian Roberts How to limit the number of records returned from a MySQL database http://www.developerfusion.com/code/1751/limit-the-number-of-rows-returned/ http://www.developerfusion.com/code/1751/limit-the-number-of-rows-returned/ Wed, 17 Oct 2001 15:52:00 GMT Alt-PHP-Faq This is some sample code that shows how to programmatically reset all AutoNumber fields in an Access Database to a correct value (whether it be 0 or the max value + 1). In addition, it contains code for Compacting and Repairing an MS Access Database. This is perfect for people who are working with a complicated Access Database and have experienced AutoNumber bugs! http://www.developerfusion.com/code/3741/access-autonumber-reset/ http://www.developerfusion.com/code/3741/access-autonumber-reset/ Sat, 07 Jun 2003 02:31:00 GMT Michael Gagne A neat way of fetching an image stored in SQL Server and resizing it before save/sending it anywhere. http://www.developerfusion.com/code/4651/resizing-images-retrieved-from-sql-server/ http://www.developerfusion.com/code/4651/resizing-images-retrieved-from-sql-server/ Sun, 09 Jan 2005 14:43:00 GMT Simon Soanes Important differences between Access, VB and SQL Server wildcard characters http://www.developerfusion.com/code/674/access-vb-and-sql-server-wildcard-characters/ http://www.developerfusion.com/code/674/access-vb-and-sql-server-wildcard-characters/ Sat, 14 Jul 2001 14:48:00 GMT James Crowley 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 How to include Text, nText and Image datatypes in a Union query http://www.developerfusion.com/code/1603/how-to-include-text-ntext-and-image-datatypes-in-a-union-query/ http://www.developerfusion.com/code/1603/how-to-include-text-ntext-and-image-datatypes-in-a-union-query/ Wed, 18 Jul 2001 17:59:00 GMT ElementK Journals This is a conceptual idea of how I start to do database programming. In this article, I had highlighted a few points that become vital to understand for any new comers to do database programming. http://www.developerfusion.com/code/1936/getting-started-with-database-programming/ http://www.developerfusion.com/code/1936/getting-started-with-database-programming/ Sun, 24 Feb 2002 11:24:00 GMT gigsv00 Describes how to post a message into MSMQ from within a SQL procedure http://www.developerfusion.com/code/2151/update-msmq-from-sql/ http://www.developerfusion.com/code/2151/update-msmq-from-sql/ Sun, 24 Mar 2002 07:40:00 GMT Bruce Johnson