Hi

My DropDownList is connected to database so that table value (3 values) is showing in the DropDownList.

For example (India, Singapore, usa).

Is there any way user can enter a new name (Dubai) also or select from the existing table value (India, Singapore, usa).

In DropDownList allow users to type also so that -> if they types then Singapore, silence etc. will come, if user selects i then India, Indonesia etc. will come at list.

<asp:DropDownList ID="kdrp" runat="server" Width="418px" AutoPostBack="True" OnSelectedIndexChanged="kdrp_SelectedIndexChanged">
</asp:DropDownList>

if (!IsPostBack)
{
    BindProducts1();
}

private void BindProducts1()
{
    con.Open();
    DataTable dt = new DataTable();
    MySqlDataAdapter adp = new MySqlDataAdapter("Select desc,locationname from abmaster where username='"+ uselbl.Text +"'", con);
    adp.Fill(dt);

    if (dt.Rows.Count > 0)
    {
        kdrp.DataSource = dt;
        kdrp.DataTextField = "desc";
        kdrp.DataValueField = "desc";
        kdrp.DataBind();
        BindLabel();
    }
}