Web Forms :: Autocomplete TextBox With Data From A SQL Server?
Feb 9, 2011
im new at asp. net and im making a web page with 3 dropdownlist filtering DATA, and then i display a Gridview with the data selected. But i also have some TextBoxs and i want them to autocomplete according to the filters i previously selected. Im working all of this with no code behind.
public class WebService : System.Web.Services.WebService { MySql.Data.MySqlClient.MySqlCommand cmd = new MySqlCommand(); MySql.Data.MySqlClient.MySqlConnection con = new MySqlConnection(); //MySqlDataAdapter da = new MySqlDataAdapter(); MySqlDataReader dr; public WebService () { //Uncomment the following line if using designed components //InitializeComponent(); } [WebMethod] public string[] GetCountryInfo(string prefixText) { int count = 10; string sql = "Select * from tbl_patientmaster Where P_NAME like '" + @prefixText + "%'"; con.ConnectionString = System.Configuration.ConfigurationManager.AppSettings["HMSDBConnectionString"].ToString(); con.Open(); MySql.Data.MySqlClient.MySqlDataAdapter da = new MySql.Data.MySqlClient.MySqlDataAdapter(sql, con); da.SelectCommand.Parameters.Add("@prefixText", MySql.Data.MySqlClient.MySqlDbType.VarChar, 50).Value = prefixText + "%"; System.Data.DataTable dt = new System.Data.DataTable(); da.Fill(dt); string[] items = new string[dt.Rows.Count]; int i = 0; foreach (System.Data.DataRow dr in dt.Rows) { items.SetValue(dr["P_NAME"].ToString(), i); i++; } return items; }
Having a problem with autocomplete I put autocomplete control with textbox For data to be retrieved from database, I am putting .asmx file and .cs file for that Now I am giving .asmx file path in autocomplete. asmx file contains path for .cs file If this is the situation, autocomplete dont work and in .cs file , event is not fired.
But if i put that event from .cs file directly into the codebehing file of that control, then it works ok
How can i call an event in .cs file that is placed inside a app_code folder seperately from .aspx and .cs file of the autocomplete control
I have following requirements . On the search results associated with my autocomplete textbox i need checkbox to be associate with the result data . So that the end user can select multiple selection at a go .
i am using JQuery UI Autocomplete with asp.net textbox.AutoComplete works right.but how can i assign selected ID of returned Data to an hiddenField?My server Side Function returned list of objects that contains (this is an example) :
public List<Employee> GetEmployeeList() { List<Employee> empList = new List<Employee>(); empList.Add(new Employee() { ID = 1, Email = "Mary@somemail.com" }); empList.Add(new Employee() { ID = 2, Email = "John@somemail.com" }); empList.Add(new Employee() { ID = 3, Email = "Amber@somemail.com" }); empList.Add(new Employee() { ID = 4, Email = "Kathy@somemail.com" }); empList.Add(new Employee() { ID = 5, Email = "Lena@somemail.com" }); empList.Add(new Employee() { ID = 6, Email = "Susanne@somemail.com" }); empList.Add(new Employee() { ID = 7, Email = "Johnjim@somemail.com" }); empList.Add(new Employee() { ID = 8, Email = "Jonay@somemail.com" }); empList.Add(new Employee() { ID = 9, Email = "Robert@somemail.com" }); empList.Add(new Employee() { ID = 10, Email = "Krishna@somemail.com" }); return empList; } and this is ASPX Code : <form id="form1" runat="server"> <div class="demo"> <div class="ui-widget"> <label for="tbAuto"> Enter Email: </label> <asp:TextBox ID="tbAuto" class="tb" runat="server"> </asp:TextBox> </div> </div> <asp:TextBox ID="TextBox1" runat="server"> </asp:TextBox> <asp:Label runat="server" ID="lbl" Text=""></asp:Label> <asp:HiddenField runat="server" ID="hidid" /> <asp:Button ID="Button1" runat="server" Text="Button" /> </form>
here is my jquery Code :
<script type="text/javascript"> $(function () { $(".tb").autocomplete({ select: function( event, ui ) { // now assign the id of the selected element into your hidden field $("#<%= hidid.ClientID %>").val( ui.item.ID ); }, source: function (request, response) { $.ajax({ url: "Default.aspx/FetchEmailList", data: "{ 'mail': '" + request.term + "' }", dataType: "json", type: "POST", contentType: "application/json; charset=utf-8", dataFilter: function (data) { return data; }, success: function (data) { response($.map(data.d, function (item) { return { value: item.Email } } ) ) } , error: function (XMLHttpRequest, textStatus, errorThrown) { alert(textStatus); alert(errorThrown); } }); }, minLength: 1 }); }); </script>
And this is My WEb Method Side Code :
<WebMethod()> _ Public Shared Function FetchEmailList(ByVal mail As String) As List(Of Employee) Dim emp = New Employee() Dim fetchEmail = emp.GetEmployeeList() Return fetchEmail End Function
I am using autocomplete jquery textbox in gridview , for first time when grid view is binded autocomplete jquery textbox works , when new row is dynamically added with textbox, the code is not working
I am trying to use j-query autocomplete but i am getting this error: "The name 'txt_UID' does not exist in the current context" ..
I am using the code but the example I was following uses a text-box that was outside of the gridview. But my textbox is inside the gridview.
How can I make the autocomplete to work a text-box that is inside gridview?
-- Here is my javascript <script type="text/javascript"> $(document).ready(function () { $("#<%=txt_UID.ClientID %>").autocomplete({ source: function (request, response) {
[Code] .....
-- and here is my gridview: <asp:GridView ID="GridView1" runat="server" Width="870px" AutoGenerateColumns="False" Font-Names="Arial" Font-Size="11pt" AlternatingRowStyle-BackColor="#C2D69B" HeaderStyle-BackColor="green" ShowFooter="True" CellPadding="4" BackColor="White" BorderColor="#336666"
One thing I really love about web browsers, is the autocomplete feature they have for different controls, like textboxes in forms. However, some times users get confused with the dropdown appearing. So, we would like to be able to disable the autocomplete feature for some textboxes on some of our ASP.NET WebForms pages. Isn't there a property which controls that? Or is that done through JavaScript?
I want use auto complete TextBox and multi select drop down list. If multi select drop down list worked auto complete TextBox show result in top. If auto complete TextBox worked multi select drop down list not worked. It’s my result but not my requirement. I shared code below but not my requirement.
I would like to give a TextBox in a custom WebPart the ability to AutoComplete on user entry. I am NOT allowed to use the AjaxControlLibrary OR the AjaxControlToolkit. (don't ask... that's just how it is.) Obviously, the TextBox will be instantiated within an UpdatePanel; but how would I go about the rest of this as simply as possible? I would like to be able to pull my list of items for the AutoComplete feature from three potential sources: database, web service, or collection object.
I need to implement an auto complete feature and found posting on the Web that text box will do the job using ajax extender. Do I need to create a new website ASP.NET Ajax-Enabled or can I use my current ASP application? Or is there a better way to approach this using some other methods? [URL]
I've been stymied for a few days on and interface issue with Autocompleteextender and a simple textbox. Is the user types in the textbox while the scroll position of the page is near the top, the autocomplete pops under the textbox, just like it should.However, when I scroll down a little, the autocomplete pops over top of the textbox, making it impossible to see what you are typing. How do I force the autocomplete to pop under the textbox no matter the scroll position of the page? My code is below:
I am using an autocomplete in textbox and the values are from database.It is working fine.What i need is to do this autocomplete thing in listview when i enter any value in textbox. Here is my code
So I got a textbox with an autocomplete source pulled from a database. I am using the follow code to fill the Autocomplete.
txtResource.AutoCompleteCustomSource.AddRange((From row In myComputers.Resources Where row.Active = True And row.ResourceTypeID = CBOResourceType.SelectedValue Select row.Resource).ToArray)
What I would like to do is autocomplete for items in the middle of the search term.For example I have, "Cat","Dog","Dog Horse", "Cat Fish", "Horse Fly"
When I type in Cat my results are: Cat and Cat Fish When I type in Horse my results are: Horse Fly
I want the results for Horse to be: Dog Horse and Horse Fly. How can I do this?