I have a data view webpart and its source is a sql server database table(2005). I have the data view setup to be able to edit some of the fields inside the dataview. Instead of providing the user with a textbox to edit the values I would like to provide a dropdown list with specific values that the user can select from.I got the dropdown and made sure the selected values are perfect but I haven't been successful while I hit the save button its not taking my dropdown value its just showing the previous value which was already in that field that means its not updating the dropdown value but its working perfect if it is textbox. Does anyone know how this is done in Sharepoint Designer tool ? I have been hitting the google for past 2 days so it would be great if any of one have the solution for this issue.
It looks like everything is good but I dont know for some reasons dropdown values are not updating to the datasource. Do I miss something??Please let me know Thanks Vinodh Sankaran