Navigate Master/Details Tables in DataSet using DataRelation

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

Read Full Tutorial


Working with ADO.NET Disconnected Data Objects

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

Read Full Tutorial

Enumerate SQL Server database Instances using ADO.NET

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

Read Full Tutorial

Consuming RSS Feed using XmlTextReader and DataSet

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

Read Full Tutorial

Using SqlConnectionStringBuilder class in C#

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#

Read Full Tutorial