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