{"id":128518,"date":"2023-05-08T11:15:12","date_gmt":"2023-05-08T05:45:12","guid":{"rendered":"https:\/\/www.vskills.in\/certification\/tutorial\/?page_id=128518"},"modified":"2024-04-12T14:15:27","modified_gmt":"2024-04-12T08:45:27","slug":"creating-the-data-lookup-web-service","status":"publish","type":"page","link":"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/","title":{"rendered":"Creating the Data Lookup Web Service"},"content":{"rendered":"\n

Creating the Data Lookup Web Service<\/strong><\/h4>\n\n\n\n

To implement AutoComplete functionality in an ASP.NET application, you need to create a web service or a page method that returns a list of suggested items based on the user input. Here are the steps to create a web service:<\/p>\n\n\n\n

In Visual Studio, create a new ASP.NET Web Application project.<\/p>\n\n\n\n

Right-click on the project in Solution Explorer and select Add -> New Item.<\/p>\n\n\n\n

Select Web Service from the list of templates and name the file “AutoComplete.asmx”.<\/p>\n\n\n\n

Open the “AutoComplete.asmx” file and add a new web method that will be called by the AutoComplete extender control. For example:<\/p>\n\n\n\n[WebMethod]\n\n\n\n

public string[] GetAutoCompleteData(string prefix)<\/p>\n\n\n\n

{<\/p>\n\n\n\n

    List<string> results = new List<string>();<\/p>\n\n\n\n

    \/\/ TODO: Query the database or data source to get a list of suggested items<\/p>\n\n\n\n

    \/\/ based on the prefix string.<\/p>\n\n\n\n

    return results.ToArray();<\/p>\n\n\n\n

}<\/p>\n\n\n\n

In the web method, query the database or data source to get a list of suggested items based on the prefix string. You can use LINQ to SQL, Entity Framework, or any other data access technology to retrieve the data. For example:<\/p>\n\n\n\n

NorthwindDataContext db = new NorthwindDataContext();<\/p>\n\n\n\n

var query = from c in db.Customers<\/p>\n\n\n\n

            where c.CompanyName.StartsWith(prefix)<\/p>\n\n\n\n

            select c.CompanyName;<\/p>\n\n\n\n

results.AddRange(query);<\/p>\n\n\n\n

Convert the list of suggested items to an array of strings and return it from the web method.<\/p>\n\n\n\n

return results.ToArray();<\/p>\n\n\n\n

Save the “AutoComplete.asmx” file and build the project.<\/p>\n\n\n\n

Once you have created the web service, you can bind it to the AutoComplete extender control by setting its ServicePath and ServiceMethod properties. For example:<\/p>\n\n\n\n

<ajaxToolkit:AutoCompleteExtender ID=”autoComplete1″ runat=”server”<\/p>\n\n\n\n

    TargetControlID=”txtSearch”<\/p>\n\n\n\n

    ServicePath=”~\/AutoComplete.asmx”<\/p>\n\n\n\n

    ServiceMethod=”GetAutoCompleteData”<\/p>\n\n\n\n

    MinimumPrefixLength=”2″<\/p>\n\n\n\n

    CompletionInterval=”1000″<\/p>\n\n\n\n

    CompletionSetCount=”10″><\/p>\n\n\n\n

<\/ajaxToolkit:AutoCompleteExtender> In this example, the ServicePath property is set to “~\/AutoComplete.asmx”, which specifies the path to the web service file. The ServiceMethod property is set to “GetAutoCompleteData”, which specifies the name of the web method that returns the list of suggested items. The MinimumPrefixLength property is set to “2”, which specifies the minimum number of characters that the user must enter before the AutoComplete feature is activated. The CompletionInterval property is set to “1000”, which specifies the delay in milliseconds before the AutoComplete list is displayed. The CompletionSetCount property is set to “10”, which specifies the maximum number of items that can be displayed in the AutoComplete list.<\/p>\n\n\n\n

Apply for ASP.NET Certification Now!!<\/h3>\n\n\n\n

https:\/\/www.vskills.in\/certification\/certified-aspnet-programmer<\/a><\/p>\n\n\n\n

Back to Tutorial<\/a><\/strong><\/h4>\n","protected":false},"excerpt":{"rendered":"

Creating the Data Lookup Web Service To implement AutoComplete functionality in an ASP.NET application, you need to create a web service or a page method that returns a list of suggested items based on the user input. Here are the steps to create a web service: In Visual Studio, create a new ASP.NET Web Application…<\/p>\n","protected":false},"author":22,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[3339],"tags":[],"class_list":["post-128518","page","type-page","status-publish","hentry","category-asp-net-2"],"acf":[],"yoast_head":"\nCreating the Data Lookup Web Service - Tutorial<\/title>\n<meta name=\"description\" content=\"Creating the Data Lookup Web Service\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating the Data Lookup Web Service - Tutorial\" \/>\n<meta property=\"og:description\" content=\"Creating the Data Lookup Web Service\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutorial\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/vskills.in\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-12T08:45:27+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/\",\"name\":\"Creating the Data Lookup Web Service - Tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\"},\"datePublished\":\"2023-05-08T05:45:12+00:00\",\"dateModified\":\"2024-04-12T08:45:27+00:00\",\"description\":\"Creating the Data Lookup Web Service\",\"breadcrumb\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating the Data Lookup Web Service\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#website\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"name\":\"Tutorial\",\"description\":\"Vskills - A initiative in elearning and certification\",\"publisher\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#organization\",\"name\":\"Vskills\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"contentUrl\":\"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg\",\"width\":73,\"height\":55,\"caption\":\"Vskills\"},\"image\":{\"@id\":\"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/vskills.in\/\",\"https:\/\/x.com\/vskills_in\",\"https:\/\/www.linkedin.com\/company-beta\/1371554\/\",\"https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating the Data Lookup Web Service - Tutorial","description":"Creating the Data Lookup Web Service","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/","og_locale":"en_US","og_type":"article","og_title":"Creating the Data Lookup Web Service - Tutorial","og_description":"Creating the Data Lookup Web Service","og_url":"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/","og_site_name":"Tutorial","article_publisher":"https:\/\/www.facebook.com\/vskills.in\/","article_modified_time":"2024-04-12T08:45:27+00:00","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/","name":"Creating the Data Lookup Web Service - Tutorial","isPartOf":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website"},"datePublished":"2023-05-08T05:45:12+00:00","dateModified":"2024-04-12T08:45:27+00:00","description":"Creating the Data Lookup Web Service","breadcrumb":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/creating-the-data-lookup-web-service\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.vskills.in\/certification\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Creating the Data Lookup Web Service"}]},{"@type":"WebSite","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#website","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","name":"Tutorial","description":"Vskills - A initiative in elearning and certification","publisher":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.vskills.in\/certification\/tutorial\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#organization","name":"Vskills","url":"https:\/\/www.vskills.in\/certification\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","contentUrl":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-content\/uploads\/2017\/07\/vskills-min-logo.jpg","width":73,"height":55,"caption":"Vskills"},"image":{"@id":"https:\/\/www.vskills.in\/certification\/tutorial\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/vskills.in\/","https:\/\/x.com\/vskills_in","https:\/\/www.linkedin.com\/company-beta\/1371554\/","https:\/\/www.youtube.com\/channel\/UCMWnscxPwRF_PqXo9B7q_Tw"]}]}},"_links":{"self":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128518","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/comments?post=128518"}],"version-history":[{"count":4,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128518\/revisions"}],"predecessor-version":[{"id":128523,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/pages\/128518\/revisions\/128523"}],"wp:attachment":[{"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/media?parent=128518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/categories?post=128518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vskills.in\/certification\/tutorial\/wp-json\/wp\/v2\/tags?post=128518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}