simply code simply get what i want, i know this was very bad logic but at least it works
axCZKEM1.SSR_GetAllUserInfo(iMachineNumber, sdwEnrollNumber, sName, sPassword, iPrivilege, bEnabled) = True
Dim sdwEnrollNumber As String = ""
Dim sele As String = "SELECT * FROM emptbl WHERE useid = '" & sdwEnrollNumber & "'"
sele = True
If sele = False Then
Dim insert1 As String = "INSERT INTO emptbl (userid, namex, fingerindex, tmpData, priviledge, password) VALUES (@userid, @namex, @fingerindex, @tmpData, @priviledge, @password)"
Dim cmd As New SqlCommand(insert1, connection)
cmd.Parameters.AddWithValue("@userid", sdwEnrollNumber)
cmd.Parameters.AddWithValue("@namex", sName)
cmd.Parameters.AddWithValue("@fingerindex", idwFingerIndex)
cmd.Parameters.AddWithValue("@tmpData", sTmpData)
cmd.Parameters.AddWithValue("@priviledge", iPrivilege)
cmd.Parameters.AddWithValue("@password", sPassword)
If connection.State = ConnectionState.Closed Then
connection.Open()
End If
cmd.ExecuteNonQuery()
connection.Close()
loadout()
End If