|
|
Posted by Erland Sommarskog on 06/08/06 21:28
Lucky (tushar.n.patel@gmail.com) writes:
> i did the same way but as i said i'm using .net 2.0's dataset which
> seems doesnt understands the view. As i've added "Enforced Constraints"
> in the Dataset, may be that could not allowed the View to be considered
> with foriegn key, unique value, not null constraint.
>
> to avoid this situation i need to some other way. and yes it is true.
> i'm reffering it in more then 20 webpages so i cant modifiy it.
Looks like you have to modify 20+ web pages one way or another.
I don't really know how your .Net looks like, but permit me to point
out that had you retrieved the data with stored procedures, the change
would have been snap.
Then again, not even that should be necessary. Had you defined the
SelectCommand for the adapter in one place, it would also have been
a simple thing.
So when you modify your 20+ web pages, you strive to find a strategy
so that it does not happen again.
You may also want to visit microsoft.public.dotnet.framework.adonet for
better advice for the ADO .Net side of things.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|