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 ...