Cancel users attempt to exit cell in a Datagrid

[Riks]

Hi,

hopefully someone can help me with this little problem.
I have a datagrid where users can edit the values in all cells. I also have a
database containing valid values for all cells in a row. E.g: in the column "Name" the only valid values are "Mort", "Cocher" and "Dew".
So what i need to do is prevent the user from exiting a cell if the value he
has typed doesnt match values in the database.

Can it be done?

what i have so far is this:

Private Sub DataView1_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellLeave
        If loading = True Then
            Exit Sub
        End If
        Dim colName As String = DataGridView1.Columns(DataGridView1.CurrentCell.ColumnIndex).Name
        Dim rowNo As String = DataGridView1.CurrentCell.RowIndex
        Dim value1 As String = DataGridView1.CurrentCell.EditedFormattedValue
        Dim goodTogo As SQLiteDataReader
 
        Select Case colName
            Case "Timetype"
                SQLstr = "SELECT name FROM tbltimetype WHERE Name Like '" & value1 & "';"
                goodToGo= OpenDB(SQLstr, path, mdb).ExecuteReader
                If goodToGo.Read Then
                     'the value exits in the database, do nothing
                      Exit Sub
                Else
                      DataGridView1.CancelEdit()
                      'So far so good.. Now how do I maintain focus on this cell??(Not exit it)
 
                End If
                goodToGo.Close()
                closeDB()
            Case 2
 
        End Select
 
    End Sub

Thanx in advance

[jmcilhinney]

You should put a CoMboBox in that column and have the user select a value from a list. That way you're guaranteed of the value entered being valid. Follow the WinForms FAQ link in my signature. That page has lots of good information on various controls, and the DataGrid inparticular. It will have information on putting a ComboBox in a DataGrid.

[Riks]

Thanx for the reply. I was hoping i wouldnt have to do that, but ill check it
out. Thanx

Riks