In the listDetails page I need to display data from the another table which is
not related for FK relation. How should i handle this. Is their templete or attribute to diaply the dropdown of unrelated data in the insert and edit view.
What in the world is the reason why, if you are going to use that relationship in a screen anyway, you don't include such key in your database entity as a foreign key ?
shilpak
Member
4 Points
8 Posts
Dropdown list box
Nov 18, 2012 09:02 AM|LINK
In the listDetails page I need to display data from the another table which is not related for FK relation. How should i handle this. Is their templete or attribute to diaply the dropdown of unrelated data in the insert and edit view.
sjnaughton
All-Star
27308 Points
5458 Posts
MVP
Re: Dropdown list box
Nov 18, 2012 04:23 PM|LINK
Hi shilpak, not exactly sure what is is you want :)
Always seeking an elegant solution.
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Dropdown list box
Nov 19, 2012 12:33 AM|LINK
Hi,
As far as I see, can you show us your:
1) Table schema and its diagrams?
2) For an example, what data you wanna show and what you don't want?
Reguards!
parthi789
Member
32 Points
11 Posts
Re: Dropdown list box
Nov 30, 2012 10:53 AM|LINK
Hi,
I could not understand actually.But i hope this is the solution you are searching for,
DropDownList.DataSource = dataset;
DropDownList.DataTextField = "test to display";
DropDownList.DataValueField = "text for original";
and in onselectedindexchanged you can use the value to chang the values in list
klca
Member
507 Points
409 Posts
Re: Dropdown list box
Nov 30, 2012 01:29 PM|LINK
Hi,
What in the world is the reason why, if you are going to use that relationship in a screen anyway, you don't include such key in your database entity as a foreign key ?
Carlos N. Porras
(El Salvador)