protected void AgentCountries_SelectedIndexChanged(object sender, EventArgs e)
{
AgentsAdapter.SelectCommand.Parameters["@Country"].Value = AgentCountries.SelectedValue;
AgentsAdapter.SelectCommand.Parameters["@UserID"].Value = userid;
//lock (CommonFunctions.Connection)
AgentsAdapter.Fill(MainDataSet, "Agents");
Agents.DataSource = MainDataSet;
Agents.DataMember = "Agents";
Agents.DataValueField = "ID";
Agents.DataTextField = "FullName";
Agents.DataBind();
}
