Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: VB.NET search
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 23:48pm
Edited 31-Jan-13 23: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
0 Maciej Los 295
1 OriginalGriff 273
2 Aajmot Sk 234
3 Marcin Kozub 205
4 Richard MacCutchan 200
0 OriginalGriff 7,903
1 Sergey Alexandrovich Kryukov 7,127
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,820

Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2014
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