Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB.NET search
Hi,

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

Application:
VB.NET
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.

Regards,
Posted 31-Jan-13 23:48pm
Edited 31-Jan-13 23:49pm
v2

1 solution

Rate this: bad
good
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[^]
  Permalink  

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 184
1 Sascha Lefévre 120
2 Abhinav S 104
3 Richard MacCutchan 90
4 Sergey Alexandrovich Kryukov 84
0 Sergey Alexandrovich Kryukov 6,628
1 OriginalGriff 6,298
2 Peter Leow 2,534
3 Maciej Los 2,492
4 Abhinav S 2,378


Advertise | Privacy | Mobile
Web03 | 2.8.150414.1 | Last Updated 1 Feb 2013
Copyright © CodeProject, 1999-2015
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