Use the REPEATER control to display the main - from the relational data sheet

public class NestedRepeater: System.Web.UI.Page {protected System.Web.UI.WebControls.Repeater parentRepeater; public void Page_Load (object sender, EventArgs e) {// Create Connection and DataAdapter string cnnString = @ "server is Authors table = (local) / NetSDK; database = pubs; Integrated Security = SSPI; "; SqlConnection cnn = new SqlConnection (cnnString); SqlDataAdapter cmd1 = new SqlDataAdapter (" select * from authors ", cnn);

// Create a populated dataset. DataSet DS = New Dataset (); cmd1.fill (DS, "Authors");

/ / Create DataAdapter SqldataAdapter CMD2 = New SqldataAdapter ("Select * from TitleAuthor"; CMD2.Fill (DS, "Titles"); cmd2.fill (DS, "Titles");

// Create the relationship between the Authors table and the Titles table. DS.RELATIONS.ADD ("MyRelation", DS.Tables ["authors"]. Column ["au_id"], ds.tables ["titles"]. Columns [ "au_id"]);

// Bind authors to the parent REPEATER PARENTREPEATER.DASOURCE = DS.TABLES ["Authors"];

cnn.Close (); cnn.Dispose ();} private void Page_Init (object sender, EventArgs e) {InitializeComponent ();} private void InitializeComponent () {this.Load = new System.EventHandler (this.Page_Load); } public nestedRepeater () {page.init = new system.eventhandler (Page_init);}}}