Hi guys,

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.

You should call DataBind() on your SaveClick()

may be like this:
private void OnSaveButton_Click(object sender, EventArgs e)
{
    SaveUserChoise();

    DataBind();
}