Problem with Details View and Multiple DataSources
i'm having a problem maybe someone can help me
I have 2 datasources (1 for table Products and another for table Status)
When i create a DetailsView for Products Data Source, i get all the information, but on my Status field i get a TextBox, which i want to change to a DropDownList (to maintain Referential Integrity)
I was able to do that with a ItemTemplate, that has a DropDownList that has it's source as the Status Data Source.
Furthermore the SelectValue is Two Way Bounded with Status field of the Products Data Source
But when i try to update the Product Record, the changes i do in Status aren't recorded in the Database, i still get the same values
Any ideias ??
I think maybe the problem is in the fact that i'm using an ItemTemplate, so the Edit command isn't fetching the value from it, but this is a pretty standard thing to do in a wep page, so there should be some (easy) way to do this