Home All Groups Group Topic Archive Search About

vb2005 parameterized tableadapter wont save to access database

Author
12 Jun 2006 12:07 PM
eduardoben@gmail.com
I use a tableadapter with the sql string = select * fom table where
field=?
I load the desired record in a form and populate textboxes
but after i modify them when i use tableadapter.update it wont save
the changes to the database
i get the error "There is no valid update command"
any ideas?
Thanks

Author
12 Jun 2006 12:38 PM
Cor Ligthert [MVP]
Eduard,

At least do you have to fill the parameters.

http://www.vb-tips.com/default.aspx?ID=550279ec-6767-44ff-aaa3-eb8b44af0137

I hope this helps,

Cor

<eduardo***@gmail.com> schreef in bericht
Show quoteHide quote
news:1150114038.976777.314720@i40g2000cwc.googlegroups.com...
>I use a tableadapter with the sql string = select * fom table where
> field=?
> I load the desired record in a form and populate textboxes
> but after i modify them when i use tableadapter.update it wont save
> the changes to the database
> i get the error "There is no valid update command"
> any ideas?
> Thanks
>