No replies to this topic

[hoser2001]

Ok heres the problem. My coworker Robb has an XML file which serves as the configuration settings for our application. Changes to these settings can be made using a GUI, and the info is stored in a ms sql database. When the client contacts the server to find out if it needs to update the configuration settings(by checking dates) I need to be able to generate a dataset from the database that when serialized, looks exactly like Robbs XML file.

Do solve this problem I took his XML file and turned it into a dataset, then formed my queries to replicate it precisely. I used nested relation objects to form the parent child relationships and bound both datasets to two datagrids. WHen viewed through the datagrid the results are the same, however my xml dataset that gets sent back does not look like what it is suppose to when turned into XML.

Is there a better way to do what I'm trying to do?