Re: Typed Datasets

FYI, I found this after refining my google search and solved the problem
once and for all. Here is a reprint of Mr. Beauchemin's post. You might want
to also subscribe to his blog which at the moment seems to be focused on sql
server 2005 and the CLR.

Regards,
stephen

<post>

You can make the XSD schema "semi-manually", by using DataAdapter.Fill with
MissingSchemaAction = MissingSchemaAction.AddWithKey. Then use
DataSet.WriteXmlSchema to output the schema and it will contain a
xsd:maxLength restriction on the xsd:simpleType produced for that column. If
you use this schema to create a strongly typed DataSet the DataSet will have
MaxLength properties on the associated columns.

Not sure of the easiest way to do that with VS, but I've done it with
XSD.exe from the command line.

Hope this helps,
Bob Beauchemin
</post>

===================================
This list is hosted by DevelopMentor®  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com