A DbDataAdapter issue

  • Thread starter Manuel Vázquez Acosta
  • Start date
M

Manuel Vázquez Acosta

Hi all:

I have a view in my SQL, which combines 3 data from 3 tables. I have dragged
and dropped the View to my WebForm and VS created a DataAdapter. However it
cannot add the proper Update and Delete commands. I have tried creating 2
stored procedures for that purpose and I have modified the DataAdapter, but
when I call the DataAdapter.Update(MyDataSet), updating rows causes an
exception (some parameters of the sp haven't been passed), and deleting rows
silently fails.

Any tips?

Manuel.
 
K

Kris Desmadryl

You have a parameter mismatch.
I assume that the update is for one of the tables. Drag this single table to
a component and verify the generated dataAdapter.
 

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

Problems with Updating Data 6
DataAdapter.Update calling Insert Command with DbNull values 2
what to actually do on dbconcurrency exception? 1
DataAdapter update not including all parameters 6
Updating a Dataset 2nd part: Accepted/Rejected rows ? 1
Unable to Update A Table Schema Progmatically 1
import from text file, change rowstate 2
Trouble with SqlCeDataAdapter.Update 2

Top