views:

21

answers:

0

I created a new table adapter inside a dataset.xsd. In the tableAdapter I created an update query to do a simple update on that table

Update table
set c=@c
where d=@d AND e=@e

I tested the query in the dataset and it worked.

Now I am trying to use the query but it wont update the database or the datatable. What am I missing?? Also there are no exceptions the code executes the statements fine. Here is a code frag...

objUnionsta.UpdatePrimaryUnion(False, _jobId, _kTest)
objUnionsta.Fill(objUnionsts)

where objUnionsta is the table adapter and objUnionsts is the datatable its connected too