O
OlivierH
Hi all,
I need to make a typed dataset cause i import a dataset from foxpro
I use this code
Dim oDbcommand As New SqlDataAdapter(Sql, Conn_SqlServer)
oDbcommand.MissingSchemaAction = MissingSchemaAction.AddWithKey
oDbcommand.Fill(Me.DataSet, Me.TableName)
My Problem is vs 2005 or Framework 2.0 don"t return the well definition
a numeric field
(from sql server 2000)
the xsl returned for the numeric Field
<xs:element name="cli_pricemin" type="xs:decimal" minOccurs="0" />
for the string field
<xs:element name="cli_email" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
I would like to have the maxlength and the decimal,
for the numeric field , pricemini <xs:maxLength value="10" />
Have you an Idea ?
Olivier
I need to make a typed dataset cause i import a dataset from foxpro
I use this code
Dim oDbcommand As New SqlDataAdapter(Sql, Conn_SqlServer)
oDbcommand.MissingSchemaAction = MissingSchemaAction.AddWithKey
oDbcommand.Fill(Me.DataSet, Me.TableName)
My Problem is vs 2005 or Framework 2.0 don"t return the well definition
a numeric field
(from sql server 2000)
the xsl returned for the numeric Field
<xs:element name="cli_pricemin" type="xs:decimal" minOccurs="0" />
for the string field
<xs:element name="cli_email" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
I would like to have the maxlength and the decimal,
for the numeric field , pricemini <xs:maxLength value="10" />
Have you an Idea ?
Olivier