Interested to Buy Any Domain ? << Click Here >> for more details...
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
list box.
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?
- 1 Answers
- 5382 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / 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
FK)
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 |
Post New Answer View All Answers
What is SQL Server?
What is executereader?
where the connection string store in the database
What is indexing explain it with an example?
What is difference between index and primary key?
What is the difference between a unique key and primary key?
What is analysis service repository?
If a table does not have a unique index, can a cursor be opened on it?
What is set nocount on?
What is the temp table?
How to scale out a federation by Sql statement?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is a natural primary key?
Explain hostprotectionattribute in sql server 2005?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
