Learn how ADO.NET not only supports relational data through the data provider, DataSet, and Adapter architecture, but also adds support for all types of nonrelational data through its integration with XML.

What is ADO.NET? It's the successor to the Active Data Object technology used in classic ASP. What is ASP.NET? It's the successor to Active Server Pages, Microsoft's popular architecture for writing server-side Web applications.

ADO .NET is a part of the .NET Framework and it is used to handle data access. With ADO .NET you can work with databases.

In ADO.NET, you can use the DataView.RowFilter property and the DataTable.Select method to filter a subset of records. However, the expressions that you can use have limitations. This article demonstrates three techniques to work around the limitations of the filter expressions.

But studying ADO.NET in isolation isn't enough. You need to understand not only the ADO.NET object model, but how to use that object model from Web Forms (ASP.NET) and Windows Forms applications, in Visual Basic .NET and Visual Studio .NET. In this article, you'll learn the basics of ADO.NET in the context of Web Forms and Windows Forms data binding, and understand how to do data binding using the wizards and designers in VS and from scratch.

This step-by-step article describes how to use the Microsoft SQL Server READTEXT and UPDATETEXT statements to read and write data from BLOB (LongVarBinary) columns in a database table.

Ljubomir walks you through how to create a connection using the ODBC .NET Data Provider.

This is the second article in a series covering the subject of Concurrency in ADO .NET. Concurrency is the method by which many users are able access and change the same data simultaneously without being concerned that they are overwriting each others work.

In my last article I reviewed the ADO.NET object model as it is presented in the .NET framework Beta2. To put this information to practical use, this article will provide a walkthrough of how to use Microsoft's newest set of developer tools, found in Visual Studio.NET to create a working Web Application that accesses an SQL database.

This article reviews the ADO.NET object model found in Microsoft’s .NET Framework Beta2. The information presented here will be useful both to programmers who worked with Beta1 and also, to those just starting with the framework.

This article is my own approach on how a multi-tier application could look like in C# and ADO.NET. The program has a GUI (Graphical User Interface), BO (Business Object) and DO (Data Object). Multi-tier is in my vision a program where the GUI doesn't have logic (no code that makes decisions), the DO only reads and save data to the database and all the rest is done by the BO. That's what I tried to accomplish with this code.

In this article we will discuss a number of ways to retrieve, show, and update data with ASP.NET forms using ADO.NET. Also, we will have a clear idea about the most common server controls in ASP.NET. In particular, with this article we will cover ASP.NET server controls, ADO.NET DataSource, and creating Templated DataBound Controls, ASP.NET forms, using data with controls.

The is the second course in a three part series that provides the learner with instruction on using ADO.NET to access data, on separating code from content, and on using the ASP.NET trace feature. The course will cover using ADO.NET to access data from various data sources and allows the learner to practice displaying and customizing data display.

This series of articles includes the core information a developer needs to start to get the most out of the .NET Framework and Visual Studio .NET, including tips and tricks on the new data access system (ADO.NET) and Web application system (ASP.NET). The articles focus particularly on the Visual Basic developer, but apply across all languages.

The .NET Framework includes a new data access technology named ADO.NET, an improvement to ADO. However, the classes that make up ADO.NET are different from the ADO objects that you might be familiar with. Some changes must be made to existing ADO applications to convert them to ADO.NET.

In this chapter you will learn how to open a database connection and perform common database operations such as inserting, updating, and deleting database records. How to use a DataReader to represent records retrieved from a database table.

A freeware ADO.Net data provider for for use in your DotNet applications. Free download and free to use in both commercial and non-commercial software.

SevenObjects today released a new freeware ADO.Net data provider. Full support for DataReaders, Connections and parameters.

Learn how ADO.NET not only supports relational data through the data provider, DataSet, and Adapter architecture, but also adds support for all types of nonrelational data through its integration with XML.