[AccessD] How bout them apples

John

Charlotte has a great demo database for disconencted stuff. You should 
download it and have a look. Or better yet its on the book CD.

Martin


Quoting "John W. Colby" <jcolby at ColbyConsulting.com>:

> 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
>