troubleshooting Question

Gridview: show 2 rows even tho sp has more than 2 rows

Avatar of Camillia
CamilliaFlag for United States of America asked on
6 Comments1 Solution252 ViewsLast Modified:
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

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros