Problem with datagrid
Guys I have a datagrid on the web page with template comlumns. i hv dropdown lists in all of them.Those are name,department & branch.
The user will select the name & then select the corresponding dept name & the branch name to assign to the user.
What I want is the dropdown list shud be populated only with the names which has not been assigned any dept & branch.I do get tat with a not in subquery.
The problem is that when user clicks save after he selects the name the name of that person continues to stay on in the dropdown.But if I click refresh that name is not shown in the dropdown.what I want is as soon as he clicks save that name shud not be shown in the dropdown.the buttons are placed in the template column so are the dropdowns.By the way I am using datatabels.
Any help will greatly appreciated.
Thanks in advance.