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
- 5300 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
How can you manage sql azure security?
Explain about thread and memory management process of SQL?
Explain the purpose of indexes?
Does partitioning help performance?
What are magic tables in sql server?
Explain what is use of dbcc commands?
What is temporary table in sql server? Why we use temp table?
Define right outer join in sql server joins?
What are the tool windows in sql server management studio? : sql server management studio
How to call a function from a stored procedure in SQL Server ?
What is the difference between delete and truncate statements?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What are the requirements for sql server 2016?
How do you delete a data source?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
