Could you use a SHAPE statement instead to populate a DataSet object, then draw the menu's by looping through the dataset. Or if you want to take it further, output XML from the DB, or output XML from the Dataset and apply an xsl to format it for the menus...
-----Original Message----- From: Michael Gerholdt [mailto:[EMAIL PROTECTED]] Sent: Monday, January 13, 2003 3:01 PM To: dotnet Subject: new nested repeater question Hi, I have two sp queries on the same table. One returns records which have a null ParentNavID, and the second returns records which hold the unique id (ItemNavID) of one of the first recordset members in their ParentNavID field. I'm using a nested repeater to create menus in this way. However, when I attempt to create the relationship with the following code: ds.Relations.Add("myrelation", _ ds.Tables("MenuNav").Columns("ItemNavID"), _ ds.Tables("MenuNav").Columns("ParentNavID")) I get the error: System.ArgumentException: These columns don't currently have unique values. The ItemNavIDs are certainly unique, but the ParentNavID are not supposed to be. Help?! Thanks, Mike --- You are currently subscribed to dotnet as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/ --- You are currently subscribed to dotnet as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] --------- Administrated by 15 Seconds : http://www.15Seconds.com List Archives/Search : http://local.15Seconds.com/search Subscription Information : http://www.15seconds.com/listserv.htm Advertising Information: http://www.internet.com/mediakit/
