all groups > dotnet windows forms databinding > november 2006 >
You're in the

dotnet windows forms databinding

group:

Im am having trouble with the Advanced SQL Generation Options


Im am having trouble with the Advanced SQL Generation Options The Generate Insert, Update, and Delete
11/20/2006 11:17:01 AM
dotnet windows forms databinding: I am having trouble with not being able to Check the Generate Insert, Update,
and Delete Sql Statements; in the Advanced SQL Generation Options Dialog Box.
If there is some configuration settings in the visual studio Web express
editions that allows me to turn it off or on then could you answer this
question.

Thanks Shawn
Re: Im am having trouble with the Advanced SQL Generation Options Otis Mukinfus
11/22/2006 6:55:43 AM
On Mon, 20 Nov 2006 11:17:01 -0800, The Generate Insert, Update, and Delete <The
[quoted text, click to view]

I think you might get an answer at the "microsoft.public.vstudio.development"
news group.

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
RE: Im am having trouble with the Advanced SQL Generation Options The Generate Insert, Update, and Delete
11/27/2006 6:51:01 AM


[quoted text, click to view]

Thanks everyone, I found the answer and I would like to share the common
reason why this happens, the Advanced SQL Statements will not become active
until you have a PrimaryKey set with in your SQL Database. Unlike access in
the old .Net 2003 version these Statements are generated for you and does not
need to be created manually. Im not sure why microsoft distinguished the Old
DataAdapter methods for web development but they were handy in with data
modification with having to use a primarykey. But thats life. GL (Good Luck
AddThis Social Bookmark Button