XML Reading and Working With

[0CODE]

hey, I am using xml for a database and it works fine. I create them using microsoft acess and then export it to an xml. Now I used this first xml database for a few months, then changed a few things in it and created a new xml database a few months later (I reformated cpu, but still using acess). But this new one had problems when it couldn't read it properly im guessing. Here is a useful example of code that has problems:


dim lc As Integer = contactl.Items.Count
contactl.Items.Add(.Rows(lc)("coname").ToString)

*the error message I get is "coname does not belong to table dataroot"

---> when I use the original one, it does not have this
problem (I can see that the beggining few lines are
diff. for the xml code but I don't know if it affects
it etc.


--------------------------
((((( FIRST ONE )))))
--------------------------


<?xml version="1.0" standalone="yes" ?>
- <dataroot>
- <Main>
<firstname>534535</firstname>
<lastname>3453453453</lastname>
<coname />
<gender />
<bday>18/12/2002 12:00:00 AM</bday>
<age>0</age>
<country />
<state />
<city />
<address />
<postalcode />
<home />
<home2 />
<office />
<cell />
<pager />
<fax />
<email />
<webpage />
<firsttalk>06/09/2003 12:00:00 AM</firsttalk>
<salesbegan>06/09/2003 12:00:00 AM</salesbegan>
<salesended>06/09/2003 12:00:00 AM</salesended>
<ovsales />
<ovincome />
<perweek />
<permonth />
<customerper />
<description />
<fullname>534535 3453453453</fullname>
</Main>
</dataroot>






--------------------------
((((( 2nd ONE )))))
--------------------------


<?xml version="1.0" encoding="UTF-8" ?>
- <dataroot xmlnsd="urn:schemas-microsoft-comfficedata" xmlns:xsi="

http://www.w3.org/2000/10/XMLSchema-instance"

xsi:noNamespaceSchemaLocation="Clients.xsd">
- <Main>
<coname>mn</coname>
<owner>345</owner>
<manager>345</manager>
<office>34</office>
<cell>23</cell>
<home>3245</home>
<fax>34</fax>
<country>345</country>
<province>345</province>
<city>35</city>
<address>345</address>
<pcode>34</pcode>
<email>3</email>
<website>234</website>
<firsttalk>634</firsttalk>
<clientper>745</clientper>
<notes>346</notes>
</Main>
</dataroot>



any tips / comments / thoughts / solutions would be a really great help and I appreciate it. Thanks