Dim a As String() = {"247.032", "247.038", "009.549", "009.452", "010.328", "009.901", "009.902", "009.948", "247.020", "008.540", "008.978", "009.236", "", "007.821", "007.823", "008.309", "008.310", "008.313", "008.314", "008.472", "008.473", "008.482", "007.821", "008.481", "008.306", "008.307", "010.740", "009.274", "009.275", "007.520", "007.620", "963.709", "007.850"}
Dim b As String = "5"
Dim t As String = regCis
Dim result = a.Any(Function(x) t.StartsWith(x) AndAlso t.EndsWith(b))
If result = True Then
provider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source ="
dataFile = "sdf.accdb" ' Change it to your Access Database location
connString = provider & dataFile
Dim command As New OleDbCommand("SELECT * FROM Log WHERE [Zákaznické číslo] = '" & TextBox2.Text & "'")
Dim cnn As New OleDbConnection(connString)
command.Connection = cnn
Try
cnn.Open()
Catch
MsgBox("Připojení k databázi se nezdařilo.", , "Chyba")
End Try
dr = command.ExecuteReader
If dr.HasRows And t.EndsWith(b) = True Then
MsgBox("Čárový kód byl již skenován " & TextBox2.Text, , "Chyba")
TextBox2.Clear()
tiskEtiketaBut.BackColor = Color.DimGray
tiskEtiketaBut.Enabled = True
TextBox2.Select()
myConnection.Close()
Else
What I have tried:
Here is my code, I would like to paste else condition for result behind else of hashrows . How can I do it? Thank you.
If result is true then next condition look to database if number was scanned. And now I want send else for result and else for hashrows.