Telerik Forums / UI for ASP.NET AJAX
This is a migrated thread and some comments may be shown as answers.

[Solved] Ajaxed Grid and Session variables

1 Answer 196 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Chris Griffin
Top achievements
Rank 1
Chris Griffin asked on 28 Jan 2010, 07:50 PM
I am have radgrid that is misbehaving.  On the action event Itemcommand I want to load come pointers into a session variable.  Problem is that for whatever reason when I leave the scope of the function the Session variable is null.  I believe it is something to do with the ajax control.  Below is the page I am working on.  Please help...stuck.
<%@ Page Title="" Language="C#" MasterPageFile="~/ePacket.master" AutoEventWireup="true" 
    CodeFile="ManagePackets.aspx.cs" Inherits="ManagePackets" %>  
 
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" 
    Namespace="System.Web.UI" TagPrefix="asp" %>  
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">  
    <style type="text/css">  
        .style4  
        {  
            width: 669px;  
        }  
        .style5  
        {  
            width: 80px;  
        }  
        .headerOffice07  
        {  
            background: #d6e5f3 0 -5900px repeat-x url('images/sprite.gif');  
        }  
        .style6  
        {  
            width: 165px;  
        }  
        .fileTypes  
        {  
            float: left;  
        }  
    </style>  
</asp:Content>  
<asp:Content ID="Content2" ContentPlaceHolderID="contBody" runat="Server">  
    <br />  
    <div align="center">  
        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1" 
            EnableHistory="True">  
            <AjaxSettings>  
                <telerik:AjaxSetting AjaxControlID="cmdAdd">  
                    <UpdatedControls>  
                        <telerik:AjaxUpdatedControl ControlID="panTitleForpanPackets" />  
                        <telerik:AjaxUpdatedControl ControlID="panPackets"></telerik:AjaxUpdatedControl>  
                        <telerik:AjaxUpdatedControl ControlID="panPacketDetails" />  
                    </UpdatedControls>  
                    <UpdatedControls>  
                        <telerik:AjaxUpdatedControl ControlID="panTitleForpanPackets" />  
                    </UpdatedControls>  
                    <UpdatedControls>  
                    </UpdatedControls>  
                </telerik:AjaxSetting>  
                <telerik:AjaxSetting AjaxControlID="gridPackets">  
                    <UpdatedControls>  
                        <telerik:AjaxUpdatedControl ControlID="panTitleForpanPackets" />  
                        <telerik:AjaxUpdatedControl ControlID="panPackets" />  
                        <telerik:AjaxUpdatedControl ControlID="panPacketDetails" />  
                    </UpdatedControls>  
                </telerik:AjaxSetting>  
            </AjaxSettings>  
        </telerik:RadAjaxManager>  
        <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Office2007">  
        </telerik:RadAjaxLoadingPanel>  
        <asp:Panel runat="server" ID="panTitleForpanPackets" Width='900px'>  
            <table width='100%'>  
                <tr>  
                    <td align="left" class="style5">  
                        <asp:LinkButton ID="cmdAdd" Font-Size="Small" runat="server" OnClick="cmdAdd_Click">Create Packet</asp:LinkButton>  
                    </td>  
                    <td align="center" class="style4">  
                        <asp:Label ID="Label1" runat="server" Text="Current Packets" Font-Bold="True" Font-Size="Medium" 
                            ForeColor="#00156E"></asp:Label>  
                    </td>  
                    <td>  
                    </td>  
                </tr>  
            </table>  
        </asp:Panel>  
        <asp:Panel ID="panPackets" Width='900px' runat="server">  
            <telerik:RadGrid ID="gridPackets" runat="server" DataSourceID="AllPackets" GridLines="None" 
                Skin="Office2007" AllowPaging="True" PageSize="15" AllowFilteringByColumn="True" 
                OnItemCommand="RadGrid2_ItemCommand">  
                <MasterTableView AutoGenerateColumns="False" DataSourceID="AllPackets">  
                    <RowIndicatorColumn>  
                        <HeaderStyle Width="20px" />  
                    </RowIndicatorColumn>  
                    <ExpandCollapseColumn>  
                        <HeaderStyle Width="20px" />  
                    </ExpandCollapseColumn>  
                    <HeaderStyle HorizontalAlign="Left" />  
                    <ItemStyle HorizontalAlign="Left" />  
                    <AlternatingItemStyle HorizontalAlign="Left" />  
                    <FilterItemStyle HorizontalAlign="Left" />  
                    <Columns>  
                        <telerik:GridTemplateColumn>  
                            <FilterTemplate>  
                                Clear filters  
                                <asp:ImageButton ID="btnShowAll" runat="server" ImageUrl="Images/filterCancel.gif" 
                                    OnClick="btnShowAll_Click" Style="vertical-align: middle" />  
                            </FilterTemplate>  
                            <ItemTemplate>  
                                <asp:LinkButton ID="LinkButton1" CommandArgument='<%# Eval("PacketID") %>' CommandName="Details" 
                                    runat="server">  
                      Details</asp:LinkButton>  
                            </ItemTemplate>  
                        </telerik:GridTemplateColumn>  
                        <telerik:GridBoundColumn DataField="MeetingName" HeaderText="Meeting / Group Name" 
                            SortExpression="MeetingName" UniqueName="MeetingName">  
                            <FilterTemplate>  
                                <telerik:RadComboBox ID="ddlMeetingNameFilter" DataSourceID="SqlDataSource2" DataTextField="MeetingName" 
                                    DataValueField="MeetingName" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("MeetingName").CurrentFilterValue %>'  
                                    runat="server" OnClientSelectedIndexChanged="MeetingIndexChanged" DropDownWidth="230px">  
                                    <Items>  
                                        <telerik:RadComboBoxItem Text="All" />  
                                    </Items>  
                                </telerik:RadComboBox>  
                                <telerik:RadScriptBlock ID="RadScriptBlock4" runat="server">  
 
                                    <script type="text/javascript">  
                                        function MeetingIndexChanged(sender, args) {  
                                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");  
                                            tableView.filter("MeetingName", args.get_item().get_value(), "EqualTo");  
 
                                        }  
                                    </script>  
 
                                </telerik:RadScriptBlock>  
                            </FilterTemplate>  
                        </telerik:GridBoundColumn>  
                        <telerik:GridBoundColumn DataField="PublishDate" DataType="System.DateTime" HeaderText="Date Published" 
                            SortExpression="PublishDate" DataFormatString="{0:D}" UniqueName="PublishDate">  
                            <FilterTemplate>  
                                From  
                                <telerik:RadDatePicker ID="FromOrderDatePicker" runat="server" Width="100px" Skin="Office2007" 
                                    ClientEvents-OnDateSelected="FromDateSelected" DbSelectedDate='<%# startDate %>' />  
                                to  
                                <telerik:RadDatePicker ID="ToOrderDatePicker" runat="server" Width="100px" Skin="Office2007" 
                                    ClientEvents-OnDateSelected="ToDateSelected" DbSelectedDate='<%# endDate %>' />  
                                <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">  
 
                                    <script type="text/javascript">  
                                        function FromDateSelected(sender, args) {  
                                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");  
                                            var ToPicker = $find('<%# ((GridItem)Container).FindControl("ToOrderDatePicker").ClientID %>');  
 
                                            var fromDate = FormatSelectedDate(sender);  
                                            var toDate = FormatSelectedDate(ToPicker);  
 
                                            tableView.filter("PublishDate", fromDate + " " + toDate, "Between");  
 
                                        }  
                                        function ToDateSelected(sender, args) {  
                                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");  
                                            var FromPicker = $find('<%# ((GridItem)Container).FindControl("FromOrderDatePicker").ClientID %>');  
 
                                            var fromDate = FormatSelectedDate(FromPicker);  
                                            var toDate = FormatSelectedDate(sender);  
 
                                            tableView.filter("PublishDate", fromDate + " " + toDate, "Between");  
                                        }  
                                        function FormatSelectedDate(picker) {  
                                            var date = picker.get_selectedDate();  
                                            var dateInput = picker.get_dateInput();  
                                            var formattedDate = dateInput.get_dateFormatInfo().FormatDate(date, dateInput.get_displayDateFormat());  
 
                                            return formattedDate;  
                                        }  
                                    </script>  
 
                                </telerik:RadScriptBlock>  
                            </FilterTemplate>  
                        </telerik:GridBoundColumn>  
                        <telerik:GridBoundColumn DataField="FiscalYear" HeaderText="Fiscal Year" SortExpression="FiscalYear" 
                            UniqueName="FiscalYear">  
                            <FilterTemplate>  
                                <telerik:RadComboBox ID="ddlFiscalYear" Width="100px" DataSourceID="SqlDataSource3" 
                                    DataTextField="FiscalYear" DataValueField="FiscalYear" AppendDataBoundItems="true" 
                                    SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("FiscalYear").CurrentFilterValue %>'  
                                    runat="server" OnClientSelectedIndexChanged="TitleIndexChanged" DropDownWidth="100px">  
                                    <Items>  
                                        <telerik:RadComboBoxItem Text="All" />  
                                    </Items>  
                                </telerik:RadComboBox>  
                                <telerik:RadScriptBlock ID="RadScriptBlock3" runat="server">  
 
                                    <script type="text/javascript">  
                                        function TitleIndexChanged(sender, args) {  
                                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");  
                                            tableView.filter("FiscalYear", args.get_item().get_value(), "EqualTo");  
 
                                        }  
                                    </script>  
 
                                </telerik:RadScriptBlock>  
                            </FilterTemplate>  
                        </telerik:GridBoundColumn>  
                        <telerik:GridBoundColumn DataField="Name" HeaderText="Published By" ReadOnly="True" 
                            SortExpression="Name" UniqueName="Name">  
                            <FilterTemplate>  
                                <telerik:RadComboBox ID="ddlNameFilter" Width="100px" DataSourceID="SqlDataSource4" 
                                    DataTextField="Name" DataValueField="Name" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("Name").CurrentFilterValue %>'  
                                    runat="server" OnClientSelectedIndexChanged="NameIndexChanged" DropDownWidth="120px">  
                                    <Items>  
                                        <telerik:RadComboBoxItem Text="All" />  
                                    </Items>  
                                </telerik:RadComboBox>  
                                <telerik:RadScriptBlock ID="RadScriptBlock5" runat="server">  
 
                                    <script type="text/javascript">  
                                        function NameIndexChanged(sender, args) {  
                                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");  
                                            tableView.filter("Name", args.get_item().get_value(), "EqualTo");  
 
                                        }  
                                    </script>  
 
                                </telerik:RadScriptBlock>  
                            </FilterTemplate>  
                        </telerik:GridBoundColumn>  
                    </Columns>  
                </MasterTableView>  
            </telerik:RadGrid>  
            <asp:SqlDataSource ID="AllPackets" runat="server" ConnectionString="<%$ ConnectionStrings:WebConnectionString %>" 
                SelectCommand="Select A.PacketID,MeetingName,A.PublishDate,FiscalYear,ISNULL(D.FirstName +' '+D.LastName,'No Name') as 'Name' From ePacket_Packet A Join ePacket_PacketPerms B ON (A.MeetingID=B.PacketID)
