parameterized tableadapter wont save to access dat
i have a tableadapter with sql
select * from table where field=?
i load a record in a form suplying value for field
but after modifying the values in the textboxes
i try to save
bindingnavigator.endedit()
tableadapter.update(dataset)
in the last sentence i get
"no valid update command"
the dataset marks the row as modified
but if i use
dataset.acceptchanges()
the modify flag is reset but changes are not commited to
the database
any ideas?
|
