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