Join ePacket_Meeting C on (A.MeetingID=C.MeetingID) Left Outer Join COAUsers D on (A.PublishedBy=D.UserID)
 Where A.Archive='No' and B.Archive='No'  and B.UserID=@UserID
Order By MeetingName ASC,FiscalYear DESC,PublishDate DESC">  
                <SelectParameters>  
                    <asp:SessionParameter Name="UserID" SessionField="packet" />  
                </SelectParameters>  
            </asp:SqlDataSource>  
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:WebConnectionString %>" 
                SelectCommand="Select * From ePacket_Meeting A Join ePacket_PacketPerms B ON (A.MeetingID=B.PacketID) Where B.UserID=@UserID and B.Archive='No' and A.Archive='No' Order By MeetingName ASC">  
                <SelectParameters>  
                    <asp:SessionParameter Name="UserID" SessionField="Packet" />  
                </SelectParameters>  
            </asp:SqlDataSource>  
            <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:WebConnectionString %>" 
                SelectCommand="Select Distinct FiscalYear From ePacket_Packet Where Archive='No' Order By FiscalYear DESC">  
            </asp:SqlDataSource>  
            <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:WebConnectionString %>" 
                SelectCommand="Select  Distinct FirstName+' '+LastName as 'Name' From COAUsers A Join ePacket_Packet B on (A.UserID=B.PublishedBy)
