ADO.NET Tutorials

Navigate Master/Details Tables in DataSet using DataRelation

16 June 2009
15740 Views

The ADO.NET DataSet object allows you to load multiple DataTable objects in Tables Collection. These tables may or may not have any relation between them and you can use them without worrying about their relations. Most development scenarios require you to load two related database tables in DataSet and you not only have to create relations between the tables but sometimes you may also have to display them as Master/Details hierarchy. In this tutorial I will show you how you can navigate related parent and child table rows with the help of DataRelation object.
Navigate Master/Details Tables in DataSet using DataRelation

Working with ADO.NET Disconnected Data Objects

03 June 2009
15977 Views

ADO.NET is Microsoft data access technology for those developers who are creating .NET applications to connect to different type of data sources. Be a part of .NET Framework, It is a set of classes and components that can be used by programmers to access data and data services. It provides classes to access and modify data stored in relational database systems both in connected and disconnected way. In this tutorial I will give you overview of the ADO.NET disconnected data objects such as DataSet, DataTable, DataColumn, DataRow, UniqueConstraint, ForeignKeyConstraint and DataRelation.
Working with ADO.NET Disconnected Data Objects


Enumerate SQL Server database Instances using ADO.NET

14 April 2009
6101 Views

How many times you created a .NET application in which you need to know about all of the database systems on your company’s network? May be you need to create an application for database administrator of your SQL Server database so that he can see a list of all the SQL Server databases installed in the company. In this small tutorial I will show you how you can obtain the list of all SQL Server database instances.
Enumerate SQL Server database Instances using ADO.NET

Consuming RSS Feed using XmlTextReader and DataSet

27 May 2008
7201 Views

RSS Feed is a very popular web feed format to publish frequently updated contents such as blog entries, articles, news headlines. In the following tutorial, I will show you how you can read RSS feed from its URL using XmlTextReader class in System.Xml namespace. I will also show you how you can bind and display feed contents using ASP.NET DataList control.
Consuming RSS Feed using XmlTextReader and DataSet

Using SqlConnectionStringBuilder class in C#

16 May 2008
29009 Views

Microsoft introduced a new class in ADO.NET 2.0 version which can be used to build database connection strings specific to the provider you are using in ADO.NET. Different database providers expose different properties for the connection strings. For example, SQL Server connection string properties are different than MySql or OleDb connection strings. Although, it is possible to concatenate strings to build a complete connection string but by using .NET connection string builder class you don't need to memorize the properties appropriate to specific provider.
Using SqlConnectionStringBuilder class in C#