Help Needed In dynamic control and viewstate.

Question

Hi Friends,

need a help regarding an assignment. An .aspx page with a static textbox and a button named "Generate". we have to enter a number in the textbox (say 4) then on the Generate button click four(4) dynamic dropdownlist are created and a button named "ADD" is also created. The first dynamic dropdown contains number 1 to 10 and second dynamic dropdown contains 10 to  20 and so on... On clicking the dynamically generated button "ADD" button the selected values on the four dynamically created dropdownlist will added and shown in another dynamically created label and the dropdown should contain the selected values respectively without any javascript or jquery. basically its somewhat related to page lifecycle and viewstate. Can anybody please help?

Thanking You all friends. Looking for your kind help on the issue.

Answer 1

SELECT Empid,Empname,Deptname
FROM Employee
INNER JOIN Department ON Department.Deptid = Employee.Deptid

This is the best code.

Answer 2

SELECT Empid,
            Empname,
            Deptname
FROM Employee
INNER JOIN Department ON Department.Deptid = Employee.Deptid