Psst! Did you know DevelopmentNow is a mobile web site design agency?

Contact us for help mobilizing your site, or to sign up for our beta Mobile Web SDK!
all groups > dotnet framework > april 2008 >

dotnet framework : typed dataset


OlivierH
4/20/2008 7:53:05 PM
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 ?

Spam Catcher
4/20/2008 9:52:17 PM
OlivierH <"nospam[contact]"@planitron.com> wrote in news:eo#iS9woIHA.524
@TK2MSFTNGP05.phx.gbl:

[quoted text, click to view]

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

--
OlivierH
4/21/2008 1:31:23 PM
Can you read this white paper ?

http://www.west-wind.com/presentations/foxpronetwebservices/foxpronetwebservices.asp

Olivier

Spam Catcher a écrit :
[quoted text, click to view]
AddThis Social Bookmark Button