Where B.Archive='No'"></asp:SqlDataSource>  
        </asp:Panel>  
        <br />  
        <asp:Panel ID="panPacketDetails" Width='600px' runat="server" BorderColor="Black" 
            BorderStyle="Solid" BorderWidth="1px" Visible="False">  
            <table width='100%'>  
                <tr>  
                    <td align="center" colspan='2' class="headerOffice07">  
                        <asp:Label ID="lblHeader" Font-Size="Medium" runat="server" Text="Add New Packet" 
                            Font-Bold="True" ForeColor="#00156E"></asp:Label>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="left" class="style6">  
                        <asp:Label ID="Label2" runat="server" Text="Select Meeting / Group:" Font-Size='Small'></asp:Label>  
                    </td>  
                    <td align="left">  
                        <telerik:RadComboBox ID="ddlMeetingType" runat="server" Skin="Office2007" Width="300px" 
                            AutoPostBack="True" OnSelectedIndexChanged="ddlMeetingType_SelectedIndexChanged">  
                        </telerik:RadComboBox>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="left">  
                        <asp:Label ID="Label4" runat="server" Text="Publish Date:" Font-Size="Small"></asp:Label>  
                    </td>  
                    <td align="left">  
                        <telerik:RadDatePicker ID="dPickPublishDate" runat="server" Skin="Office2007" Width="300px">  
                            <Calendar Skin="Office2007" UseColumnHeadersAsSelectors="False" UseRowHeadersAsSelectors="False" 
                                ViewSelectorText="x">  
                            </Calendar>  
                            <DatePopupButton HoverImageUrl="" ImageUrl="" />  
                        </telerik:RadDatePicker>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="left">  
                        <asp:Label ID="Label3" Font-Size="Small" runat="server" Text="Available File Types:"></asp:Label>  
                    </td>  
                    <td align="left">  
                        <asp:Panel ID="panAgenda" runat="server" Width="50px" CssClass="fileTypes">  
                            <asp:LinkButton ID="cmdAgenda" runat="server" Font-Size="Small" ForeColor="Red" OnClick="cmdAgenda_Click">Agenda</asp:LinkButton>&nbsp;</asp:Panel>  
                        <asp:Panel ID="panMinutes" CssClass="fileTypes" runat="server" Width="55px">  
                            <asp:LinkButton ID="cmdMinutes" runat="server" Font-Size="Small" ForeColor="Red" 
                                Height="16px">Minutes</asp:LinkButton>&nbsp;</asp:Panel>  
                        <asp:Panel ID="panCOW" runat="server" Width="50px" CssClass="fileTypes">  
                            <asp:LinkButton ID="cmdCOW" runat="server" Font-Size="Small" ForeColor="Red">C.O.W</asp:LinkButton>&nbsp;</asp:Panel>  
                        <asp:Panel ID="panPacket" runat="server" Width="50px" CssClass="fileTypes">  
                            <asp:LinkButton ID="cmdPacket" runat="server" Font-Size="Small" ForeColor="Red">Packet</asp:LinkButton>&nbsp;</asp:Panel>  
                        <asp:Panel ID="panOther" runat="server" Width="75px" CssClass="fileTypes">  
                            <asp:LinkButton ID="cmdOther" runat="server" Font-Size="Small" ForeColor="Red">Other Files</asp:LinkButton>&nbsp;</asp:Panel>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="left">  
                        <asp:Label ID="lblLabelFileType" runat="server" Font-Size="Small" Text="File Type:"></asp:Label>  
                    </td>  
                    <td align="left">  
                        <asp:Label ID="lblFileType" runat="server" Font-Size="Small" Text="No File Type Selected"></asp:Label>  
                    </td>  
                </tr>  
                <tr>  
                    <td>  
                        &nbsp;  
                    </td>  
                    <td align="left">  
                        <asp:Table ID="tabFiles" Font-Size="Small" runat="server">  
                        </asp:Table>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="left" class="style6">  
                    </td>  
                    <td align="left">  
                        <telerik:RadUpload ID="RadUpload1" runat="server" MaxFileInputsCount="1" Skin="Office2007" 
                            Enabled="False">  
                        </telerik:RadUpload>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="center" colspan='2'>  
                        <asp:ImageButton ID="cmdSubmit" runat="server" />&nbsp;  
                        <asp:ImageButton ID="cmdCancel" runat="server" /><asp:HiddenField ID="PacketID" runat="server" />  
                    </td>  
                </tr>  
            </table>  
        </asp:Panel>  
    </div>  
