Bonjour.
Je tente de créer un textbox autocompleted avec jquery. J'ai lu toutes les documentations. J'implémente et quand j'exécute, il ne trouve pas de résultat. Voici le code
Imports System.Data.SqlClient
Imports System.Web.Services
Public Class login
<WebMethod()>
Public Function ListeMarqueModele(ByVal bMarqueModele As String) As List(Of String)
Dim Result As List(Of String) = New List(Of String)
ExecuteLMD("select MarqueModele from a_vehicule where (MarqueModele like '" & bMarqueModele & "%')")
Dim rn As Integer
Do Until rn > bTab.Rows.Count - 1
Result.Add(bTab.Rows(rn).Item(0).ToString)
rn = rn + 1
Loop
bTab = Nothing
Return Result
End Function
Dim bTab As DataTable
Private Sub ExecuteLMD(ByVal bSql As String)
Dim sqlCmd As New SqlCommand(bSql)
Dim Dadpter As New SqlDataAdapter(sqlCmd)
bTab = New DataTable
Dim Dset As New DataSet
SqlConn.Open()
sqlCmd.Connection = SqlConn
Dadpter.Fill(Dset, "bTable")
bTab = Dset.Tables("bTable")
sqlCmd = Nothing
Dadpter = Nothing
Dset = Nothing
SqlConn.Close()
End Sub
Dim SqlConn as SqlConnection
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
SqlConn = New SqlConnection
SqlConn.ConnectionString = ConfigurationManager.ConnectionStrings("LGHI").ToString
end sub
end class
Quand j'exécute, il me ramène le message 'No match'. Où est ce que j'ai fait la faute?