John W. Colby
jcolby at ColbyConsulting.com
Mon Mar 17 13:49:00 CST 2003
And of course I can get the schema info using .net. Just have to add a
parameter to the call. The schema info is apparently quite useful if you
want to import, then write back out again. Ensures you get the same thing
in all cases or something like that.
John W. Colby
Colby Consulting
www.ColbyConsulting.com
-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Charlotte Foust
Sent: Monday, March 17, 2003 11:57 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] How bout them apples
Didn't you guys ever try persisting a recordset as XML from Access 2k
or XP? An equal no-brainer.
Charlotte Foust
-----Original Message-----
From: Jim Lawrence (AccessD) [mailto:accessd at shaw.ca]
Sent: Sunday, March 16, 2003 10:45 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] How bout them apples
John...Awesome...Jim
-----Original Message-----
From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of John W. Colby
Sent: Sunday, March 16, 2003 8:06 PM
To: AccessD
Subject: [AccessD] How bout them apples
A single line of code to write an xml code from a dataset?
DataSet11.WriteXml("c:\TestXml.xml")
>From the click event of a button dumps the data in a dataset bound to a
table in SQL Server to an XML file on the disk.
This .Net is cool stuff!
<?xml version="1.0" standalone="yes" ?>
- <dsStates xmlns="http://www.tempuri.org/DataSet1.xsd">
- <tblState>
<ST_ID>2</ST_ID>
<ST_State>Puebla</ST_State>
<Active>true</Active>
<Trash>false</Trash>
</tblState>
- <tblState>
<ST_ID>54</ST_ID>
<ST_State>Alberta</ST_State>
<ST_Abrev>AB</ST_Abrev>
<Active>true</Active>
<Trash>false</Trash>
</tblState>
- <tblState>
<ST_ID>66</ST_ID>
<ST_State>Aguascalientes</ST_State>
<ST_Abrev>AGS</ST_Abrev>
<Active>true</Active>
<Trash>false</Trash>
</tblState>
- <tblState>
<ST_ID>4</ST_ID>
<ST_State>Alaska</ST_State>
<ST_Abrev>AK</ST_Abrev>
John W. Colby
Colby Consulting
www.ColbyConsulting.com
----------------------------------------------------
Is email taking over your day? Manage your time with eMailBoss. Try it
free! http://www.eMailBoss.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
----------------------------------------------------
Is email taking over your day? Manage your time with eMailBoss.
Try it free! http://www.eMailBoss.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 2740 bytes
Desc: not available
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030317/f50bb99e/attachment-0001.bin>