A DbDataAdapter issue

  • Thread starter Thread starter Manuel Vázquez Acosta
  • Start date 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.
 
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.
 
Back
Top