http://forums.asp.net/t/640033.aspx/1?Unique+Values+in+a+DataSetMon, 19 Jul 2004 20:30:37 -0400640033640033http://forums.asp.net/p/640033/640033.aspx/1?Unique+Values+in+a+DataSet The DataSet is a Bill of Material (BOM) for an Assembly that contains all the Parts in an Assembly. The DataSet is read in from an XML file. The DataSet that has a column called "PartName". I create a TXT file of the Bill of Material from the original DataSet which is easy. Here is the problem: I need to create a "Parts Listing" TXT file. The parts listing shows only the unqiue parts in the assembly. The Bill of Material can repeat "PartName", but the Parts Listing should only show a part once. I would assume I need to specify the DataSet's "PartName" column as Unique. However I don't know a good way to read in the data from an XML file and how to handle the problem when I violate the unique column error... Any ideas? Thanks! 2004-07-19T20:30:37-04:00