comboBox- data bound item

Question

Hi :) I have a comboBox and I used the option Use Data Bound Items. I've set the Data Source, the Display Member and Value Member, but I need the comboBox to contain only the clients whose name begins with 'RO'. I've tried to use a Query but it's not correct and I don't know how to do it. Here's the query used:

SELECT denumire FROM dbo.client WHERE denumire.Substring(1,2)='RO'. I know that i should use parameters but i don't know how. Some help?

Answer 1

Try:

SELECT denumire FROM dbo.client WHERE UPPER(SUBSTRING(denumire, 1, 2)) = 'RO'

Answer 2

Thanks, it worked. I have one more question, using DataBound and Query creates a Fillby ToolStrip and the comboBox is filled only when I click on the Fillby Tool. Is there a way to fill automatically the combobox? when form loads or something like that?

Answer 3

thanks, but still doesn't work, now doesn't display anything :(

Answer 4

Hello Friend,
            Just replace your query with the following

SELECT denumire FROM dbo.client WHERE denumire like 'RO'.


Hope that solves your problem.


With Regards,
Vishal Gilbile