formview的sqldatasource的部分语句如下:
selectcommand="select pc.*,department.department from pc left join department on pc.departmentid = department.departmentid"
updatecommand="update pc set pcmanager=@pcmanager,departmentid=@departmentid where id=@id"
我在formview的edit模板里放了一个"部门"的下拉菜单。该下拉菜单项是绑定另外一个datasource(即select * from department)与formview不一样。在这种情况下要怎么实现在点击“更新”后把下拉菜单的内容更新到数据库里?