Vista - Extracting schema..

The DataTable xml written out, produces the following xml. can anyone
show me how to extract that schema and put it in external file? the
reason for this, is that I want to apply that structure to multiple
different xml files and don't want to change the structure in each
file. thanks. I guess it would involve to putting the content from
<xs:schema to </xs:schema> into xsd file and referencing it somehow?
don't know how to do that.

<NewDataSet>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/
XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
xmlns:msprop="urn:schemas-microsoft-com:xml-msprop">
<xs:element name="NewDataSet" msdata:IsDataSet="true"
msdata:MainDataTable="wg_Profile" msdata:UseCurrentLocale="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="wg_Profile" msprop:Name="Profile"
msprop:PK="MemberID">
<xs:complexType>
<xs:sequence>
<xs:element name="DbName" type="xs:string"
minOccurs="0" />
<xs:element name="Name" type="xs:string"
minOccurs="0" />
<xs:element name="Type" type="xs:string"
minOccurs="0" />
<xs:element name="SubType" type="xs:string"
minOccurs="0" />
<xs:element name="Pos" type="xs:int" minOccurs="0" />
<xs:element name="Length" type="xs:int" default="0"
minOccurs="0" />
<xs:element name="Options" type="xs:string"
minOccurs="0" />
<xs:element name="OptionsDirection" type="xs:string"
minOccurs="0" />
<xs:element name="InputType" type="xs:string"
minOccurs="0" />
<xs:element name="Display" type="xs:boolean"
minOccurs="0" />
<xs:element name="Default" type="xs:string"
minOccurs="0" />
<xs:element name="Required" type="xs:boolean"
minOccurs="0" />
<xs:element name="RequiredError" type="xs:boolean"
minOccurs="0" />
<xs:element name="InvalidDataError" type="xs:string"
minOccurs="0" />
<xs:element name="Group" type="xs:string"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<wg_Profile>
<DbName>MemberID</DbName>
</wg_Profile>
<wg_Profile>
<DbName>LastName</DbName>
</wg_Profile>
<wg_Profile>
<DbName>FirstName</DbName>
</wg_Profile>
<wg_Profile>
<DbName>ProfileName</DbName>
</wg_Profile>
<wg_Profile>
<DbName>Birthday</DbName>
<Name>Birthday MM/DD/YYYY</Name>
<SubType>Date</SubType>
<Display>true</Display>
<Default />
<Required>true</Required>
<InvalidDataError>Invalid Date MM/DD/YYYY</InvalidDataError>
</wg_Profile>
<wg_Profile>
<DbName>Gender</DbName>
<Name>Gender</Name>
<Options>Male;Female</Options>
<OptionsDirection>0</OptionsDirection>
<InputType>RadioList</InputType>
<Display>true</Display>
<Default>Female</Default>
<Required>true</Required>
</wg_Profile>
<wg_Profile>
</NewDataSet>

You can use the xsd.exe file to convert an xml file into an xsd file...

Here is some VERY scrappy code I wrote to do it...it will write a dataset
schema to an xsd file...


Dim xmloutput As String

xmloutput = bigResultdata.GetXmlSchema

xmloutput = xmloutput.Replace(" encoding=""utf-16""?>", "?>")

My.Computer.FileSystem.WriteAllText(My.Application.Info.DirectoryPath & "\"
& classname & ".xml", xmloutput, False)

ShellandWait(My.Application.Info.DirectoryPath & "\xsd.exe", """" &
My.Application.Info.DirectoryPath & "\" & classname & ".xml"" /c /l:vb /d",
My.Application.Info.DirectoryPath)

My.Computer.FileSystem.CopyFile(My.Application.Info.DirectoryPath & "\" &
classname & ".xml", outputdir & "\" & classname & ".xsd", True)

Hope that helps

John Sheppard

"mr t" <tascien@xxxxxx> wrote in message
news:96d7c58c-c8a8-4d2d-ad34-944177483272@xxxxxx