DataAdapter for Insert

B

BoM

Hi, I'm using a DataAdapter with sqlserver(Express) in a server app.
The SQL Insert is generated with an additional Select when not checked off. How can the result of this generated select be accessed? GetData() with get all the data in the table and not the just inserted data.

Thanks
BoM
 
W

William \(Bill\) Vaughn

The extra SELECT is processed by the Update method based on its property
settings that are used to determine the newly created Identity value or
other columns that have changed since the last update.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert from DataAdapter table 1
DataAdapter in vs2008 7
Data Inserts using DataAdapter 1
DataReader and DataAdapter 7
Stored procedure advise 3
IDENTITY INSERT with Access and ADO.NET 5
IDENTITY INSERT with Access 2000 and ADO.NET 2
DataAdapter and inserting into a table with a AUTO Counter field? 3

Top