arie.keren says:
Public
Sub
ProcessRequest(
ByVal
context
As
HttpContext)
Implements
IHttpHandler.ProcessRequest
Dim
prefixText
As
String
= context.Request.QueryString(
"term"
)
Using conn
As
New
SqlConnection()
conn.ConnectionString = ConfigurationManager.ConnectionStrings(
"conn"
).ConnectionString
Using cmd
As
New
SqlCommand()
cmd.CommandText =
"select description from m_cabang_ahass where kota like '%'+ @SearchText + '%'"
cmd.Parameters.AddWithValue(
"@SearchText"
, prefixText)
cmd.Connection = conn
Dim
customers
As
New
List(Of
String
)()
conn.Open()
Using sdr
As
SqlDataReader = cmd.ExecuteReader()
While
sdr.Read()
customers.Add(sdr(
"description"
).ToString())
End
While
End
Using
conn.Close()
context.Response.Write(
New
JavaScriptSerializer().Serialize(customers))
End
Using
End
Using
End
Sub
Yes. You can implement in MySQL. Replace the code with the below.
Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest
Dim prefixText As String = context.Request.QueryString("term")
Using conn As New MySqlConnection()
conn.ConnectionString = ConfigurationManager.ConnectionStrings("conn").ConnectionString
Using cmd As New MySqlCommand()
cmd.CommandText = "select description from m_cabang_ahass where kota like '%'+ @SearchText + '%'"
cmd.Parameters.AddWithValue("@SearchText", prefixText)
cmd.Connection = conn
Dim customers As New List(Of String)()
conn.Open()
Using sdr As MySqlDataReader = cmd.ExecuteReader()
While sdr.Read()
customers.Add(sdr("description").ToString())
End While
End Using
conn.Close()
context.Response.Write(New JavaScriptSerializer().Serialize(customers))
End Using
End Using
End Sub
Refer below article for using ExecuteReader in MySQL.