Click here to Skip to main content
Licence 
First Posted 8 Mar 2003
Views 39,002
Bookmarked 17 times

List Of Values with Search Capability

By | 8 Mar 2003 | Article
ExpertSearch Can be used to get value from a list Like Combobox but with ComboBox we can see one value at a time no special searching/filtering is available , with this component you can just call the execute function passing it SQL, Connection and the Column Number you want to retrive value
 
Part of The SQL Zone sponsored by
See Also

Sample Image - ExpertSearch.jpg

Introduction

 Some time there is a need to select value from a list of values for that generaly we use combobox but combobox can only display one value and dosent have good searching/filtering capabilities.

 I have written this component to select value from a list but this component can show number of fields and also includes searching/filtering capabilites.

 We Just have to Call the Execute Function with the SQL Query String,  Connection Object (Connection Should be Open and can use SQL or OLEDB provider ) and Column Number which value you want to retrieve.

 Download the sample and see the work yourself.

 

 

 

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Noordin



United Kingdom United Kingdom

Member



Sign Up to vote   Poor Excellent
Add a reason or comment to your vote: x
Votes of 3 or less require a comment

Comments and Discussions

 
You must Sign In to use this message board. (secure sign-in)
 
Search this forum  
 FAQ
    Noise  Layout  Per page   
  Refresh
-- There are no messages in this forum --
Permalink | Advertise | Privacy | Mobile
Web02 | 2.5.120517.1 | Last Updated 9 Mar 2003
Article Copyright 2003 by Noordin
Everything else Copyright © CodeProject, 1999-2012
Terms of Use
Layout: fixed | fluid