TableAdapter with stored procs not sending the proper values on Update

  • Thread starter Thread starter EvansJunk
  • Start date Start date
E

EvansJunk

Hi

I have a bunch of strongly typed TableAdapters that need to use stored
procs for DB interaction. When I call Update in the tableadapters
passing in the getChanges from a datatable, it tries to update using
the stored proc for the insert but it sets each parameters value to
default. I know this cuz I looked at it in SQL profiler to see what was
being send to the DB(SQLExpress). I know that I can probably call
Insert instead and break out each value from the datatable but the
magic is supposed to take care of it. I also have tried looping through
the datatable with a foreach and sending each row in but the result is
the same.

Anyone that can give me some insight on my problem?

Thanx
Evan Brown
 
One other thing, I just tested with calling Insert instead of Update
and it works, the parameters are sent to the DB as they should be.

Evan
 
Back
Top