I have an external web service that has been created for me to allow me access to a db. How can I use the AJAX to connect to this web service?

If (count = 0) Then

           count = 10

       End If

       Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("App_Data/ExpImpdb.mdb") & ";"

       Dim adp As New System.Data.OleDb.OleDbDataAdapter("select * from cars WHERE RecMerk Like '" & prefixText & "%' ", strConn)

       Dim dt As New System.Data.DataTable

       adp.Fill(dt)

       Dim items As New List(Of String)

       For i As Integer = 0 To dt.Rows.Count

           Dim datafile

           datafile = UCase(dt.Rows(i).Item("RecMerk"))

           i += 1

           items.Add(datafile)

       Next

       Return items.ToArray()

From a beginner's viewpoint it wasn't obvious to me that when creating the webmethod, you can change the webmethod name as you like but the parameter names _must_ be prefixText and count (but maybe that's me being dumb)

It seems pretty easy to hook this up to a database using LINQ. If it's of any help, here's my code to query product names in Northwind, (assumes you've already made the linq to northwind class)

[WebMethod]

public string[] GetCompletionList(string prefixText, int count)

{

 // OBS! In real world, initialize this someplace else

 NorthwindDataContext Db = new NorthwindDataContext();

 var matches = from p in Db.Products

 where p.ProductName.StartsWith(prefixText)

 select p.ProductName;

 return matches.ToArray<string>();

}

I tried the code and is working fine but when I implemented URL rewriting its displaying a js error 'Syntax error' and the auto complete is not working its displaying results as undefined. If I remove the code

<asp:ScriptManager ID="ScriptManager1" runat="server">

   <Services>

       <asp:ServiceReference Path="AutoComplete.asmx" />

   </Services>

</asp:ScriptManager>

there is no js error. I'm using C# and the auto complete text box is filled from DB. How can I solve this issue. Please help.

Thanks

I have downloaded your VB code and try to run it on my computer, it does work in firefox but doesn't work in IE6 and up. The example about the autocomplete that is on Ajax Toolkit live page works with all platform. Any suggestion here?

Thanks

Jagar,

here is my code please help.

Dim dtst As DataTable

       Dim sqlconnection As SqlConnection = New SqlConnection("connectionstring")

       Dim objcmd As SqlCommand = New SqlCommand("select namefrom students where name like '" + prefixTex + "%' ", sqlconnection)

       sqlconnection.Open()

       Dim sqladpt As SqlDataAdapter = New SqlDataAdapter

       sqladpt.SelectCommand = objcmd

       sqladpt.Fill(dtst)

       Dim cntname As List(Of String)

       For i As Integer = 0 To dtst.Rows.Count

           Dim datafile

           datafile = UCase(dtst.Rows(i).Item("description"))

           i += 1

           cntname.Add(datafile)

       Next

       Return cntname.ToArray

thank you in advnace

dtatfile=ucase(dtst.rows(i).item("description")

should be

dtatfile=ucase(dtst.rows(i).item("name")

how can i show data in autocomplete list from northwind database in C#.I am a novice programmer.

Video is excellent. i want key/value pair, for example, if i select country name and value stored in the hidden field.

please let me how can i achive this.

Thanks

Gopi

I ported the code to my WebApp and it works as long as I enter the full url including port number (<a rel="nofollow" target="_new" href="http://localhost:6534/AutoComplete.asmx">localhost/AutoComplete.asmx</a>) as the ServicePath Attribute for the AutoComplete Control. Is it possible to let the webservice run on a specified port number, or how did you manage to ommit the portnumber in your examples?

bill

i had the same issue with key/value.

look here, it's easy:

<a rel="nofollow" target="_new" href="http://blogs.msdn.com/phaniraj/archive/2007/06/19/how-to-use-a-key-value-pair-in-your-autocompleteextender.aspx">blogs.msdn.com/.../how-to-use-a-key-value-pair-in-your-autocompleteextender.aspx</a>

I've followed the steps in the video, but I get an annoyingly vague JavaScript error on my .aspx page saying, simply that:

'Sys' is undefined.

When I view the source of the .aspx page, I find that the Sys assembly is indeed required, and it seems to initialise my ScriptManager, which contains the details of the WebService I've created. It looks like it's fundamental to the method, but the CDATA section seems to be auto-generated.

//<![CDATA[

Sys.WebForms.PageRequestManager._initialize('ScriptManager1 ', document.getElementById('form1'));

Sys.WebForms.PageRequestManager.getInstance()._updateContro ls([], [], [], 90);

//]]>

So my question is, how can I satisfy this auto-generated dependency on Sys.WebForms.PageRequestManager to make my page load without errors, and therefore be able to AutoComplete the text box?

graham

Is it possible to add an argument in the web service method?

How to pass value to the additional argument?

thank you

   public string[] GetCompletionList(string prefixText, int count)

   {

       if (count == 0)

       {

           count = 10;

       }

       List<string> items = new List<string>(count);

       SubSonic.StoredProcedure sp = new SubSonic.StoredProcedure("GetAllInfo");

       sp.Command.AddParameter("@pIn", "RIGHT");

       sp.Command.AddParameter("@sSearch", prefixText);

       DataSet ds = sp.GetDataSet();

       foreach (DataRow dr in ds.Tables[0].Rows)

       {

           items.Add(dr[0].ToString());

       }

       return items.ToArray();

   }

Great demo. Of course I got some problems with the whole AutoComplete extender.

I am try to use it in two places:

1. A master page and

2. on a web user control

I have followed your example step by step.  When I create a new project and run it, it does run fine.

The problem is when I try to implement it on my "real" project.

On the bottom of the browser (IE 7) I get the "warning message" when I double click on it it give me the following message:

"Error: Sys.ArgumentUndefineException: Value cannot be undefined. Paramenter Name: type"

Any ideas what is going on in here????

I would appreciate any help since I have been trying to add this functionality for a while now.....

Thanks in advance

Im trying to use this control on a webpart (user control) using a static method [webmethod], for some reason this does not work, the event never triggers. Is there a known issue about this extender and a user control or an issue implementing the method of the extender in a non webservise method???

Thanks in advance

bob