Hey Steve,

>>Been almost a year, hasn't it? (But I got your update over the weekend! <s>)<

Yep, last year's WhilFest. (Hope you enjoy the pics! < s >)

It's funny, Gary and I were just discussing this topic at lunch today ... we generate our DataSets from Stored Procs, in fact all of our data access is via SP's. Everything. In your example, it sounds like you got your DataSet just from running a Select via the DataAdapter, which probably gives similar results.

I bet that if you generate your DataSets by dragging tables into the .NET IDE from the Server Explorer *that's* probably how the constraints get propagated into the DataSet. Since I've never done it that way, I dunno for sure. Anybody else have anything to say about this??? Rick?? Is this the way you generated your DataSet?

~~Bonnie


>>Hiya Steve!! Long time, no see!!
>
>Been almost a year, hasn't it? (But I got your update over the weekend! <s>)
>
>>Yeah, I'm still not clear as to why Rick's DataSets enforced the constraints and mine don't. Nobody's answered that question yet, AFAIK.
>
>If the DataTables and DataSets would automatically pickup *any* SQL Server constraint, that would be something that I've dreamed of - the ability to store constraint and other rule information in the database, and be able to surface that information in the UI without having to enforce the rules twice, and not have to make another round-trip to the database to validate or apply business logic or protect data integrity.
>
>This wouldn't be appropriate for everything, all existing caveats about where to enforce business logic and data integrity still apply, but this would be such a powerful capability...