On top of that, the table being updated had over 50 columns, so typing in 50 lines just to initialize the parameters was required, but I decided to do something else instead.The parameters being sent to the stored procedure were identically named to the column names.Initializing the SQL data source also had another problem – because certain data needed to be re-encrypted before being sent back to the database.You will need to single out any columns that need to be encrypted. I have a Details View with a Drop Down List in an Edit Item Template, I know, pretty cool right?But when I try to Update the table with a new value from the Drop Down List the table does not get updated with the new value.
If we look at this event we can see the Grid View nicely packages for us the new values, old values and the keys for the updating row.This method uses the ‘Extract Values From Cell’ method to grab values from the Details View control.This method isn’t exactly well documented on MSDN, so it’s not obvious at first that the passed parameter, IOrdered Dictionary dictionary, is being used as a referenced parameter, not as a copy. NET framework] The method, Get Values, used is identical to what is covered at the article written at David Fowler’s blog.If you go with the flow, you probably won't get stuck, but the moment you try to go against the grain you end up with a hand full of thorns.Most of the data controls have events ending in ing and ed e.g. In most of the event handlers of the ing events it is easy to get the values from the event args.