Re: How to Use Ajaxcontroltoolki autocomplete with database data
Hi mendhak,
sorry but, my problem isn't that. I can get the textbox text. problem is:
I have a key/value pair that gets returned to the autocomplete textbox.
I want it so that when a user selects an item from the autocomplete, i then get the corresponding value of that item for example:
Programmer has the id value of 6.
I can get that if value in javascript which i've posted. Assigning the value to a hidden field on the page is a problem. I need the clientid of the autocomplete. I then need the javascript function to run when an item is selected, and assign the value to the hidden textbox.
Re: How to Use Ajaxcontroltoolki autocomplete with database data
Hey,
If I had the choice, I would definitely use .Net over classic ASP, it is far superior!! So, if I were you, I wouldn't give up yet.
I still haven't fully grasped exactly what you are trying to do, so I don't think I can be much help without some more information. For instance, can you post some screen shots of what you are doing? I think that might help to visualize the problem.
Also, can you list the full requirements of what it is you are trying to do? It may be the case that there is another way to implement what you want, and it is just the case that the requirement has been lost along the way in this thread.
Re: How to Use Ajaxcontroltoolki autocomplete with database data
thanks gep13. I've attached a screenshot. My occupation textbox is attached to an autocompleteextender. When you select an item from the autocomplete textbox. the autocomplete textbox get's a key/value pair returned to it via a webservice:
Code:
Public Function GetOccupations(ByVal prefixText As String) As String()
'Dim OccList As New List(Of combodata)
Dim OccList As New List(Of String)
Using con As New MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("constr").ConnectionString)
Dim OccReader As MySqlDataReader
Dim occCmd As New MySqlCommand("SELECT occupationid,descr FROM occupations WHERE lcase(descr) like ?descr;", con)
occCmd.Parameters.AddWithValue("?descr", prefixText & "%")
con.Open()
OccReader = occCmd.ExecuteReader
While (OccReader.Read)
If Not OccReader.IsDBNull(1) Then
'OccList.Add(New combodata With {.ID = OccReader.Item(0), .Description = OccReader.Item(1)})
OccList.Add(AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(OccReader.GetString(1), OccReader.GetUInt32(0)))
End If
End While
con.Close()
OccReader.Close()
End Using
Return OccList.ToArray
the autocomplete extender calls a javascript function IAmSelected when a user selects an item:
so in javascript, if i do this when an item is selected:
The Function being IAmSelected is added as an event handler to the ItemSelected event on the flyout of the AutoCompleteExtender.
It gets the Arguments as are specified for the Eventhandlers of the ItemSelected Event in the AutoCompleteExtender's behavior.
function IAmSelected( source, eventArgs )
{
alert( " Key : "+ eventArgs.get_text() +" Value : "+eventArgs.get_value());
}
End Function
i get the key/value data.
Problem i am having is assigning that eventArgs.get_value to a hiddenfield. Because since all my controls are in a repeater and the page uses a master page, the controls get renamed like this:
If Not (ClientScript.IsClientScriptBlockRegistered("MyScript")) Then
ClientScript.RegisterClientScriptBlock(Me.GetType, "MyScript", "function IAmSelected( source, eventArgs ) { alert($get(<%= this.occupation.ClientID %>));}", True)
End If
but i get a script error. Why is this? trying this:
Re: How to Use Ajaxcontroltoolki autocomplete with database data
Also,
If you ARE wanting to maintain the structure that you currently have, then I would have thought that Sample 3 in the link that you provided would do exactly what you want.
Refactor the IAmSelected method to take in the ClientID as a parameter, and then use the $get method on the ID.
From what I can see, everything that you want to achieve is detailed on that page.
Re: How to Use Ajaxcontroltoolki autocomplete with database data
now i did this, added ' around the following:
Code:
'<%= this.occupation.ClientID %>'
ain't getting an error now. purpose of the javascript is to assign the selected items value to the hiddenfield. Haven't got there yet. I just do an alert to test if i get the value successfully. now i get null returned.
Re: How to Use Ajaxcontroltoolki autocomplete with database data
Okay, this still isn't going to work:
Code:
<%= this.occupation.ClientID %>
occupation is the ID of the TextBox that you have placed in your ASPX markup within the Repeater element, as a result, the ClientID is going to be different for each instance of the TextBox within the repeater. Does that make sense?
Have a look at usage 3 again in the link that you posted.
You are going to have to use the DataBound event of the repeater, find each instance of the occupation TextBox within the Repeater item, and then grab the clientID. From there, edit the OnClientItemSelected attribute of the AutoComplete extender to include the ClientID of the TextBox, such as:
Code:
OnClientItemSelected="IAmSelected(clientID)"
And then refactor the IAmSelected method to take a parameter, which you then do the $get on.
Re: How to Use Ajaxcontroltoolki autocomplete with database data
thanks again,
i tried this:
Code:
Protected Sub GuardianRepeater_ItemDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.RepeaterItemEventArgs) Handles GuardianRepeater.ItemDataBound
Dim t1 As TextBox = CType(e.Item.FindControl("occupation"), TextBox)
Dim ace As AjaxControlToolkit.AutoCompleteExtender = CType(e.Item.FindControl("OccAutoCompleteExtender"), AjaxControlToolkit.AutoCompleteExtender)
Const onClientClick As String = "IAmSelected('{0}')"
If (Not t1 Is Nothing) And (Not ace Is Nothing) Then
ace.OnClientItemSelected = String.Format(onClientClick, t1.ClientID)
End If
End Sub
i get an error saying "there is no source for the current location" on the red line. this is my javascript:
Code:
If Not (ClientScript.IsClientScriptBlockRegistered("MyScript")) Then
ClientScript.RegisterClientScriptBlock(Me.GetType, "MyScript", "function IAmSelected( source, eventArgs, obj ) { alert($get(obj));}", True)
End If
Re: How to Use Ajaxcontroltoolki autocomplete with database data
ok, true, but this is what i read:
Code:
The Function being IAmSelected is added as an event handler to the ItemSelected event on the flyout of the ACE.
It gets the Arguments as are specified for the Eventhandlers of the ItemSelected Event in the AutoCompleteExtender's behaior.
before I wasn't passing parameters. It just unherited it. How can I get those values
Re: How to Use Ajaxcontroltoolki autocomplete with database data
This one bugged me a lot so I sat here and made a whole sample. I've reproduced the same conditions as you - a repeater, a hidden field, returning key-value from the service, and javascript to handle the click.
Let's start with the page. Default.aspx. You can make a new project and copy along, you too gep.
Re: How to Use Ajaxcontroltoolki autocomplete with database data
WebService1.asmx.cs (copied from that link you posted)
Code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
namespace WebApplication2
{
/// <summary>
/// Summary description for WebService1
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
[System.Web.Script.Services.ScriptService]
public class WebService1 : System.Web.Services.WebService
{
[WebMethod]
public string[] GetCompletionList(string prefixText, int count)
{
if (count == 0)
{
count = 10;
}
if (prefixText.Equals("xyz"))
{
return new string[0];
}
Random random = new Random();
List<string> items = new List<string>(count);
for (int i = 0; i < count; i++)
{
char c1 = (char)random.Next(65, 90);
char c2 = (char)random.Next(97, 122);
char c3 = (char)random.Next(97, 122);
items.Add(AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(prefixText + c1 + c2 + c3, i.ToString()));
}
return items.ToArray();
}
}
}
Re: How to Use Ajaxcontroltoolki autocomplete with database data
Right, so what I'm doing is dynamically creating a 'corresponding' variable for javascript to pick up on. Your client method from the ACE is very limited. It can only do so much, so you have to sort of 'cheat'.
Run the page and it should work, and do a view source, you'll see...
We know what the ACE's ID is going to be in the client event, so we can 'figure out' the variable name by prefixing 'hiddenfieldfor' and then looking at that corresponding string value.
Get it? So that was probably all you needed but it was quite confusing.
Re: How to Use Ajaxcontroltoolki autocomplete with database data
Hi guys,
hope it wasn't swine flu.
mendhak, you are a master. Thank you so much for your time and effort. your code works perfectly. thanks also to gep13 for helping and not letting me give up. much appreciated.
Re: [RESOLVED] How to Use Ajaxcontroltoolki autocomplete with database data
one more thing guys. sorry. say for example I select an option from the list, example programmer, and my hiddenfield now has an id of 2. then I type in TestOccupation. Since this occupation does not exist, I need to set the hiddenfield to -1. Then in my save routine, if it is -1, i will make a new entry into the occupation table.
Re: [RESOLVED] How to Use Ajaxcontroltoolki autocomplete with database data
If the user selects something from the autocomplete list, you'll have a value in your hidden field. If the user types their own thing in, there'll be nothing in the hidden field... you can use that as a 'guide'. If the hidden field is empty, it's a new item.
Or, handle the textbox's onchange... and populate the hidden field.
Re: [RESOLVED] How to Use Ajaxcontroltoolki autocomplete with database data
If the user starts typing and then leaves the textbox, that fires the onchange. Now in the onchange, you don't really know whether the user selected something from the ACE or not. You can't look at the hidden field either - the hidden field might have been set previously. You can't make another hidden field for 'custom' text either because you won't know which one to take values from. Let's say you have hiddenField9 and hiddenFieldCustom9. In the ACE's click event, you can erase both hiddenFields and populate hiddenField9. But you're trying to cater to custom occupations. So user types in goatsmasher. In the onchange, you can't clear the other hidden field because onchange will be fired for either scenario.
You can't use onkeypress either - the user could see the ACE and type exactly what's in there and ignore it. You'll end up with duplicate custom occupations.
Instead, you'll need to go back to what we talked about originally - forget the ID coming back from the service. Don't rely on the ACE, use it to make the experience better.
When it's time to read from the textboxes, look at the text in the textbox, not a hidden field. Peform a lookup against the database, passing the string in and finding its ID. If there's no ID, then it's a brand new field, so add it.
Reply With Quote
. I can't believe how annoying .Net is. I'd rather do this in classic asp and use mootools.
,
)
.
. Thank you so much for your time and effort. your code works perfectly. thanks also to gep13 for helping and not letting me give up. much appreciated. 
