auto complete textboxes

See more:

C#

Dear All,

I have a small query of two auto complete text boxes as I need to combine them as select one item in the first auto complete text box then relevant items on other combo box should display

Need a support

here is my code

this is 3 tier architecture

private void loadautocompleteteamleaderidlist()
{
    DataSet ds = null;
    ds = _brTeamLeader.getteamleaderiddataset();
    AutoCompleteStringCollection col = new AutoCompleteStringCollection();

    foreach (DataRow dr in ds.Tables[0].Rows)
    {
        col.Add(dr["TL_ID"].ToString());
    }

    txtTLID.AutoCompleteCustomSource = col;
    txtTLID.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
    txtTLID.AutoCompleteSource = AutoCompleteSource.CustomSource;
}