I have 1 combo box whitch data source is a data base... but some item's of combo are duplicated... but i want only 1 item of eatch type like: (Monitor / Printer / Scanner / Printer), i would like remove second printer... i need do that on combo properties or on data base connection (combo <---> DB)
sorry my english...
Combo Box Problem.... i need a "light"....
Hot Topic
- Creation of a PDF file.
- Using ContextMenus with AxHost'ed ActiveX Controls
- FaxServer problems.
- A complex coding for me
- Missing Component Designer Generated Code
- MPEG Music
- How do I ADD A NEW DATA SOURCE ????? - ERROR MESSAGE included.
- Displaying data of an Access database in a Datagrid
- DataGridView - Can Columns be displayed Horizontal instead of Vertical?
- Object array and refference
Visual Basic
- How to make slideshow transition with Picturebox
- set RelativeX and RelativeY on Multi display systems
- How can i that one of function's parameters will be null/defult?
- Receive Email in .Net
- ComboBox/DateTimePickerBox drop down arrow visible/invisible
- Enumerate class properties?
- Sending email in vb2005
- Read records from one table and insert ID into another problem
- vertical gridview
- HElp on how to open a form through VB.Net
Combo Box Problem.... i need a "light"....
Rajen Suchede
SELECT DISTINCT PeripheralName FROM SystemTable
Here's the long answer. There should be a table that already has a distinct list of peripherals. (You should create one, if it doesn't already exist.) So, the real answer is to use this table as the source of your combo box. Using your example above, you'd have a Peripheral table with three records, one each for "Monitor", "Printer", and "Scanner". No need to do a DISTINCT and you have a better designed database.
Hope this helps.
- Mitchell S. Honnert