I am using update panel and datalist to repeat data. I want to view data
Emp_id, Emp_Name
its display correctly but i want to use the
Emp_Id
generate by the datalist to view some data from another table. But i can't do that. How can i retrieve the
Emp_Id
generated by the datalist to use in select sql command.
Ex:-
Select * from Table where Emp_Id=?
what is the parameter use.
Emp_Id
only generated in
<%#Eval("Emp_Id")%>
but i can't use it in the command because
this command is generated the
Emp_Id
Here is the original command:
SELECT * FROM empdetails,department where empdetails.emp_allow=1 and empdetails.Emp_ID="?" and department.emp_status=1
Here select * from empdetails generate EmP_id and generate Emp_Id i want to use.
Please any one can help me.....Thanks in advance