I have been trying various options of using xmdatasource for populating a gridview. What I want to do is use an sql server table converted to xml. The only way I can do this in a way that can be automated is by opening an Access project and exporting the
file to xml. The only problem is, the file won't work with any of the data controls, only the menu control and treeview which is not what I am really after.
A sample of the file output from Access shows that it does'nt have any quotes:
<dataroot>
<authors>
<au_id>172-32-1176</au_id>
<au_lname>White</au_lname>
<au_fname>Johnson</au_fname>
<phone>408 496-7223</phone>
<address>10932 Bigge Rd.</address>
<city>Menlo Park</city>
<state>CA</state>
<zip>94025</zip>
<contract>1</contract>
</authors>
</dataroot>
Is there any way of getting Access to export the file so it will work with data controls?
What I want to be able to do is load a gridview using one field as a hyperlink to a value stored in another field which provides the link. Has anyone done this?
BobC
Member
200 Points
43 Posts
Using XML as datasource from Access 2003
Sep 27, 2006 10:48 AM|LINK
Hi
I have been trying various options of using xmdatasource for populating a gridview. What I want to do is use an sql server table converted to xml. The only way I can do this in a way that can be automated is by opening an Access project and exporting the file to xml. The only problem is, the file won't work with any of the data controls, only the menu control and treeview which is not what I am really after.
A sample of the file output from Access shows that it does'nt have any quotes:
<dataroot>
<authors>
<au_id>172-32-1176</au_id>
<au_lname>White</au_lname>
<au_fname>Johnson</au_fname>
<phone>408 496-7223</phone>
<address>10932 Bigge Rd.</address>
<city>Menlo Park</city>
<state>CA</state>
<zip>94025</zip>
<contract>1</contract>
</authors>
</dataroot>
Is there any way of getting Access to export the file so it will work with data controls?
What I want to be able to do is load a gridview using one field as a hyperlink to a value stored in another field which provides the link. Has anyone done this?
Thanks
Bob