Information générale
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Network:
Windows 2003 Server
Kevin,
Thanks, the join works and displays what I want but...
Unfortunately when I do a save as below I get an error:
// Save the DataSet (the GridView automatically binds back)
this.Save(this.oSurveyDue, dsSurveyDue);
InvalidOperationException was unhandled by user code.
Dynamic SQL generation is not supported against multiple base tables.
I assumed you wanted me to modify the SQL passed to the this.GetDataSet() in the bizobj. Should I have done this someplace else?
FYI, an ugly solution that did work was I put a similar but disabled dropdownlist in the itemtemplate.
Thanks, Ted
>Ted,
>
>>My template field dropdownlist is bound to a status table with a status code & description. I want to update the gridview table with the status code but display the status description in the grid after updating.
>>
>>If I may speak VFP/VMP I wish to implement a picklistvalid but not expose the underlying FK's/codes.
>
>In this scenario, you need to have the DataTable bound to your GridView return both the code and the description from the back end (by means of a join). That way the ItemTemplate label can bind to the description text rather than the code. This will require you to update the description when a user selects an item from the DropDownList.
>
>Best Regards,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement