I am creating a dataset from a SQL Server database. The underlying table has a unique constraint on one of the columns, but this is not being reflected in the .Unique property of the appropriate DataColumn. Is there any way I can get this property to update automatically.

For example, the Field Length and Allow Nulls properties do net get written to the dataset unless you set da.MissingSchemaAction = MissingSchemaAction.AddWithKey

Is there something else I can set to add the .Unique property? I know this can be set manually but I need a generic solution as I will not always know which database fields have unique constraints.

Thanks for your help

why dont u set it to DataSet in Design time?! or u genrate ur DataSet at run time?

Keep in touch.

Always:),
Hovik Melkomian.

Try generating Typed Dataset probably you will get it there.


It is not how much we do,
but how much love we put in the doing.

-Mother Theresa

Try this link
http://www.dotnetextreme.com/code/getdbschema.asp


It is not how much we do,
but how much love we put in the doing.

-Mother Theresa