ciao a tutti ho trovato uno script per l'autocompletamento che utilizza j.query e web service.
L'ho provato prima con access e funziona.
Ora ho provato ad usare Mysql ma non va c'è qualcosa che mi sfugge e non capisco mi potete aiutare?
Ecco il codice:

codice:
Pagina Search.ashx

Imports System
Imports System.Web
Imports MySql.Data.MySqlClient
Imports System.Configuration
Imports System.Text

Public Class Search_VB : Implements IHttpHandler
    
    Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest

        Dim prefixText As String = context.Request.QueryString("q")
        Dim conn As MySqlConnection = New MySqlConnection
        conn.ConnectionString = ConfigurationManager _
                .ConnectionStrings("constr").ConnectionString
        Dim cmd As MySqlCommand = New MySqlCommand
        cmd.CommandText = ("select articolo from Articoli where " & _
                           "articolo like @SearchText + '%'")
        cmd.Parameters.AddWithValue("@SearchText", prefixText)
        'cmd.Parameters.Add("@SearchText", prefixText)
        cmd.Connection = conn
        Dim sb As StringBuilder = New StringBuilder
        conn.Open()
        Dim sdr As MySqlDataReader = cmd.ExecuteReader
        While sdr.Read
            sb.Append(sdr("articolo")) _
                .Append(Environment.NewLine)
        End While
        conn.Close()
        context.Response.Write(sb.ToString)
            
    End Sub

Pagina Vb.aspx

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title></title>
<link href="css/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
<script src="scripts/jquery-1.4.1.min.js" type="text/javascript"></script>
<script src="scripts/jquery.autocomplete.js" type="text/javascript"></script>
<script type="text/javascript">
    $(document).ready(function() {
        $("#<%=txtSearch.ClientID%>").autocomplete('Search_VB.ashx');
    });       
</script> 
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="txtSearch" runat="server"></asp:TextBox>
    </div>
    </form>
</body>
</html>