robinh583
asked on
GridView Disappears When I do a Sort
I have a gridview that disappears when I try to sort by one of the columns. I can't see if there's a problem in the code. Everything seems to be ok to me, but that must be wrong since I'm still having this problem.
I just tried to bring up another gridview which was working and sorting fine before, but now that one is having the same problem. When I click on the column header to sort, the grid disappears. Do you know of any issue or property or setting in IE 6 that might cause a scenerio like that.
If it helps, here's the ASP for the gridview and the SqlDataSource. Let me know if you see anything amiss that I did not notice.
Thank you,
Craig Newman
<asp:GridView ID="grdDiarySearch" runat="server" AllowSorting="True" AutoGenerateColumns="False "
CellPadding="1" DataSourceID="sdsDiarySear ch" GridLines="None" Width="95%" DataKeyNames="DIARY_SEQ_NO ">
<Columns>
<asp:CommandField ShowSelectButton="True" >
<Itemstyle CssClass="tabStripBodyBord er"/>
<HeaderStyle CssClass="tableBodyHilight Full"/>
</asp:CommandField>
<asp:BoundField DataField="BROKER_NAME" HeaderText="Broker Name" SortExpression="BROKER_NAM E" >
<Itemstyle CssClass="tabStripBodyBord er" HorizontalAlign=Left/>
<HeaderStyle CssClass="tableBodyHilight Full"/>
</asp:BoundField>
<asp:BoundField DataField="BC_NAME" HeaderText="Rep/Analyst" SortExpression="BC_NAME" >
<Itemstyle CssClass="tabStripBodyBord er" HorizontalAlign=Left/>
<HeaderStyle CssClass="tableBodyHilight Full"/>
</asp:BoundField>
<asp:BoundField DataField="OTHER_CONTACT" HeaderText="Other Analyst" SortExpression="OTHER_CONT ACT">
<Itemstyle CssClass="tabStripBodyBord er" HorizontalAlign=Left/>
<HeaderStyle CssClass="tableBodyHilight Full"/>
</asp:BoundField>
<asp:BoundField DataField="STRATEGY" HeaderText="Prod/Strategy" SortExpression="STRATEGY" >
<Itemstyle CssClass="tabStripBodyBord er" HorizontalAlign=Left/>
<HeaderStyle CssClass="tableBodyHilight Full"/>
</asp:BoundField>
<asp:BoundField DataField="INTERACTION" HeaderText="Service" SortExpression="INTERACTIO N" >
<Itemstyle CssClass="tabStripBodyBord er" HorizontalAlign=Left/>
<HeaderStyle CssClass="tableBodyHilight Full"/>
</asp:BoundField>
<asp:BoundField DataField="SECTOR" HeaderText="Sector" SortExpression="SECTOR" >
<Itemstyle CssClass="tabStripBodyBord er" HorizontalAlign=Left/>
<HeaderStyle CssClass="tableBodyHilight Full"/>
</asp:BoundField>
<asp:BoundField DataField="REGION" HeaderText="Region" SortExpression="REGION" >
<Itemstyle CssClass="tabStripBodyBord er" HorizontalAlign=Left/>
<HeaderStyle CssClass="tableBodyHilight Full"/>
</asp:BoundField>
<asp:BoundField DataField="CATEGORY" HeaderText="Interaction Type" SortExpression="CATEGORY" >
<Itemstyle CssClass="tabStripBodyBord er" HorizontalAlign=Left/>
<HeaderStyle CssClass="tableBodyHilight Full"/>
</asp:BoundField>
<asp:BoundField DataField="CONTACT_NAME" HeaderText="Contact" SortExpression="CONTACT_NA ME" >
<Itemstyle CssClass="tabStripBodyBord er" HorizontalAlign=Left/>
<HeaderStyle CssClass="tableBodyHilight Full"/>
</asp:BoundField>
<asp:BoundField DataField="START_DT" HeaderText="Date" SortExpression="START_DT" >
<Itemstyle CssClass="tabStripBodyBord er" HorizontalAlign=Left/>
<HeaderStyle CssClass="tableBodyHilight Full"/>
</asp:BoundField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="sdsDiarySearch" runat="server" ConnectionString="<%$ ConnectionStrings:DSN %>"
SelectCommand="SELECT BROKER_NAME, BC.USER_LAST_NAME + ',' + BC.USER_FIRST_NAME AS BC_NAME, CONVERT(varchar(10), [START_DT], 101) AS [START_DT], C.DESCR AS CATEGORY, CT.USER_LAST_NAM E + ',' + CT.USER_FIRST_NAME AS CONTACT_NAME, S.DESCR AS STRATEGY, SR.DESCR AS SECTOR, R.DESCR AS REGION, [OTHER_CONTACT], i.DESCR AS INTERACTION, ID.DIARY_SEQ_NO AS DIARY_SEQ_NO FROM [Interaction_Diary] ID Left outer join Broker B on ID.Broker_Seq_No = B.Broker_Seq_no LEFT OUTER JOIN USERS BC ON ID.BROKER_CONTACT_SEQ_NO = BC.USER_SEQ_NO LEFT OUTER JOIN CATEGORIES C ON ID.CATEGORIES_SEQ_NO = C.CATEGORIES_SEQ_NO LEFT OUTER JOIN USERS CT ON ID.USER_SEQ_NO = CT.USER_SEQ_NO LEFT OUTER JOIN STRATEGY S ON ID.STRATEGY_SEQ_NO = S.STRATEGY_SEQ_NO LEFT OUTER JOIN SECTOR SR ON ID.SECTOR_SEQ_NO = SR.SECTOR_SEQ_NO LEFT OUTER JOIN REGION R ON ID.REGION_SEQ_NO = R.REGION_SEQ_NO LEFT OUTER JOIN INTERACTION I ON ID.INTERACTION_SEQ_NO = I.INTERACTION_SEQ_NO & #10;WHERE 1=0">
</asp:SqlDataSource>
I just tried to bring up another gridview which was working and sorting fine before, but now that one is having the same problem. When I click on the column header to sort, the grid disappears. Do you know of any issue or property or setting in IE 6 that might cause a scenerio like that.
If it helps, here's the ASP for the gridview and the SqlDataSource. Let me know if you see anything amiss that I did not notice.
Thank you,
Craig Newman
<asp:GridView ID="grdDiarySearch" runat="server" AllowSorting="True" AutoGenerateColumns="False
CellPadding="1" DataSourceID="sdsDiarySear
<Columns>
<asp:CommandField ShowSelectButton="True" >
<Itemstyle CssClass="tabStripBodyBord
<HeaderStyle CssClass="tableBodyHilight
</asp:CommandField>
<asp:BoundField DataField="BROKER_NAME" HeaderText="Broker Name" SortExpression="BROKER_NAM
<Itemstyle CssClass="tabStripBodyBord
<HeaderStyle CssClass="tableBodyHilight
</asp:BoundField>
<asp:BoundField DataField="BC_NAME" HeaderText="Rep/Analyst" SortExpression="BC_NAME" >
<Itemstyle CssClass="tabStripBodyBord
<HeaderStyle CssClass="tableBodyHilight
</asp:BoundField>
<asp:BoundField DataField="OTHER_CONTACT" HeaderText="Other Analyst" SortExpression="OTHER_CONT
<Itemstyle CssClass="tabStripBodyBord
<HeaderStyle CssClass="tableBodyHilight
</asp:BoundField>
<asp:BoundField DataField="STRATEGY" HeaderText="Prod/Strategy"
<Itemstyle CssClass="tabStripBodyBord
<HeaderStyle CssClass="tableBodyHilight
</asp:BoundField>
<asp:BoundField DataField="INTERACTION" HeaderText="Service" SortExpression="INTERACTIO
<Itemstyle CssClass="tabStripBodyBord
<HeaderStyle CssClass="tableBodyHilight
</asp:BoundField>
<asp:BoundField DataField="SECTOR" HeaderText="Sector" SortExpression="SECTOR" >
<Itemstyle CssClass="tabStripBodyBord
<HeaderStyle CssClass="tableBodyHilight
</asp:BoundField>
<asp:BoundField DataField="REGION" HeaderText="Region" SortExpression="REGION" >
<Itemstyle CssClass="tabStripBodyBord
<HeaderStyle CssClass="tableBodyHilight
</asp:BoundField>
<asp:BoundField DataField="CATEGORY" HeaderText="Interaction Type" SortExpression="CATEGORY" >
<Itemstyle CssClass="tabStripBodyBord
<HeaderStyle CssClass="tableBodyHilight
</asp:BoundField>
<asp:BoundField DataField="CONTACT_NAME" HeaderText="Contact" SortExpression="CONTACT_NA
<Itemstyle CssClass="tabStripBodyBord
<HeaderStyle CssClass="tableBodyHilight
</asp:BoundField>
<asp:BoundField DataField="START_DT" HeaderText="Date" SortExpression="START_DT" >
<Itemstyle CssClass="tabStripBodyBord
<HeaderStyle CssClass="tableBodyHilight
</asp:BoundField>
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="sdsDiarySearch" runat="server" ConnectionString="<%$ ConnectionStrings:DSN %>"
SelectCommand="SELECT BROKER_NAME, BC.USER_LAST_NAME + ',' + BC.USER_FIRST_NAME AS BC_NAME, CONVERT(varchar(10), [START_DT], 101) AS [START_DT], C.DESCR AS CATEGORY, CT.USER_LAST_NAM
</asp:SqlDataSource>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.