FormView, DataSource, Update, and why it doesn't work

[Shawn Anderson]

Does anyone have any suggestions on how to determine why my updates that
happen inside a formview are not being saved back to my database? I have a
datasource with select, insert, and update statement (simple SQL), I am
using standard databinding -- yet it doesn't work. The updating event files
correct, and the updated event fires -- but it indicates 0 rows affected.

Any help would be great.

Thanks
Shawn

 

[PeterKellner]

Does anyone have any suggestions on how to determine why my updates that
happen inside a formview are not being saved back to my database? I have a
datasource with select, insert, and update statement (simple SQL), I am
using standard databinding -- yet it doesn't work. The updating event files
correct, and the updated event fires -- but it indicates 0 rows affected.

Any help would be great.

Thanks
Shawn

Could you possibly post some code? Does delete work? If not, it
could be you do not have a primary key set correctly in the table (or
you don't have datakeynames set.
Peter Kellner
http://peterkellner.net