How to make a nested datalist control?Hello,
I am having two sqlserver database tables named as: "employee" and "employee_details". With the "employee" table, only "employee_id" and "employee_name" are there. And with the "employee_details" table, country, city and state of all the employees are mentioned with the "employee_id".
Now, I am fetching all the "employee_name" from the "employee" table and displaying these data to a datalist control and then I put another datalist control inside this datalist control, which will show the country,city and state of each related employee.
The outer datalist control is displaying all the necessary data, but how I can relate the inner datalist control to the outer datalist control to display the related country,city and state for each and every employee of the outer datalist control?
Please let me know it.