ADO.NET Tutorials

ADO.NET

Navigate Master/Details Tables in DataSet using DataRelation

Posted by Waqas Anwar on 16 Jun 2009 - Views Count: 7666

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.

ADO.NET

Working with ADO.NET Disconnected Data Objects

Posted by Waqas Anwar on 03 Jun 2009 - Views Count: 6979

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.

ADO.NET

Enumerate SQL Server database Instances using ADO.NET

Posted by Waqas Anwar on 14 Apr 2009 - Views Count: 3641

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.

ADO.NET

Consuming RSS Feed using XmlTextReader and DataSet

Posted by Waqas Anwar on 27 May 2008 - Views Count: 4340

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.

ADO.NET

Using SqlConnectionStringBuilder class in C#

Posted by Waqas Anwar on 16 May 2008 - Views Count: 13260

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.