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!
bharbert
Member
20 Points
4 Posts
Unique Values in a DataSet
Jul 19, 2004 08:30 PM|LINK