65.9K
CodeProject is changing. Read more.
Home

List Of Values with Search Capability

starIconstarIcon
emptyStarIcon
starIcon
emptyStarIconemptyStarIcon

2.56/5 (9 votes)

Mar 9, 2003

viewsIcon

44894

downloadIcon

1468

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

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.