Send feedback on this topic.
Teradata.Client.Provider
GetXmlSchema Method (TdPeriodTimeWithTimeZone)
Example 



Teradata.Client.Provider Namespace > TdPeriodTimeWithTimeZone Structure : GetXmlSchema Method
Holds zero or more XML Schema definition language (XSD) schemas.
Specifies the XML Qualified name for TdPeriodTimeWithTimeZone XML type mapping.
Syntax
'Declaration
 
Public Shared Function GetXmlSchema( _
   ByVal xmlSchemaSet As XmlSchemaSet _
) As XmlSchemaComplexType
'Usage
 
Dim xmlSchemaSet As XmlSchemaSet
Dim value As XmlSchemaComplexType
 
value = TdPeriodTimeWithTimeZone.GetXmlSchema(xmlSchemaSet)
public static XmlSchemaComplexType GetXmlSchema( 
   XmlSchemaSet xmlSchemaSet
)
public:
static XmlSchemaComplexType^ GetXmlSchema( 
   XmlSchemaSet^ xmlSchemaSet
) 

Parameters

xmlSchemaSet
Holds zero or more XML Schema definition language (XSD) schemas.

Return Value

Returns a XmlSchemaComplexType that describes a TdPeriodTimeWithTimeZone.
Example
This examples shows how to use TdPeriodTimeWithTimeZone with the Xml.Serialization.XmlSerializer class. Xml.Serialization.XmlElementAttribute is used to indicate that the column can be Null.
public class ProductAdvertisement
 {
     public TdDate Date;
            
     public Int32 ProductId;
            
     public Int32? QuantityAvailable;
             
     public TdPeriodTimeWithTimeZone advertisePeriod
            
     public String adPlacement;
 }
             
 internal class ProductAdvertisementWriter
 {
 
     public static void Write()
     {
         // Setup the advertisement
         ProductAdvertisement x = new ProductAdvertisement();
 
         x.Date = new TdDate(DateTimeWithTimeZone.Today);
         x.ProductId = 100;
         x.QuantityAvailable = 2000;
             
         // Advertisement will last for 7 hours
         x.AdvertisePeriod = new TdPeriodTimeWithTimeZone(
                new TdTimeWithTimeZone(7, 0, 0, 0, new TimeSpan(-2, 0, 0)), 
                new TdTimeWithTimeZone(14, 0, 0, 0, new TimeSpan(-2, 0, 0));
         x.adPlacement = "The Newspaper";
            
         // Write out today's advertisements to the file.
         //
         // Open the file.
         XmlWriterSettings settings = new XmlWriterSettings();
         settings.Indent = true;
         XmlWriter writer = XmlWriter.Create(@"C:\Temp\ProductAdvertisements.XML", settings);
         writer.WriteStartElement("ProductAdvertisements");
   
         // Write out the schema.
         XmlSchemas schemas = new XmlSchemas();
         XmlSchemaExporter schExporter = new XmlSchemaExporter(schemas);
         schExporter.ExportTypeMapping(new XmlReflectionImporter().ImportTypeMapping(typeof(ProductAdvertisement)));
         schemas[0].Write(writer);
            
         // Write out the advertisements.
         XmlSerializer xml = new XmlSerializer(typeof(ProductAdvertisement));
         xml.Serialize(writer, x);
 
         // Close the document.
         writer.WriteEndDocument();
         writer.Close();
     }
 }
             
/* Output is:
             
2007-02-01100200007:00:00-02:0014:00:00-02:00The Newspaper
             
*/
Requirements

Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019

See Also

Reference

TdPeriodTimeWithTimeZone Structure
TdPeriodTimeWithTimeZone Members