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.
Refer below article for using ExecuteReader in MySQL.