Hi,
I have managed to create an xml file from the dataset in two ways - using writexml and using the xmltextwriter however both are causing me problems. I have loaded two tables into my dataset and created the primary keys and the relationships. Table 1 is a department list and table 2 is a list of staff with a department name. I want the treeview to list the departments and have subnodes for staff in each department
the writexml causes me a problem because i dont know how to make the column names appear as treenode for more than 1 field. If i do use
dataSet.Tables("dataValues").TableName = "treenode"
dataSet.Tables("Employees").TableName = "treenode"
i get an error saying treenode already used in a table name and if i dont define it here i get get
<TREENODES>
<department="Asset Management Services">
<name="Chris Wilman" />
etc
when i use xmltextwriter i get
<TREENODES>
<treenode xmlns="Asset Management Services">
<treenode xmlns="Chris Wilman" />
<treenode xmlns="Craig Brierley" />
and i need to replace xmlns with text
I have no idea how to do either of these things
Pk
"When all is said and done, there is usually more said than done." Alfred E Newman