Dear Developers
SQL, Table1 has data as following
Code------product
1-----------Mango
2-----------Potato
3-----------Orange
Datagridview has THREE columns as
Code----product-------qty
I have following codes
str3 = "SELECT product FROM table where code =" & Val(DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(0).Value)
dt3 = GetTable3(str3)
If dt3.Rows.Count > 0 Then
DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(1).Value = (IIf(IsDBNull(dt3.Rows(0).Item("product")), "", dt3.Rows(0).Item("product")))
Else
MsgBox("Code Not Found", MsgBoxStyle.Information)
End If
If code not found then msgbox appears and cursor moves to NEXT COLUMN. That works fine
But I want ......
When code not found then cursor MUST NOT GO TO NEXT COLUMN. It should remain there until it found value from Table1.
Should I change code or choose some other datagridview event?
Please help