select query with sql problem

[Houssem12]

hi members

when i make a test to see if string is exist or not in my database

some time work some time not

Dim cmd23 As New SqlCommand("select AR_Design from F_ARTICLE where ar_ref='" & Nrow("Article").ToString & "'", cn)
Dim lbn56 = (cmd23.ExecuteScalar)

Nrow("Designation") = lbn56


If lbn56 = "" Then

ligne = Nrow("Command") & vbTab & Nrow("Article")

n += 1
End If

some time result nothing but when u look into database it exist

why is that?

please help

Continue reading...