</asp:Content>  
 
<%@ Page Title="" Language="C#" MasterPageFile="~/ePacket.master" AutoEventWireup="true" 
    CodeFile="ManagePackets.aspx.cs" Inherits="ManagePackets" %>  
 
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" 
    Namespace="System.Web.UI" TagPrefix="asp" %>  
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">  
    <style type="text/css">  
        .style4  
        {  
            width: 669px;  
        }  
        .style5  
        {  
            width: 80px;  
        }  
        .headerOffice07  
        {  
            background: #d6e5f3 0 -5900px repeat-x url('images/sprite.gif');  
        }  
        .style6  
        {  
            width: 165px;  
        }  
        .fileTypes  
        {  
            float: left;  
        }  
    </style>  
</asp:Content>  
<asp:Content ID="Content2" ContentPlaceHolderID="contBody" runat="Server">  
    <br />  
    <div align="center">  
        <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" DefaultLoadingPanelID="RadAjaxLoadingPanel1" 
            EnableHistory="True">  
            <AjaxSettings>  
                <telerik:AjaxSetting AjaxControlID="cmdAdd">  
                    <UpdatedControls>  
                        <telerik:AjaxUpdatedControl ControlID="panTitleForpanPackets" />  
                        <telerik:AjaxUpdatedControl ControlID="panPackets"></telerik:AjaxUpdatedControl>  
                        <telerik:AjaxUpdatedControl ControlID="panPacketDetails" />  
                    </UpdatedControls>  
                    <UpdatedControls>  
                        <telerik:AjaxUpdatedControl ControlID="panTitleForpanPackets" />  
                    </UpdatedControls>  
                    <UpdatedControls>  
                    </UpdatedControls>  
                </telerik:AjaxSetting>  
                <telerik:AjaxSetting AjaxControlID="gridPackets">  
                    <UpdatedControls>  
                        <telerik:AjaxUpdatedControl ControlID="panTitleForpanPackets" />  
                        <telerik:AjaxUpdatedControl ControlID="panPackets" />  
                        <telerik:AjaxUpdatedControl ControlID="panPacketDetails" />  
                    </UpdatedControls>  
                </telerik:AjaxSetting>  
            </AjaxSettings>  
        </telerik:RadAjaxManager>  
        <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Office2007">  
        </telerik:RadAjaxLoadingPanel>  
        <asp:Panel runat="server" ID="panTitleForpanPackets" Width='900px'>  
            <table width='100%'>  
                <tr>  
                    <td align="left" class="style5">  
                        <asp:LinkButton ID="cmdAdd" Font-Size="Small" runat="server" OnClick="cmdAdd_Click">Create Packet</asp:LinkButton>  
                    </td>  
                    <td align="center" class="style4">  
                        <asp:Label ID="Label1" runat="server" Text="Current Packets" Font-Bold="True" Font-Size="Medium" 
                            ForeColor="#00156E"></asp:Label>  
                    </td>  
                    <td>  
                    </td>  
                </tr>  
            </table>  
        </asp:Panel>  
        <asp:Panel ID="panPackets" Width='900px' runat="server">  
            <telerik:RadGrid ID="gridPackets" runat="server" DataSourceID="AllPackets" GridLines="None" 
                Skin="Office2007" AllowPaging="True" PageSize="15" AllowFilteringByColumn="True" 
                OnItemCommand="RadGrid2_ItemCommand">  
                <MasterTableView AutoGenerateColumns="False" DataSourceID="AllPackets">  
                    <RowIndicatorColumn>  
                        <HeaderStyle Width="20px" />  
                    </RowIndicatorColumn>  
                    <ExpandCollapseColumn>  
                        <HeaderStyle Width="20px" />  
                    </ExpandCollapseColumn>  
                    <HeaderStyle HorizontalAlign="Left" />  
                    <ItemStyle HorizontalAlign="Left" />  
                    <AlternatingItemStyle HorizontalAlign="Left" />  
                    <FilterItemStyle HorizontalAlign="Left" />  
                    <Columns>  
                        <telerik:GridTemplateColumn>  
                            <FilterTemplate>  
                                Clear filters  
                                <asp:ImageButton ID="btnShowAll" runat="server" ImageUrl="Images/filterCancel.gif" 
                                    OnClick="btnShowAll_Click" Style="vertical-align: middle" />  
                            </FilterTemplate>  
                            <ItemTemplate>  
                                <asp:LinkButton ID="LinkButton1" CommandArgument='<%# Eval("PacketID") %>' CommandName="Details" 
                                    runat="server">  
                      Details</asp:LinkButton>  
                            </ItemTemplate>  
                        </telerik:GridTemplateColumn>  
                        <telerik:GridBoundColumn DataField="MeetingName" HeaderText="Meeting / Group Name" 
                            SortExpression="MeetingName" UniqueName="MeetingName">  
                            <FilterTemplate>  
                                <telerik:RadComboBox ID="ddlMeetingNameFilter" DataSourceID="SqlDataSource2" DataTextField="MeetingName" 
                                    DataValueField="MeetingName" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("MeetingName").CurrentFilterValue %>'  
                                    runat="server" OnClientSelectedIndexChanged="MeetingIndexChanged" DropDownWidth="230px">  
                                    <Items>  
                                        <telerik:RadComboBoxItem Text="All" />  
                                    </Items>  
                                </telerik:RadComboBox>  
                                <telerik:RadScriptBlock ID="RadScriptBlock4" runat="server">  
 
                                    <script type="text/javascript">  
                                        function MeetingIndexChanged(sender, args) {  
                                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");  
                                            tableView.filter("MeetingName", args.get_item().get_value(), "EqualTo");  
 
                                        }  
                                    </script>  
 
                                </telerik:RadScriptBlock>  
                            </FilterTemplate>  
                        </telerik:GridBoundColumn>  
                        <telerik:GridBoundColumn DataField="PublishDate" DataType="System.DateTime" HeaderText="Date Published" 
                            SortExpression="PublishDate" DataFormatString="{0:D}" UniqueName="PublishDate">  
                            <FilterTemplate>  
                                From  
                                <telerik:RadDatePicker ID="FromOrderDatePicker" runat="server" Width="100px" Skin="Office2007" 
                                    ClientEvents-OnDateSelected="FromDateSelected" DbSelectedDate='<%# startDate %>' />  
                                to  
                                <telerik:RadDatePicker ID="ToOrderDatePicker" runat="server" Width="100px" Skin="Office2007" 
                                    ClientEvents-OnDateSelected="ToDateSelected" DbSelectedDate='<%# endDate %>' />  
                                <telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">  
 
                                    <script type="text/javascript">  
                                        function FromDateSelected(sender, args) {  
                                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");  
                                            var ToPicker = $find('<%# ((GridItem)Container).FindControl("ToOrderDatePicker").ClientID %>');  
 
                                            var fromDate = FormatSelectedDate(sender);  
                                            var toDate = FormatSelectedDate(ToPicker);  
 
                                            tableView.filter("PublishDate", fromDate + " " + toDate, "Between");  
 
                                        }  
                                        function ToDateSelected(sender, args) {  
                                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");  
                                            var FromPicker = $find('<%# ((GridItem)Container).FindControl("FromOrderDatePicker").ClientID %>');  
 
                                            var fromDate = FormatSelectedDate(FromPicker);  
                                            var toDate = FormatSelectedDate(sender);  
 
                                            tableView.filter("PublishDate", fromDate + " " + toDate, "Between");  
                                        }  
                                        function FormatSelectedDate(picker) {  
                                            var date = picker.get_selectedDate();  
                                            var dateInput = picker.get_dateInput();  
                                            var formattedDate = dateInput.get_dateFormatInfo().FormatDate(date, dateInput.get_displayDateFormat());  
 
                                            return formattedDate;  
                                        }  
                                    </script>  
 
                                </telerik:RadScriptBlock>  
                            </FilterTemplate>  
                        </telerik:GridBoundColumn>  
                        <telerik:GridBoundColumn DataField="FiscalYear" HeaderText="Fiscal Year" SortExpression="FiscalYear" 
                            UniqueName="FiscalYear">  
                            <FilterTemplate>  
                                <telerik:RadComboBox ID="ddlFiscalYear" Width="100px" DataSourceID="SqlDataSource3" 
                                    DataTextField="FiscalYear" DataValueField="FiscalYear" AppendDataBoundItems="true" 
                                    SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("FiscalYear").CurrentFilterValue %>'  
                                    runat="server" OnClientSelectedIndexChanged="TitleIndexChanged" DropDownWidth="100px">  
                                    <Items>  
                                        <telerik:RadComboBoxItem Text="All" />  
                                    </Items>  
                                </telerik:RadComboBox>  
                                <telerik:RadScriptBlock ID="RadScriptBlock3" runat="server">  
 
                                    <script type="text/javascript">  
                                        function TitleIndexChanged(sender, args) {  
                                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");  
                                            tableView.filter("FiscalYear", args.get_item().get_value(), "EqualTo");  
 
                                        }  
                                    </script>  
 
                                </telerik:RadScriptBlock>  
                            </FilterTemplate>  
                        </telerik:GridBoundColumn>  
                        <telerik:GridBoundColumn DataField="Name" HeaderText="Published By" ReadOnly="True" 
                            SortExpression="Name" UniqueName="Name">  
                            <FilterTemplate>  
                                <telerik:RadComboBox ID="ddlNameFilter" Width="100px" DataSourceID="SqlDataSource4" 
                                    DataTextField="Name" DataValueField="Name" AppendDataBoundItems="true" SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("Name").CurrentFilterValue %>'  
                                    runat="server" OnClientSelectedIndexChanged="NameIndexChanged" DropDownWidth="120px">  
                                    <Items>  
                                        <telerik:RadComboBoxItem Text="All" />  
                                    </Items>  
                                </telerik:RadComboBox>  
                                <telerik:RadScriptBlock ID="RadScriptBlock5" runat="server">  
 
                                    <script type="text/javascript">  
                                        function NameIndexChanged(sender, args) {  
                                            var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");  
                                            tableView.filter("Name", args.get_item().get_value(), "EqualTo");  
 
                                        }  
                                    </script>  
 
                                </telerik:RadScriptBlock>  
                            </FilterTemplate>  
                        </telerik:GridBoundColumn>  
                    </Columns>  
                </MasterTableView>  
            </telerik:RadGrid>  
            <asp:SqlDataSource ID="AllPackets" runat="server" ConnectionString="<%$ ConnectionStrings:WebConnectionString %>" 
                SelectCommand="Select A.PacketID,MeetingName,A.PublishDate,FiscalYear,ISNULL(D.FirstName +' '+D.LastName,'No Name') as 'Name' From ePacket_Packet A Join ePacket_PacketPerms B ON (A.MeetingID=B.PacketID)
