Premium Sponsor
Premium Sponsor


Advanced Search
Popular Articles
Popular Authors
SubMain - Developer Tools
 »  Home  »  Data Programming  »  ADO.NET

» ADO.NET 3.5, LINQ, and the Entity Framework
by Larry Blake | Published 08/14/2009 |  | Rating:

Murach's ADO.NET 3.5, LINQ, and the Entity Framework by Anne Boehm, comes in both Visual Basic and C# 2008 versions.  Larry Blake reviews it.

[read article...]
» ADO.NET for Beginners Part Three
by David Jeavons | Published 01/12/2007 |  | 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...]
» Create generic database code using ADO.NET 2.0 Provider Factories
by David Jeavons | Published 10/17/2006 |  | 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...]
» ADO.NET for Beginners Part Two
by David Jeavons | Published 07/18/2006 |  | 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
by David Jeavons | Published 07/12/2006 |  | 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...]
» Book Review: Murach's C# 2005
by Scott Waletzko | Published 06/15/2006 |  | Rating:
A review of Murach's C# 2005 tutorial and reference book, written by Scott Waletzko (Skystone Software). [read article...]
» Advanced Caching Techniques in ASP.NET 2.0
by Sandeep Joshi | Published 05/05/2006 |  | Rating:

Web application development is one of the key business process areas in software industry. A web application has a long life only if the user visits the application with interest.

To keep the user interest in your web site, two factors are important. One is easy navigation and the other is fast data retrieval. The most dramatic way to improve the performance of a database driven Web application is through caching.

This article delves into the caching mechanism, available with ASP.NET 2.0. The author takes a walk through ASP.NET 1.1 caching practices as well as a comparison with ASP.NET 2.0 changes.

[read article...]
» Business Mate: Using the Generic Database Class
by Charles Profitt | Published 02/10/2005 |  | Rating:

In the last segment I showed you how to make a generic database class which allows you to create a DataSet from any other part of your code. I also promised to eventually develop an application that would be useable. This is the next step in that process.

[read article...]
» Business Mate: Generic Database Class
by Charles Profitt | Published 02/08/2005 |  | Rating:
The first item I want to cover is the generic database class. Beginners books show you how to make a DataConnection, DataAdapter and DataSet using the IDE.   Although that does work, I find it a poor way to do things. I prefer to understand a little more and excercise a little more control. [read article...]
» WebServices and passing an ADO.NET DataSet
by Jeff Laughlin | Published 03/31/2002 |  | Rating:
An overview of Datasets and WebServices using .NET. The article shows how to use webservices to connect a client application and a server together. It demonstrates sending datasets from the web server to the client application and also shows how to send updates from the client to the server. [read article...]
» Getting Started with ADO.NET
by Gurneet Singh | Published 02/06/2002 |  | Rating:
Introductory article in a series of articles on ADO.NET by Gurneet Singh. Covers the essentials of ADO.NET [read article...]