I have one combobox in my app that gets populated with a dozen or so items from SQL SERVER. I am currently trying to allow user to be able to type in a new value into the combobox and save it to a table in SQL SERVER. I'm looking for something along the lines of a DropDownStyle of DropDown and DropDownList. Basically I'm hoping to let the user type in the combobox, however if the value is not there, i want to be able to give them an option of saving it (probably on lost focus). I'm wondering what would be a good way of doing something like that. 

On lost focus should I basically go through each item that is currently in the drop down and check it against the value entered? 

EDIT:

```
    Sql="SELECT IDvalue, TextName from TblReference"
    Dim objconn As New SqlConnection
    objconn = New SqlConnection(conn)
    objconn.Open()

    Dim da As New SqlDataAdapter(sql, objconn)
    Dim ds As New DataSet

    da.Fill(ds, "Name")

    If ds.Tables("Name").Rows.Count > 0 Then
    Dim dr As DataRow = ds.Tables("Name ").NewRow
    ds.Tables("Name").Rows.InsertAt(dr, 0)
    With c
         .DataSource = ds.Tables("Name")
         .ValueMember = " IDvalue "
         .DisplayMember = " TextName "
    End With
    End If

```