Join ePacket_Meeting C on (A.MeetingID=C.MeetingID) Left Outer Join COAUsers D on (A.PublishedBy=D.UserID)
 Where A.Archive='No' and B.Archive='No'  and B.UserID=@UserID
Order By MeetingName ASC,FiscalYear DESC,PublishDate DESC">  
                <SelectParameters>  
                    <asp:SessionParameter Name="UserID" SessionField="packet" />  
                </SelectParameters>  
            </asp:SqlDataSource>  
            <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:WebConnectionString %>" 
                SelectCommand="Select * From ePacket_Meeting A Join ePacket_PacketPerms B ON (A.MeetingID=B.PacketID) Where B.UserID=@UserID and B.Archive='No' and A.Archive='No' Order By MeetingName ASC">  
                <SelectParameters>  
                    <asp:SessionParameter Name="UserID" SessionField="Packet" />  
                </SelectParameters>  
            </asp:SqlDataSource>  
            <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:WebConnectionString %>" 
                SelectCommand="Select Distinct FiscalYear From ePacket_Packet Where Archive='No' Order By FiscalYear DESC">  
            </asp:SqlDataSource>  
            <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:WebConnectionString %>" 
                SelectCommand="Select  Distinct FirstName+' '+LastName as 'Name' From COAUsers A Join ePacket_Packet B on (A.UserID=B.PublishedBy)
