autocomplete extender how does it work

Subin Thomas

7y1.2k.NET

i have have taken project name and project code in a autocomplete textbox the code is given below when i type name it comes with respective code , i want to know how what is assigned in that textbox name or code because i want to give further function for code only

[System.Web.Script.Services.ScriptMethod()]
[System.Web.Services.WebMethod]
public static List GetSearch(string prefixText)
{
DataTable dt = new DataTable();
SqlConnection con = new SqlConnection(con_Vas);
SqlCommand cmd = new SqlCommand("SELECT [Employee Name]+'; '+[Employee Code] as Name FROM [HRPLK].[dbo].[View_EmployeeBasicInformation] where [Employee Name] like '%'+ @EmpName +'%' ");
cmd.Parameters.AddWithValue("@EmpName", prefixText);
cmd.Connection = con;
con.Open();
List employees = new List();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
while (sdr.Read())
{
employees.Add(sdr["Employee Code"].ToString());
}
}
con.Close();
return employees;
}

11 Replies

Know the answer? Post it — somebody with the same question will find it here.

Subin Thomas7y ago
how and where to use split in query ??
Salman Beg7y ago
Then put split. You can can use split (';'); and after that take the 2nd value.
Subin Thomas7y ago
i have retrived name and code in that textbox and when i click on submit button it should taee only code from the textbox for further operation
Salman Beg7y ago
Then retrieve both the values in the query. What do you want exactly?
Subin Thomas7y ago
hey salman
but i want to show name as well in the text box
Salman Beg7y ago
You can do like this, SqlCommand cmd = new SqlCommand("SELECT [Employee Code] as Name FROM [HRPLK].[dbo].[View_EmployeeBasicInformation] where [Employee Name] like '%'+ @EmpName +'%' ");
Subin Thomas7y ago
i am retriving two values in the textbox name and code of the employee on click i want to check the code and display info according to the code .

how will i only take the code from the textbox to generate further operations
Madan Shekar7y ago
based on your keyword sql query return the results.
you are using like logical operator in sql query .
The SQL Server LIKE is a logical operator that determines if a character string matches a specified pattern. A pattern may include regular characters and wildcard characters.
if it helps mark as answer
Salman Beg7y ago
Hey. First of all, you are calling the GetSearch function from client side using ajax call and in that you are passing prefixText. By using that prefixText you are retrieving all the data and again you are returning back to the ajax call. You can put breakpoint and can check how data is coming, retrieving and returning back. Thanks.
Subin Thomas7y ago
thanks madan
can you tell me that when i type 3 alphabet then only its showing the list before it was 2 can you tell me why is it so
"txtempsearch" runat="server" Width="300px"
                    CssClass="background" Height="23px"
                 >

                 "RequiredFieldValidator2" runat="server" ControlToValidate ="txtempsearch" ErrorMessage="*Enter Name" ForeColor="Red">


       "GetSearch" MinimumPrefixLength="1" CompletionInterval="10"
           EnableCaching="false" CompletionSetCount="10" TargetControlID="txtempsearch" ID="AutoCompleteExtender1"
           runat="server" FirstRowSelected="false">
Madan Shekar7y ago
hi subin

textbox autocompleted functionality .

hope you are calling the webservice "GetSearch" method throuh ajax cal on onchange event.

where ever you typed something on your text box through ajax cal "GetSearch" method will get contact with "prefixText".

usinh this "prefixText" keyword your are doing query with like operator , query returns matched records and it wil be display's in textbox