Plz Help Me In This Regard
Am useing Ajax Control
1)ToolkitScriptManager1
2)AutoCompleteExtender
i created web service
as Follows
Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports AjaxControlToolkit
Imports System.Data.SqlClient
<System.Web.Script.Services.ScriptService()> _
<WebService(Namespace:="http://tempuri.org/")> _
<WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Public Class AutoComplete
Inherits System.Web.Services.WebService
Private ReadOnly Property ConnectionString() As String
Get
Return "Server=.\SQLEXPRESS;Database=testproj;Trusted_Connection=True"
End Get
End Property
Private ReadOnly Property Connection() As SqlConnection
Get
Dim ConnectionToFetch As New SqlConnection(ConnectionString)
ConnectionToFetch.Open()
Return ConnectionToFetch
End Get
End Property
<WebMethod()> _
Public Function GetProducts(ByVal prefixText As String, _
ByVal count As Integer) As String()
Dim SelectQry = "select * from trydb where username like '%" & prefixText & "%'"
Dim Results As New ArrayList
Try
Using Command As New SqlCommand(SelectQry, Connection)
Using Reader As SqlDataReader = Command.ExecuteReader()
Dim Counter As Integer
While Reader.Read
If (Counter = count) Then Exit While
Results.Add(Reader("username").ToString())
Counter += 1
End While
End Using
Dim ResultsArray(Results.Count - 1) As String
ResultsArray = Results.ToArray(GetType(System.String))
Return ResultsArray
End Using
Catch ex As Exception
Throw ex
End Try
End Function
End Class
Its Running And Ask Me For invoke..bUt Then Getting Error
Request format is unrecognized for URL unexpectedly ending in '/GetProducts'.
Plz tell me The Way To Autofill
Thanks
Kaustubh