display itemName in cbobox according to itemtype selected

Prem Thapa

12y1.3kVisual Basic .NET

I want to display ItemName according to selected ItemType stored in sql database.

example

Fruits

Apple
Mango
Orange

Vegetable

Onion
Ginger
Radish

Drinks

Vodka
Pepsi
Coco-cola

here ItemType are in bullet which contain ItemName are in number formate and I want to display the ItemName in combo-box according to selected ItemType from combo-box.Llike if user click Fruits in cboItemType then apple,mango,orange should be loaded cboItemType from database. Please help. . .

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shweta Lodha12y ago
Hi Lakshmanan ,
You responses are repeated more than 3 times. It seems something is wrong at your end :(
Lakshmanan Sethu Sankaranarayan12y ago
Hi Prem, fetch all the db values in a single shot and keep it in dataset and load it.
Lakshmanan Sethu Sankaranarayan12y ago
Hi Prem, fetch all the db values in a single shot and keep it in dataset and load it.
Lakshmanan Sethu Sankaranarayan12y ago
Hi Prem, fetch all the db values in a single shot and keep it in dataset and load it.
Lakshmanan Sethu Sankaranarayan12y ago
Hi Prem, fetch all the db values in a single shot and keep it in dataset and load it.
Lakshmanan Sethu Sankaranarayan12y ago
Hi Prem, fetch all the db values in a single shot and keep it in dataset and load it.
Shweta Lodha12y ago
Hello Prem,
Before providing the solution, I just want to tell you that on every combo box value change, it is not at all a good practice to hit database. I would suggest you to please change your design.