Please look at output below.
On the page, I have a listview and a dropdown list
1. I bind column "hcProvider" to listview. This is ok.
2. I bind businessName colum to a dropdownList but I need to show only 2 rows but it shows 5
3. Gridview should have 2 rows but has 5 because I have 5 rows from stored proc
See attached screenshot of how it looks like
So, I need to show 2 rows because I have "Test Business33" and "Username test" as BusinessName. Dropdownlist needs to show 2 businessnames. Listview is good.
How can I show 2 rows and bind to gridview when stored proc has 5 rows?
If there's no solution to this, I'll talk to my manager
Id businessName hcId HCproviderName
3 Test Business33 18 Behnaz Wafa
3 Test Business33 1 Bob1 Jones
3 Test Business33 11 pp333 ppp
3 Test Business33 16 yy fff
39 Username test 12 officer 1 llll