This course has been developed to provide you with the requisite knowledge to not only pass the AWS CSA certification exam but also gain the hands-on experience required to become a qualified AWS Solutions architect working in a real-world environment.
COURSE of the MONTH
10 days, 6 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
MVC - combining two field in a drop down from joint table
Posted on 2014-11-14
I have a table that has 2 foreign key. I would like to create in drop down that contain the value of these two foreign key. How
can I do that?
Here is my table definition:
Master Table
Id INT Prinary key
PhoneNumber VARCHAR(3)
IDLocation Foreign key to location table
IDDepartment Foreign Key to Department table
Master Table with data exammpe:
1|383-383-33838|1|1
Location Table
ID Primary key but this is related to the IDLocation Foreign key in Master table
Location Varchar
Location Table with example.
1|Chicago
Department Table
ID Primary key but this is relate to the ID Department foreng Key in Master table
Department varchar
1|Clothes
So in my drop down I would like something like this.
Please choose
Chicago - Clothes
or "Value" - "value"
can I do that?
Here is my table definition:
Master Table
Id INT Prinary key
PhoneNumber VARCHAR(3)
IDLocation Foreign key to location table
IDDepartment Foreign Key to Department table
Master Table with data exammpe:
1|383-383-33838|1|1
Location Table
ID Primary key but this is related to the IDLocation Foreign key in Master table
Location Varchar
Location Table with example.
1|Chicago
Department Table
ID Primary key but this is relate to the ID Department foreng Key in Master table
Department varchar
1|Clothes
So in my drop down I would like something like this.
Please choose
Chicago - Clothes
or "Value" - "value"
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
Active today
Set the following properties as shown below:
cmbBox.DataTextField = "Diaplay" // for "Chicago - Clothes"
cmbBox.DataValueField = "BothFKs" // for "1|1"
You could concatenate them in your Select statement:
This will produce:
1|1 and Chicago - Clothes
^-- value ^--display
Most likely, you need to use CAST() like, apply it if it errors:
Cast(m.IDLocation as varchar(5)) + '|' + Cast(m.IDDepartment as varchar(5)) As BothFKs
cmbBox.SelectedItem.Text --> "Chicago - Clothes"
cmbBox.SelectedItem.Value --> "1|1"
cmbBox.SelectedIndex --> 0 ,1, 2, ...
cmbBox.DataTextField = "Diaplay" // for "Chicago - Clothes"
cmbBox.DataValueField = "BothFKs" // for "1|1"
You could concatenate them in your Select statement:
Select
m.IDLocation + '|' + m.IDDepartment As BothFKs
, l.Location + '-' + d.Department As Diaplay
From [Master Table] m
Inner Join [Location Table] l
on m.IDLocation = l.IDLocation
Inner Join [Department Table] d
on m.IDDepartment = d.IDDepartment
This will produce:
1|1 and Chicago - Clothes
^-- value ^--display
Most likely, you need to use CAST() like, apply it if it errors:
Cast(m.IDLocation as varchar(5)) + '|' + Cast(m.IDDepartment as varchar(5)) As BothFKs
cmbBox.SelectedItem.Text --> "Chicago - Clothes"
cmbBox.SelectedItem.Value --> "1|1"
cmbBox.SelectedIndex --> 0 ,1, 2, ...
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month10 days, 6 hours left to enroll
765 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.