Check these links Mukesh
http://www.codeproject.com/KB/aspnet/Ajax_in_VBNet___ASPNet.aspx
*
*
1. * Imports System*
2. * Imports System.IO*
3. * Imports System.Web*
4. * Imports System.Web.Services*
5. * Imports System.Web.Services.Protocols*
6. * Imports System.Collections*
7. * Imports System.Collections.Generic*
8. * Imports System.Threading*
9. * Imports System.Xml.Serialization*
10. * Imports System.Data.Common*
11. * Imports System.Data ' VB.NET*
12. * Imports Oracle.DataAccess.Client*
13. * *
14. * <WebService(Namespace:="http://tempuri.org/")> _*
15. * <WebServiceBinding(ConformsTo:=WsiProfiles.BasicPro file1_1)> _*
16. *<Global.Microsoft.VisualBasic.CompilerServices.Desi gnerGenerated()> _
*
17. * <System.Web.Script.Services.ScriptService()> _*
18. * Public Class AutoCompleteDAL*
19. * Inherits System.Web.Services.WebService*
20. * Public Shared autoCompleteWordList As String()*
21. * *
22. * *
23. * <WebMethod()> _*
24. * Public Function GetCompletionList(ByVal prefixText As
String, ByVal count As Integer) As String()
*
25. * *
26. * Dim Sql As String = "SELECT NAME from NAMELIST WHERE
NAME LIKE '" & prefixText & "' || '%' ORDER BY NAME ;"
*
27. * Dim Conn As New _*
28. *
OracleClient.OracleConnection(ConfigurationManager
.ConnectionStrings( _
*
29. * "OrdConnectionString").ConnectionString)*
30. * ' Dim Conn As OracleConnection = New
OracleConnection("Data Source=dbHazard;User
ID=HazUser;Password=password")
*
31. * ' Dim cmd As New OracleCommand(Sql, Conn)*
32. * Dim cmd As New OracleClient.OracleCommand(Sql, Conn)*
33. * Dim items As New List(Of String)*
34. * Dim dr As OracleClient.OracleDataReader = cmd.ExecuteReader() '
VB.NET*
35. * While dr.Read() ' VB.NET*
36. * items.Add(dr.Item("NAME"))*
37. * End While*
38. * *
39. * 'items.Add(dr.Item("NAME"))*
40. * Return items.ToArray*
41. * *
42. * *
43. * *
44. * End Function*
45. * *
46. * *
47. * End Class*
--
@NiL KuMaR
VivaCity Infotech
