Premium Sponsor
Premium Sponsor


Advanced Search
Popular Articles
Popular Authors
SubMain - Developer Tools
 »  Home  »  Authors  »  David Jeavons
David Jeavons
I have been programming database applications for almost 12 years starting out with VB3 and using every major version since then. I currently work for a retailer analysis company writing ASP.NET code for our ever evolving web site. I also enjoy helping other programmers with Visual Basic and .NET and am a moderator at vbCity.
Articles by this Author
» Windows Developer Power Tools
Published 08/13/2007 | Book Reviews | Rating:

With the wealth of tools available to software developers it can sometimes be quite a mission to find the right tool for the job at hand. Of course, the publishers of such tools will always claim that their tool is the best but this is a somewhat biased opinion. Enter "Windows Developer Power Tools".

[read article...]
» ADO.NET for Beginners Part Three
Published 01/12/2007 | ADO.NET | Rating:

The final part of this series builds on the lessons learned in the first two parts.   It will show you how to achieve the same functionality using an SQL Server database. The code provided will work for both SQL Server 2000 and 2005 and will demonstrate the use of stored procedures to retrieve and modify data in the Address Book database.

[read article...]
» An introduction to SQL Server Management Objects
Published 01/02/2007 | SQL Server | Rating:


SQL Server Management Objects (SMO) is a collection of objects that allow you to work with SQL Server 2005 databases in a managed environment. Previous to SQL Server 2005 you could use SQL Server Distributed Management Objects (DMO) to work with SQL Server 6.0, 6.5, 7 and 2000 (including MSDE) servers. For the most part, the objects provided with SMO will also work with SQL Server 2000, only those features specific to SQL Server 2005 will not work against a 2000 server.

This article aims to introduce a few of the basic operations that can be performed using SMO such as connecting to an SQL Server, managing databases, tables and stored procedures and performing backup and restore operations against an SQL Server.

[read article...]
» Create generic database code using ADO.NET 2.0 Provider Factories
Published 10/17/2006 | ADO.NET | Rating:

ADO.NET 2.0 introduces many new features and enhancements over previous versions of ADO.NET, but one new feature that has caught my eye recently is the new DBProviderFactory class which allows you to write generic database code without too much difficulty.

In this article, I will demonstrate a simple application that can communicate with both the Northwind Microsoft Access database and the Northwind SQL Server database without changing a single line of code.  OK, that may be a bit far fetched, but in all honesty, the only piece of information you would need to realistically change would be in the configuration file of your application to state which database your application is to use.

[read article...]
» ASP.NET 2.0 Instant Results
Published 10/03/2006 | Book Reviews | Rating:

  ASP.NET 2.0 Instant Results from Wrox presents you with 12 projects that demonstrate different areas of the ASP.NET 2.0 framework. 

   David Jeavons reviews this book.

[read article...]
» ASP.NET 2.0 Website Programming
Published 08/02/2006 | Book Reviews ASP.NET | Rating:

If you want to get up to speed with the majority of the new features offered by ASP.NET 2.0 then this is definitely one of the books that should be sitting on your bookshelf.

This book is aimed at those developers who already have a working knowledge of ASP.NET 1.x but does not require the developer to have knowledge of ASP.NET 2.0. The main goal of the book is to introduce the new features of ASP.NET 2.0, but unlike a standard reference book that will simply discuss each new control and all of its properties and methods the author has taken a different approach and has instead decided to introduce these new controls by building a fully functional website for a fictitious Pub. The website is called "TheBeerHouse" and incorporates such features as Newsletters, Opinion Polls, Forums and even an E-Commerce section among many other cool features. The website for this book can be viewed here.

The full title of this book is "ASP.NET 2.0 Website Programming, Problem - Design - Solution" and each chapter is laid out in three parts. The first part outlines the problem that will be overcome in the chapter, the second part discusses the design that will be implemented to overcome the problem and the third part implements the code discussed in the design section. I found that this format works really well, especially if you are relatively new to website programming as the author takes you through every detail that he himself faced when designing the website.   So, rather than simply saying which design he will implement, he discusses all of the possible designs that he may have implemented and goes through the pros and cons of each one before then detailing the reasons for choosing a particular design. This actually gives you a good understanding of the different options that you have available to you for various problems and the reasons why you may choose one over the other based on the scenario you face at the time.

[read article...]
» ADO.NET for Beginners Part Two
Published 07/18/2006 | .NET Newbie ADO.NET | Rating:

Part two of this series will look at managing your data by showing you how to update, add and delete records from the Contacts table. In this section we will look at the OleDbCommand object which we will utilise quite a bit when it comes to running "Action" queries against the database.

We will also look at how we can filter the data using the DataView object.

[read article...]
» ADO.NET for Beginners Part One
Published 07/12/2006 | .NET Newbie ADO.NET | Rating:

This series of articles aims to introduce you to the use of ADO.NET. However, unlike other tutorials, I will concentrate on showing you how to communicate with your database programmatically (i.e. no wizards). This article will make use of an Address Book program to take you through the various aspects of database programming and who knows, by the end of it, you may decide to make use of the program to store all of those hundreds of contacts that you have.

Part one will look at the basic outline of the user interface and will include the necessary code to connect to the database and retrieve all of your contacts for displaying on the form.

Part two will go further and show you how to filter the data and modify the data including saving new contact information and deleting existing contact information.

Part one and two will make use of an Access database. However, Part three will use an SQL Server database and show you how to use Stored Procedures to access and modify the data. The user interface and functionality will remain the same, only the database used will change.

[read article...]
» SQL Delta : Product Review
Published 03/15/2006 | Product Showcase | Rating:

SQL Delta is a SQL Server database comparison tool that allows you to analyse databases on the same server or on two different servers.

David Jeavons put it through its paces to assess its usefulness and usability.

[read article...]