Click here to Skip to main content
15,904,817 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerFound Reference... Pin
Kasi Viswanathan25-Nov-07 22:55
Kasi Viswanathan25-Nov-07 22:55 
QuestionCrystal Report Problem Pin
Suryanairg23-Nov-07 17:49
Suryanairg23-Nov-07 17:49 
QuestionAutoComplete Pin
kirthikirthi23-Nov-07 17:38
kirthikirthi23-Nov-07 17:38 
AnswerRe: AutoComplete Pin
Michael Sync23-Nov-07 17:51
Michael Sync23-Nov-07 17:51 
GeneralRe: AutoComplete Pin
kirthikirthi23-Nov-07 18:43
kirthikirthi23-Nov-07 18:43 
GeneralRe: AutoComplete Pin
Imran Khan Pathan23-Nov-07 18:54
Imran Khan Pathan23-Nov-07 18:54 
GeneralRe: AutoComplete Pin
Michael Sync23-Nov-07 19:51
Michael Sync23-Nov-07 19:51 
GeneralRe: AutoComplete Pin
kirthikirthi30-Nov-07 20:28
kirthikirthi30-Nov-07 20:28 
Hi
I tried your code

The code working only for 1 textbox

I mean On Page Load

2 Textboxs calling not woring only 1 textbox calling is working

can u plz tell me a solution for my error

Or

Can u plz tell me is there any other way to do this in (2 or more DB autocomplete textboxes) 1.1 ver or VS 2005 ver



Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
AjaxPro.Utility.RegisterTypeForAjax(GetType(WebForm1))
AUTOCOMPLETE1.PageType = Me.[GetType]().BaseType
AUTOCOMPLETE1.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData)

acSearch.PageType = Me.[GetType]().BaseType
acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf GetSearchData00)
'Ca()

End Sub
<ajaxpro.ajaxmethod()> _
Function GetSearchData(ByVal s As String) As DataTable

Try
Dim conn As New SqlConnection(Global.constrSQ)
Dim cmd As New SqlCommand("SELECT MusicDirector FROM MusicDirector WHERE MusicDirector LIKE @MusicDirector + '%' ", conn)
cmd.Parameters.Add("@MusicDirector", s)
Dim da As New SqlDataAdapter
Dim ds As New DataSet

da.SelectCommand = cmd
da.Fill(ds, "MusicDirector")
Return ds.Tables("MusicDirector")
Catch ex As Exception

End Try

End Function
<ajaxpro.ajaxmethod()> _
Function GetSearchData00(ByVal s0 As String) As DataTable
Dim conn As New SqlConnection(Global.constrSQ)
Dim cmd As New SqlCommand("SELECT SingerName FROM Singer WHERE SingerName LIKE @SingerName + '%'", conn)
cmd.Parameters.Add("@SingerName", s0)
Dim da As New SqlDataAdapter
Dim ds As New DataSet
da.SelectCommand = cmd '============ erragaddalopala
da.Fill(ds, "Singer")
Return ds.Tables("Singer")
End Function


Keethi
GeneralRe: AutoComplete Pin
Michael Sync30-Nov-07 21:42
Michael Sync30-Nov-07 21:42 
GeneralRe: AutoComplete Pin
kirthikirthi30-Nov-07 23:09
kirthikirthi30-Nov-07 23:09 
Questionabout dropdownlist control in asp.net Pin
srinivasbau23-Nov-07 10:01
srinivasbau23-Nov-07 10:01 
AnswerRe: about dropdownlist control in asp.net Pin
Malcolm Smart23-Nov-07 10:52
Malcolm Smart23-Nov-07 10:52 
AnswerRe: about dropdownlist control in asp.net Pin
koolprasad200323-Nov-07 19:16
professionalkoolprasad200323-Nov-07 19:16 
Questionabout calander controlin asp.net Pin
srinivasbau23-Nov-07 9:58
srinivasbau23-Nov-07 9:58 
AnswerRe: about calander controlin asp.net Pin
Christian Graus23-Nov-07 10:52
protectorChristian Graus23-Nov-07 10:52 
GeneralRe: about calander controlin asp.net Pin
srinivasbau23-Nov-07 11:10
srinivasbau23-Nov-07 11:10 
GeneralRe: about calander controlin asp.net Pin
Christian Graus23-Nov-07 12:47
protectorChristian Graus23-Nov-07 12:47 
AnswerRe: about calander controlin asp.net Pin
pmarfleet23-Nov-07 11:23
pmarfleet23-Nov-07 11:23 
AnswerRe: about calander controlin asp.net Pin
Michael Sync23-Nov-07 17:33
Michael Sync23-Nov-07 17:33 
QuestionMySQL Membership Provider problem Pin
Bursh.23-Nov-07 6:48
Bursh.23-Nov-07 6:48 
AnswerRe: MySQL Membership Provider problem Pin
pmarfleet23-Nov-07 11:25
pmarfleet23-Nov-07 11:25 
QuestionGetTableData question Pin
Tesic Goran23-Nov-07 4:29
professionalTesic Goran23-Nov-07 4:29 
Questionajax and IE Pin
mohammad tavakoli23-Nov-07 4:04
mohammad tavakoli23-Nov-07 4:04 
AnswerRe: ajax and IE Pin
pmarfleet23-Nov-07 4:25
pmarfleet23-Nov-07 4:25 
AnswerRe: ajax and IE Pin
Christian Graus23-Nov-07 9:53
protectorChristian Graus23-Nov-07 9:53 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.