On Wed, Mar 31, 2010 at 12:20 PM, Pratiksha Saxena < [email protected]> wrote:
> Hi, > Is your web service working fine. > You have to uncomment this > [System.Web.Script.Services.ScriptService] > If still not works tell what the error comes. > > Pratiksha > > > > On Tue, Mar 30, 2010 at 8:49 PM, Mos <[email protected]> wrote: > >> Folks I am having difficulty with an autocomplete capability >> >> Searching a SQL 2008 with 80,000 records >> >> ===============Default.aspx Code============== >> >> <%@ Page language="C#"%> >> >> <%@ Import Namespace="System.Data.SqlClient" %> >> >> <%@ Register Assembly="AjaxControlToolkit" >> Namespace="AjaxControlToolkit" TagPrefix="cc1" %> >> >> <html> >> >> <head> >> >> <title id="titl" runat="server">AutoComplete Feature</title> >> >> </head> >> >> <body onload="document.forms[0].txtCliente.focus()"> >> >> <div align="center"> >> >> <form id="Form1" class=frm runat="server"> >> >> <asp:ScriptManager ID="ScriptManager1" runat="server" >> EnableScriptGlobalization="True" >> >> EnableScriptLocalization="true"> >> >> </asp:ScriptManager> >> >> <table border=0> >> >> <tr> >> >> <td>User:</td> >> >> <td> >> >> <asp:TextBox ID="txtCliente" runat="server" Width="140px" >> ToolTip="Type a few letters"></asp:TextBox> >> >> <cc1:AutoCompleteExtender ID="txtCliente_AutoCompleteExtender" >> runat="server" DelimiterCharacters="" >> >> Enabled="True" ServicePath="AutoComplete.asmx" >> ServiceMethod="GetMedicationList" >> >> TargetControlID="txtCliente" EnableCaching="true" >> MinimumPrefixLength="1" CompletionInterval="150"> >> >> </cc1:AutoCompleteExtender> >> >> </td> >> >> </tr> >> >> </table> >> >> </form> >> >> </div> >> >> </body> >> >> </html> >> >> ===============AutoComplete.asmx Code=============== >> >> namespace AJAXAutoComplete >> >> { >> >> /// <summary> >> >> /// Summary description for AutoComplete >> >> /// </summary> >> >> [WebService(Namespace = "http://tempuri.org/";)] >> >> [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] >> >> [ToolboxItem(false)] >> >> // To allow this Web Service to be called from script, using >> ASP.NET<http://asp.net/> >> AJAX, uncomment the following line. >> >> // [System.Web.Script.Services.ScriptService] >> >> public class AutoComplete : System.Web.Services.WebService >> >> { >> >> [WebMethod] >> >> public string HelloWorld() >> >> { >> >> return "Hello World"; >> >> } >> >> [WebMethod] >> >> public string[] GetMedicationList(string prefixText) >> >> { >> >> DataSet dtst = new DataSet(); >> >> string mConnString = >> ConfigurationManager.ConnectionStrings["Nova"].ConnectionString; >> >> SqlConnection wCnn = new SqlConnection(mConnString); >> >> //string strSql = "SELECT farmacia FROM Sucursal WHERE farmacia LIKE >> '" + prefixText + "%' "; >> >> string strSql = "SELECT MedicationName FROM DOCUMENTS_MEDICATIONS >> WHERE MedicationName LIKE '" + prefixText + "%' "; >> >> SqlCommand sqlComd = new SqlCommand(strSql, wCnn); >> >> wCnn.Open(); >> >> SqlDataAdapter sqlAdpt = new SqlDataAdapter(); >> >> sqlAdpt.SelectCommand = sqlComd; >> >> sqlAdpt.Fill(dtst); >> >> string[] cntName = new string[dtst.Tables[0].Rows.Count]; >> >> int i = 0; >> >> try >> >> { >> >> foreach (DataRow rdr in dtst.Tables[0].Rows) >> >> { >> >> cntName.SetValue(rdr["MedicationName"].ToString(), i); >> >> i++; >> >> } >> >> } >> >> catch (SqlException sqlEx) >> >> { >> >> Console.WriteLine(sqlEx.ToString()); >> >> } >> >> finally >> >> { >> >> wCnn.Close(); >> >> } >> >> return cntName; >> >> } >> >> } >> >> } >> >> ===========Web.Config=============== >> >> <connectionStrings> >> >> <add name="Nova" connectionString="Data Source=xxxx;Initial >> Catalog=BTNET;Persist Security Info=True;User >> ID=btnetsa;Password=password;" providerName="System.Data.SqlClient"/> >> >> </connectionStrings> >> >> >> -- >> To unsubscribe, reply using "remove me" as the subject. >> > >