Where B.Archive='No'"></asp:SqlDataSource>  
        </asp:Panel>  
        <br />  
        <asp:Panel ID="panPacketDetails" Width='600px' runat="server" BorderColor="Black" 
            BorderStyle="Solid" BorderWidth="1px" Visible="False">  
            <table width='100%'>  
                <tr>  
                    <td align="center" colspan='2' class="headerOffice07">  
                        <asp:Label ID="lblHeader" Font-Size="Medium" runat="server" Text="Add New Packet" 
                            Font-Bold="True" ForeColor="#00156E"></asp:Label>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="left" class="style6">  
                        <asp:Label ID="Label2" runat="server" Text="Select Meeting / Group:" Font-Size='Small'></asp:Label>  
                    </td>  
                    <td align="left">  
                        <telerik:RadComboBox ID="ddlMeetingType" runat="server" Skin="Office2007" Width="300px" 
                            AutoPostBack="True" OnSelectedIndexChanged="ddlMeetingType_SelectedIndexChanged">  
                        </telerik:RadComboBox>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="left">  
                        <asp:Label ID="Label4" runat="server" Text="Publish Date:" Font-Size="Small"></asp:Label>  
                    </td>  
                    <td align="left">  
                        <telerik:RadDatePicker ID="dPickPublishDate" runat="server" Skin="Office2007" Width="300px">  
                            <Calendar Skin="Office2007" UseColumnHeadersAsSelectors="False" UseRowHeadersAsSelectors="False" 
                                ViewSelectorText="x">  
                            </Calendar>  
                            <DatePopupButton HoverImageUrl="" ImageUrl="" />  
                        </telerik:RadDatePicker>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="left">  
                        <asp:Label ID="Label3" Font-Size="Small" runat="server" Text="Available File Types:"></asp:Label>  
                    </td>  
                    <td align="left">  
                        <asp:Panel ID="panAgenda" runat="server" Width="50px" CssClass="fileTypes">  
                            <asp:LinkButton ID="cmdAgenda" runat="server" Font-Size="Small" ForeColor="Red" OnClick="cmdAgenda_Click">Agenda</asp:LinkButton>&nbsp;</asp:Panel>  
                        <asp:Panel ID="panMinutes" CssClass="fileTypes" runat="server" Width="55px">  
                            <asp:LinkButton ID="cmdMinutes" runat="server" Font-Size="Small" ForeColor="Red" 
                                Height="16px">Minutes</asp:LinkButton>&nbsp;</asp:Panel>  
                        <asp:Panel ID="panCOW" runat="server" Width="50px" CssClass="fileTypes">  
                            <asp:LinkButton ID="cmdCOW" runat="server" Font-Size="Small" ForeColor="Red">C.O.W</asp:LinkButton>&nbsp;</asp:Panel>  
                        <asp:Panel ID="panPacket" runat="server" Width="50px" CssClass="fileTypes">  
                            <asp:LinkButton ID="cmdPacket" runat="server" Font-Size="Small" ForeColor="Red">Packet</asp:LinkButton>&nbsp;</asp:Panel>  
                        <asp:Panel ID="panOther" runat="server" Width="75px" CssClass="fileTypes">  
                            <asp:LinkButton ID="cmdOther" runat="server" Font-Size="Small" ForeColor="Red">Other Files</asp:LinkButton>&nbsp;</asp:Panel>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="left">  
                        <asp:Label ID="lblLabelFileType" runat="server" Font-Size="Small" Text="File Type:"></asp:Label>  
                    </td>  
                    <td align="left">  
                        <asp:Label ID="lblFileType" runat="server" Font-Size="Small" Text="No File Type Selected"></asp:Label>  
                    </td>  
                </tr>  
                <tr>  
                    <td>  
                        &nbsp;  
                    </td>  
                    <td align="left">  
                        <asp:Table ID="tabFiles" Font-Size="Small" runat="server">  
                        </asp:Table>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="left" class="style6">  
                    </td>  
                    <td align="left">  
                        <telerik:RadUpload ID="RadUpload1" runat="server" MaxFileInputsCount="1" Skin="Office2007" 
                            Enabled="False">  
                        </telerik:RadUpload>  
                    </td>  
                </tr>  
                <tr>  
                    <td align="center" colspan='2'>  
                        <asp:ImageButton ID="cmdSubmit" runat="server" />&nbsp;  
                        <asp:ImageButton ID="cmdCancel" runat="server" /><asp:HiddenField ID="PacketID" runat="server" />  
                    </td>  
                </tr>  
            </table>  
        </asp:Panel>  
    </div>  
