I have a database table includes information for events. I want to display envets by state. When I use the following sql statement, the events can be selected correctly. However, each event shows three times in listview. any suggestion?
<asp:ListView ID="lvEventsState" runat="server" DataSourceID="sdsGetCommunityEventsState" OnItemDataBound="lvEventsothercities_OnItemDataBound"
DataKeyNames="Id" GroupItemCount="2" GroupPlaceholderID="groupPlaceHolder1" ItemPlaceholderID="itemPlaceHolder1">
<LayoutTemplate>
<table width="100%">
<asp:PlaceHolder runat="server" ID="groupPlaceHolder1"></asp:PlaceHolder>
</table>
</LayoutTemplate>
<GroupTemplate>
<tr>
<asp:PlaceHolder runat="server" ID= ...
Go to the complete details ...