Suppose in a situation if two list boxes are there and if
you select multiple options based on that the options
related to those selected items should display in second
Again if we select multiple items in second listbox then the
related to those selected items should display .
In this scenario how will you design database,tables?
Answer / pawan k. dubey
e.g. create two table
1-department(dept_id int PK,dept_name)
2-employee(emp_id int Primary key,Name varchar(40),dept_id
now create two listbox employee and department.
step1-when multiple departments are selected...dispaly
employee related to selected department in employee listbox
step2-when multiple employees are selected...dispaly
respective department in department listbox
|Is This Answer Correct ?||1 Yes||1 No|
How can I enforce to use particular index?
What is SQL server agent?
tell me the disaster recovery plan
how many non clustered index in sql server 2008,2010,2012
How to Install SQL SERVER 2005 remotely?
Define Foreign Key?
what is the diffrence between Snap Shot and Transaction Replication
Why Do you want to work in this company?
What is the difference between Procedure and Function
explain query execution plan
What are the types of model in sql server and explain
you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required