Anyone know if this is the way this is supposed to be working or any
potential workarounds?
I have a DateTime column 'DateExpires' which I am returning as a computed
column via my SELECT statement. When I call GetXML() on the DataSet, it
isn't returning the computed column. However, when I do a quickwatch on the
DS, I see that the column is in the dataset. Also, I have a bound webform
control which is getting populated with the value from this column in the
dataset.
strCmd = "SELECT ID,
CAST((DATEPART(m, DateExpires)) as varchar(2))+ '/' +
CAST((DATEPART(d, DateExpires)) as varchar(2))+ '/' +
CAST((DATEPART(yy, DateExpires)) as varchar(4)) as DateExpires
FROM Articles"
sqlDA.SelectCommand = new SqlCommand(strCmd, sqlCN);
sqlDA.Fill(objDS);
objDS.GetXML()
returns:
<DSArticles xmlns="http://tempuri.org/Schema_Articles.xsd" />
<NewDataSet>
<Articles>
<ID>e75baa38-f084-472e-a14f-2517f00f3d67</ID>
</Articles>
</NewDataSet>
XSD as follows:
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Schema_Articles"
targetNamespace="http://tempuri.org/Schema_Articles.xsd"
elementFormDefault="qualified"
xmlns="http://tempuri.org/Schema_Articles.xsd"
xmlns:mstns="http://tempuri.org/Schema_Articles.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="Document">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="Articles">
<xs:complexType>
<xs:sequence>
<xs:element name="ID"
msdata:DataType="System.Guid, mscorlib, Version=1.0.3300.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089" type="xs:string" />
<xs:element name="DateExpires" type="xs:string"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="DocumentKey1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Articles" />
<xs:field xpath="mstns:ID" />
</xs:unique>
</xs:element>
</xs:schema>