Drilldowns In DataGrid

In this article, Jesudas Chinnathampi illustrates how you can show an editable master detail relationship using the ASP.NET DataGrid web server control. For this, we will consider the Publisher and Titles tables that are available in the Pubs database (available in SQL Server 2000). We know that the DataSet object in ADO.NET can be used to hold multiple tables (disconnected recordsets), and we can create relationships between these tables within a single DataSet object on the fly. Once the relationships are set, you can use this DataSet to populate a DataGrid.