</asp:Content>  
 
 
protected void RadGrid2_ItemCommand(object source, GridCommandEventArgs e)  
    {  
        if (e.CommandName == "Details")  
        {  
            LoadPacket(e.CommandArgument.ToString());  
            panPackets.Visible = false;  
        }  
 
        if (e.CommandName == RadGrid.FilterCommandName)  
        {  
            Pair filterPair = (Pair)e.CommandArgument;  
 
            switch (filterPair.Second.ToString())  
            {  
                case "PublishDate":  
                    this.startDate = ((e.Item as GridFilteringItem)[filterPair.Second.ToString()].FindControl("FromOrderDatePicker") as RadDatePicker).SelectedDate;  
                    this.endDate = ((e.Item as GridFilteringItem)[filterPair.Second.ToString()].FindControl("ToOrderDatePicker") as RadDatePicker).SelectedDate;  
                    break;  
                default:  
                    break;  
            }  
        }  
 
    }  
 

1 Answer, 1 is accepted

Sort by
0
Yavor
Telerik team
answered on 03 Feb 2010, 06:21 AM
Hello Chris,

I reviewed the code, and it looks correct.
If the issue persists, the best option is for you to open a formal support ticket, and send us a small working project, demonstrating your setup, and showing the unwanted behavior. We will debug it locally, and get back to you with more information on the matter.

Regards,
Yavor
the Telerik team

Watch a video on how to optimize your support resource searches and check out more tips on the blogs.
Follow the status of features or bugs in PITS and vote for them to affect their priority.
Tags
Grid
Asked by
Chris Griffin
Top achievements
Rank 1
Answers by
Yavor
Telerik team
Share this question
or