Solved

SQLDataAdapter Update Command Not Create

Posted on 2011-03-05
1
672 Views
Last Modified: 2012-06-27
When I add a SQLDataAdpater to a form the wizard indicates that is will create the Select, Insert, Update, and Delete commands.  However, only the Select and Insert commands are created.  I am using Visual Studio 2008 Express and SQL Server Management 2005 Express.  What am I missing?
0
Comment
Question by:StoneCutter3
1 Comment
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 500 total points
ID: 35045154
Does your table have a Primary key? Update and Delete commands require a primary key to work.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Analysis of table use 7 30
Total in textboxes 9 35
Get String split 5 33
Protecting vb6 & .Net code Obfuscation 18 55
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now