Posted on: 3/19/2014 8:21:36 PM | Views : 402

I have a GridView attached to a datasource that until yesterday was working fine (GridView and DataSource below).  When my page is displayed (user control embedded in a page), I used to see multiple locations in the GridView.  This problem seemed to have cropped up out of nowhere a day ago.  When I run a SELECT manually in Sql Server I get the multiple locations back which should be displayed in the gridview. Only one is displayed.  What's going on?
<asp:SqlDataSource ID="dsLocations" runat="server" ProviderName="System.Data.SqlClient" ConnectionString="<%$ ConnectionStrings:NMHITDB %>" SelectCommand="SELECT locationUid, locationName, isPrimary, addressLine1, addressLine2, city, stateProvince, postalCode FROM locations WHERE organizationUid = @organizationUid ORDER BY locationName"> <SelectParameters> ...

Go to the complete details ...