Click here to Skip to main content
16,004,727 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: What is better server.Transfer() or Response.redirect() Pin
John-ph23-Nov-07 21:15
John-ph23-Nov-07 21:15 
QuestionQuery Pin
Sunil Wise23-Nov-07 19:45
professionalSunil Wise23-Nov-07 19:45 
QuestionIs it possible to add mySql queries in aspx page Pin
Deepthy.P.M23-Nov-07 19:33
Deepthy.P.M23-Nov-07 19:33 
AnswerRe: Is it possible to add mySql queries in aspx page Pin
Michael Sync23-Nov-07 19:53
Michael Sync23-Nov-07 19:53 
QuestionHow to show data in EXCEL Sheet? Pin
Kasi Viswanathan23-Nov-07 19:11
Kasi Viswanathan23-Nov-07 19:11 
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 
Hi all

Iam working on autocomplete textbox.

in my code only 1 tetbox is working fine. but i want use 2 textbox as autocomplete (from DB)

when i write code for 2 textboxs only 1 textbox is working other is not displaying the data values

can any 1 tell me what is error on my code

iam using 1.1 ver.

MYCODE

--------------------

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

AjaxPro.Utility.RegisterTypeForAjax(GetType(WebForm1))
acSearch.PageType = Me.[GetType]().BaseType
acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData)

Autocomplete1.PageType = Me.[GetType]().BaseType
Autocomplete1.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData1)

End Sub

- AjaxPro.AjaxMethod() _
Public Function GetSearchData(ByVal s As String) As DataTable
Dim conn As New SqlConnection("server=;uid=;pwd=;database=")
Dim cmd As New SqlCommand("SELECT Name FROM IDs WHERE Name LIKE @Name + '%'", conn)
cmd.Parameters.Add("@Name", s)
Dim da As New SqlDataAdapter
Dim ds As New DataSet
da.SelectCommand = cmd
da.Fill(ds, "IDs")
Return ds.Tables("IDs")
End Function

- AjaxPro.AjaxMethod() _
Public Function GetSearchData1(ByVal s As String) As DataTable
Dim conn1 As New SqlConnection("server=;uid=;pwd=;database=")
Dim cmd1 As New SqlCommand("SELECT NameID FROM IDs WHERE NameID LIKE @NameID + '%'", conn1)
cmd1.Parameters.Add("@NameID", s)
Dim da1 As New SqlDataAdapter
Dim ds1 As New DataSet
da1.SelectCommand = cmd1
da1.Fill(ds1, "IDs")
Return ds1.Tables("IDs")
End Function
---------------------


THX


Keerthi
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 
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 

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.