Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>My answer is built based on an asp.net 3.5 solution and jQuery 1.7.1 version assumption. Much has been already covered by other posters. Yours may vary by version. This is simply an attempt to put comments in an answer with a completed script and server side notes.</p> <p>Have you decorated your class thus:</p> <pre><code>[WebService(Namespace = "http://mysite.com/researcher_list/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] [ToolboxItem(false)] [ScriptService] public class researcher_list : WebService { </code></pre> <p>Decorate your method: (use the EnableSession IF you need that...)</p> <pre><code>[WebMethod(EnableSession = true)] public List&lt;DBResearcher.Summary&gt; FetchResList(string resName) { </code></pre> <p>cleanup of the client script:</p> <pre><code>$('input:text').autocomplete({ source: function(request, response) { var pString = '{ "resName": "' + request.term + '" }'; $.ajax({ url: "researcher_list.asmx/FetchResList", /* same root as the page? */ data: pString, dataType: "jsond", type: "POST", contentType: "application/json", /* simplify */ converters: { /* avoid the d or no d issue, works with 3.5 or prior this way */ "json jsond": function(msg) { return msg.hasOwnProperty('d') ? msg.d : msg; } }, success: function(data) { /* assumes data always returned and it IS called item in the JSON */ response($.map(data, function(item) { return { value: item.name, label: item.name }; })); }, minLength: 2, error: function(xhr, textStatus, errorThrown) { var errorMessage = "Ajax error: " + this.url + " : " + textStatus + " : " + errorThrown + " : " + xhr.statusText + " : " + xhr.status; if (xhr.status != "0" || errorThrown != "abort") { alert(errorMessage); } } }); } }); </code></pre> <p>IN ADDITION to the above, there are Web.config settings in asp.net that need set to get a web service to function - assumption here is you have done the research and have that working. IF NOT, suggestion is create a simple method that returns the current time as a string with NO parameters (data:"{}",) and get that via ajax to ensure it works before the complexity of the autocomplete is layered.</p>
    singulars
    1. This table or related slice is empty.
    1. POjQuery Autocomplete with C# and SQL Server Database
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMark Schultheiss
    1. USMark Schultheiss
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POjQuery Autocomplete with C# and SQL Server Database
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI checked config file many times.. Everything seems to be in the order.. The script above is giving me the missing bracket error. I added the missing bracket but its still there. May be I am messing on syntax? P.S. - The asmx file is already decorated
      singulars
      1. PO
      1. USBhrugesh Patel
    2. COI got the missing bracket error.. I ended up putting a semi-colon with it thinking its from one level above... but the error if (typeof(Sys) === 'undefined') throw new Error('ASP.NET Ajax client-side framework failed to load.'); is still there though... which in turn I believe, gives this error "Ajax error: researcher_list.asmx/FetchResList : error : undefined : Internal Server Error : 500"
      singulars
      1. PO
      1. USBhrugesh Patel
    3. COI ran the script snippet through jslint and fixed a couple of minor issues with my typing.
      singulars
      1. PO
      1. USMark Schultheiss
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload