SQLDataAdapter.Update troubles.

  • Thread starter Thread starter W.G. Rowland
  • Start date Start date
W

W.G. Rowland

Anyone have any suggestions? I'm using stored procedures to save and
retrieve records to the database. The problem is in the code for the
SqlCommands being used in the dataadapter..

Select works perfectly.
Insert works perfectly.
Update and Delete fail.. On parsing the execution of the commands in Sql
Parser I see that the commands are getting executed, but "default" is
getting inserted in all the @Original_ColumnName values...

The code for the SQLCommands was taken directly from the DataAdapter
wizard.. Anyone have any idea why it's not working?
 

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

SCOPE_IDENTITY won't return correct value, but @@IDENTITY does 6
ADO.Net transaction and ExecuteDataset 1
sqlDataAdapter.Update using Dataset.Merge -- Does not work -- any reason? 1
Looking for Comments on Code 5
best practice for inserting rows using a dataAdapter? 8
Wrraping Command Object 2
DataAdapter.Fill(Dataset) shows timeout error. 2
*VERY* Simple DbDataAdapter.Update - Incorrect MSDN Documentation???? 22

Back
Top