I've got an issue where the filter list is not showing all the list items. The top of the list is cut off and "NoFilter" is not showing. I think it might be a CSS setting but all the attempts to fix have failed. The RadGrid is inside column1 of a two column master page. Also, looks like the list is "double spaced" and therefore making the list longer than it has to be.
Anyone have any suggestions?
Thanks,
David
| <%@ Page Title="" Language="C#" MasterPageFile="~/Layouts/TwoColumn.master" AutoEventWireup="true" CodeFile="bus_loc.aspx.cs" Inherits="co_listings_bus_loc" %> |
| <%@ Register assembly="Telerik.Web.UI" namespace="Telerik.Web.UI" tagprefix="telerik" %> |
| <asp:Content ID="Content1" ContentPlaceHolderID="Column1" Runat="Server"> |
| <asp:SqlDataSource ID="SqlDataSource1" runat="server" |
| ConflictDetection="CompareAllValues" |
| ConnectionString="<%$ ConnectionStrings:holhrb1_uni_common %>" |
| DeleteCommand="DELETE FROM [bus_loc] WHERE [SYSTEM] = @original_SYSTEM AND [CLIENT] = @original_CLIENT AND [JOBBER] = @original_JOBBER AND (([LOC] = @original_LOC) OR ([LOC] IS NULL AND @original_LOC IS NULL)) AND (([LOC_NAME] = @original_LOC_NAME) OR ([LOC_NAME] IS NULL AND @original_LOC_NAME IS NULL)) AND (([CLASS] = @original_CLASS) OR ([CLASS] IS NULL AND @original_CLASS IS NULL))" |
| InsertCommand="INSERT INTO [bus_loc] ([SYSTEM], [CLIENT], [JOBBER], [LOC], [LOC_NAME], [CLASS]) VALUES (@SYSTEM, @CLIENT, @JOBBER, @LOC, @LOC_NAME, @CLASS)" |
| OldValuesParameterFormatString="original_{0}" |
| SelectCommand="SELECT [SYSTEM], [CLIENT], [JOBBER], [LOC], [LOC_NAME], [CLASS] FROM [bus_loc]" |
| UpdateCommand="UPDATE [bus_loc] SET [LOC] = @LOC, [LOC_NAME] = @LOC_NAME, [CLASS] = @CLASS WHERE [SYSTEM] = @original_SYSTEM AND [CLIENT] = @original_CLIENT AND [JOBBER] = @original_JOBBER AND (([LOC] = @original_LOC) OR ([LOC] IS NULL AND @original_LOC IS NULL)) AND (([LOC_NAME] = @original_LOC_NAME) OR ([LOC_NAME] IS NULL AND @original_LOC_NAME IS NULL)) AND (([CLASS] = @original_CLASS) OR ([CLASS] IS NULL AND @original_CLASS IS NULL))"> |
| <DeleteParameters> |
| <asp:Parameter Name="original_SYSTEM" Type="String" /> |
| <asp:Parameter Name="original_CLIENT" Type="Int32" /> |
| <asp:Parameter Name="original_JOBBER" Type="Int32" /> |
| <asp:Parameter Name="original_LOC" Type="String" /> |
| <asp:Parameter Name="original_LOC_NAME" Type="String" /> |
| <asp:Parameter Name="original_CLASS" Type="String" /> |
| </DeleteParameters> |
| <UpdateParameters> |
| <asp:Parameter Name="LOC" Type="String" /> |
| <asp:Parameter Name="LOC_NAME" Type="String" /> |
| <asp:Parameter Name="CLASS" Type="String" /> |
| <asp:Parameter Name="original_SYSTEM" Type="String" /> |
| <asp:Parameter Name="original_CLIENT" Type="Int32" /> |
| <asp:Parameter Name="original_JOBBER" Type="Int32" /> |
| <asp:Parameter Name="original_LOC" Type="String" /> |
| <asp:Parameter Name="original_LOC_NAME" Type="String" /> |
| <asp:Parameter Name="original_CLASS" Type="String" /> |
| </UpdateParameters> |
| <InsertParameters> |
| <asp:Parameter Name="SYSTEM" Type="String" /> |
| <asp:Parameter Name="CLIENT" Type="Int32" /> |
| <asp:Parameter Name="JOBBER" Type="Int32" /> |
| <asp:Parameter Name="LOC" Type="String" /> |
| <asp:Parameter Name="LOC_NAME" Type="String" /> |
| <asp:Parameter Name="CLASS" Type="String" /> |
| </InsertParameters> |
| </asp:SqlDataSource> |
| <telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" |
| AllowPaging="True" AllowSorting="True" AutoGenerateDeleteColumn="True" |
| AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1" GridLines="None"> |
| <HeaderContextMenu EnableTheming="True"> |
| <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> |
| </HeaderContextMenu> |
| <MasterTableView AutoGenerateColumns="False" DataKeyNames="SYSTEM,CLIENT,JOBBER" |
| DataSourceID="SqlDataSource1"> |
| <RowIndicatorColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </RowIndicatorColumn> |
| <ExpandCollapseColumn> |
| <HeaderStyle Width="20px"></HeaderStyle> |
| </ExpandCollapseColumn> |
| <Columns> |
| <telerik:GridBoundColumn DataField="SYSTEM" HeaderText="SYSTEM" ReadOnly="True" |
| SortExpression="SYSTEM" UniqueName="SYSTEM" |
| FilterListOptions="AllowAllFilters"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="CLIENT" DataType="System.Int32" |
| HeaderText="CLIENT" ReadOnly="True" SortExpression="CLIENT" UniqueName="CLIENT"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="JOBBER" DataType="System.Int32" |
| HeaderText="JOBBER" ReadOnly="True" SortExpression="JOBBER" UniqueName="JOBBER"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="LOC" HeaderText="LOC" SortExpression="LOC" |
| UniqueName="LOC"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="LOC_NAME" HeaderText="LOC_NAME" |
| SortExpression="LOC_NAME" UniqueName="LOC_NAME"> |
| </telerik:GridBoundColumn> |
| <telerik:GridBoundColumn DataField="CLASS" HeaderText="CLASS" |
| SortExpression="CLASS" UniqueName="CLASS"> |
| </telerik:GridBoundColumn> |
| </Columns> |
| <PagerStyle Mode="NumericPages" /> |
| </MasterTableView> |
| <FilterMenu EnableTheming="True"> |
| <CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation> |
| </FilterMenu> |
| </telerik:RadGrid> |
| <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> |
| <AjaxSettings> |
| <telerik:AjaxSetting AjaxControlID="GridView1"> |
| <UpdatedControls> |
| <telerik:AjaxUpdatedControl ControlID="GridView1" /> |
| </UpdatedControls> |
| </telerik:AjaxSetting> |
| </AjaxSettings> |
| </telerik:RadAjaxManager> |
| </asp:Content> |
| <asp:Content ID="Content2" ContentPlaceHolderID="Column2" Runat="Server"> |
| </asp:Content> |