Formview w/o SQLDatasource is updating to original values only -
06-20-2007
, 12:43 PM
First, a warning - I'm a bit green at this. I have a formview control
for which I am manually binding to a DataSet object instead of using
the SQLDataSource. This is because I can't get SQLDataSource to work
with MySQL, but that's another issue. I have added a button to run an
update query via the ExecuteNonQuery() method. I got it all working
well, but the update SQL statement reveals that I'm trying to set the
fields to their original values, not to the new ones I had typed in.
Apparently, as I'm pointing to the controls within the FormView, I'm
somehow reading them only "after" the page has reloaded, which is
useless. I treed using a Request["formfieldname"], but it always comes
up null, so I am guessing that each control in the formview is _not_
submitted with the form as an individual form field submission. The
question is, how do I pass this data to the code to process correctly?
If you can guide me through this with dome details, please do so. My
last thread of hope is about to snap.
Thanks.
J |