Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Can not generate INSERT, UPDATE, and DELETE statements

Avatar of phishyman2
phishyman2 asked on
Web Development Software
9 Comments1 Solution230 ViewsLast Modified:
When I drag a gridview control onto my webform, I get to a point where I can configure my Select Statement. I click the "specify columns from a table or view" and then select my table. Now I select that I want to use all of the columns, and then select the Advanced button. Here is the problem. I would like to select "Generate INSERT, UPDATE, and DELETE statements" and "Use Optimistic Concurrency" from the Advanced SQL Generation Options dialog box, but it won't let me. The choices are grayed out. WHY????? I have loaded this software at work and at home and have the same problem at both places. I am using different databases and webpages at both places and still have this problem. I have watched the video multiple times and don't see what I am missing. Any ideas?
Avatar of Badotz
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answers