Click here to Skip to main content
13,505,369 members
Rate this:
Please Sign up or sign in to vote.
See more:

I want to create a user control, but could use some advise for the best approach.

SQL 2005
Tables: For example: PRODUCTS TABLE with following fields:
ID, Name, SupplierID (FK), CategoryID (FK) Comments, Price, ...

Required functionality:
Search box, like google, autosuggest dropdown list.
Search should go trough all text fields, including Foreign tables
The searchbox should display the product name and be able to return the ID from the product.

I could use some advise on what controls to use and how to get the best user experience.

Posted 31-Jan-13 22:48pm
Updated 31-Jan-13 22:49pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Have a look here[^] - In particular the response from XspiritO has links to other suggestions. Hopefully you'll be able to get the gist of a solution despite most of the examples being in C#.

There is also this[^] CodeProject article specifically for VB.NET

In terms of searching the database have a look at fulltextsearch[^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.180417.1 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100