typed dataset

[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

 

[Guest]

Have you an Idea ?

Best not to use a typed dataset for a web service.