Friday, December 16, 2011

Sp Grid Filter(Custom)

<table>
<tr>
<td>
<SharePoint:SPGridView ID="grid" runat="server" HeaderStyle-ForeColor="#21374C" CellSpacing="1"
    CellPadding="12" OnSelectedIndexChanging="grid_SelectedIndexChanging" RowStyle-Height="15"
    AllowFiltering="true" AlternatingRowStyle-CssClass="listone" RowStyle-CssClass="listtwo" AllowPaging="true"
     FilterDataFields="PatientEvent,SelectedDate,StartTime,EndTime,Discipline,TherapistName,VisitActivity,VisitCount,OTDay"
    FilteredDataSourcePropertyFormat="{1} = '{0}'" FilteredDataSourcePropertyName="FilterExpression"
     GroupField="Name" GroupDescriptionField="Name" GroupFieldDisplayName="Name" PageSize="2"
    HeaderStyle-Height="20px" AllowSorting="true" AutoGenerateColumns="false">
    <RowStyle CssClass="listtwo" Height="15px" />
    <AlternatingRowStyle BackColor="White" />
    <Columns>
        <asp:TemplateField>
            <HeaderTemplate>
               
                <cc1:hovermenuextender id="HovMenu1" runat="server" targetcontrolid="div1" popupcontrolid="LstName"
                    popupposition="Bottom">
                </cc1:hovermenuextender>
               
                <div id="div1" runat="server">
                   Name
                </div>
            </HeaderTemplate>
            <ItemTemplate>
                <%# Eval("Name")%>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <ItemStyle Width="150px" />
            <HeaderTemplate>
               
                <cc1:hovermenuextender id="HovMenu12" runat="server" targetcontrolid="div3" popupcontrolid="GridView2"
                    popupposition="Bottom">
                </cc1:hovermenuextender>
               
                <div id="div3" runat="server">
                   Title
                </div>
            </HeaderTemplate>
            <ItemTemplate>
                &nbsp;<%# Eval("Title")%>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
            <HeaderTemplate>
                <cc1:hovermenuextender id="HovMenu2" runat="server" targetcontrolid="div4" popupcontrolid="GridView1"
                    popupposition="Bottom">
                </cc1:hovermenuextender>
            
               
                <div id="div4" runat="server">
                   Address
                </div>
            </HeaderTemplate>
            <ItemStyle Width="150px" />
            <ItemTemplate>
                &nbsp;
                <%# Eval("Address")%>
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
    <EditRowStyle BackColor="#7C6F57" />
    <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
    <HeaderStyle BackColor="#82A1C1" Font-Bold="True" ForeColor="White" />
    <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
    <RowStyle BackColor="#E3EAEB" />
    <SelectedRowStyle BackColor="#C5BBAF" ForeColor="#333333" Font-Bold="True" />
</SharePoint:SPGridView>
</td>
</tr>
<tr>
        <td style="background-color: #ebebeb">
            <asp:HiddenField ID="hdnPageNum" runat="server" />
            <asp:HiddenField ID="hdnPageSize" runat="server" />
            <asp:HiddenField ID="hdnTotalRecords" runat="server" />
            <asp:Panel ID="pnlpaging"  runat="server">
                <table width="99%" border="0" cellspacing="0" cellpadding="0" align="center">
                    <tr>
                        <td valign="middle" nowrap="nowrap" class="bodytext" width="38%">
                             Total Records:&nbsp;<%= TotalRecords %></td>
                        <td align="center" class="grid_bodytext">
                            <asp:ImageButton ID="imgPrev" runat="server" CausesValidation="False" ImageAlign="AbsMiddle"
                                ImageUrl="../_layouts/images/PREV.GIF" OnClick="imgPrev_Click" />
                            &nbsp;Page&nbsp;<span id="CurrentPage" runat="server"> </span>&nbsp;of&nbsp;<span
                                id="TotalPages" runat="server"> </span>
                            <asp:ImageButton ID="imgNext" runat="server" CausesValidation="False" ImageAlign="AbsMiddle"
                                ImageUrl="../_layouts/images/NEXT.GIF" OnClick="imgNext_Click" />
                        </td>
                        <td nowrap="nowrap" align="right" class="grid_bodytext">
                            Page No.<asp:DropDownList ID="ddlGo" runat="server">
                            </asp:DropDownList>
                            
                                                                </cc1:FilteredTextBoxExtender>
                            <asp:ImageButton ID="imgGo" runat="server" OnClick="imgGo_click" CausesValidation="false"
                                ImageAlign="AbsMiddle" ImageUrl="../_layouts/images/kpitrend-2.gif" AlternateText="go" />
                        </td>
                    </tr>
                    <tr>
                    <td colspan="3" align="right">  <asp:Label ID="lblpgexceed" runat="server" ForeColor="Red"></asp:Label></td>
                    </tr>
                </table>
            </asp:Panel>
        </td>
   </tr>

   </table>
   <table>
   <tr>
   <td>
  
<asp:GridView ID="LstName" OnRowCommand="LstName_RowCommand" style="display:none;" AutoGenerateColumns="false"
                    runat="server">
                    <Columns>
                        <asp:TemplateField>
                            <HeaderTemplate>
                                <asp:LinkButton ID="LnkName" CommandName="ClearFilter" runat="server">Clear</asp:LinkButton>
                               <asp:LinkButton ID="LinkButton1" CommandName="sortAsc" CommandArgument="Name" runat="server"> Sort Asc</asp:LinkButton>
                                <asp:LinkButton ID="LinkButton2" CommandName="sortDesc" CommandArgument="Name" runat="server"> Sort Desc</asp:LinkButton>
                            </HeaderTemplate>
                            <ItemTemplate>
                                <asp:LinkButton ID="LnkName" CommandName="Name" CommandArgument='<%# Eval("Name").ToString()+",Name" %>'
                                    runat="server"><%# Eval("Name")%></asp:LinkButton>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>
<asp:GridView ID="GridView1" OnRowCommand="LstName_RowCommand" style="display:none;" AutoGenerateColumns="false"
                    runat="server">
                    <Columns>
                        <asp:TemplateField>
                            <HeaderTemplate>
                                <asp:LinkButton ID="LnkName" CommandName="ClearFilter" runat="server">Clear</asp:LinkButton>
                                 <asp:LinkButton ID="LinkButton1" CommandName="sortAsc" CommandArgument="Address" runat="server"> Sort Asc</asp:LinkButton>
                                <asp:LinkButton ID="LinkButton2" CommandName="sortDesc" CommandArgument="Address" runat="server"> Sort Desc</asp:LinkButton>
                            </HeaderTemplate>
                            <ItemTemplate>
                                <asp:LinkButton ID="LnkName" CommandName="Address" CommandArgument='<%# Eval("Address").ToString()+",Address" %>'
                                    runat="server"><%# Eval("Address")%></asp:LinkButton>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>
<asp:GridView ID="GridView2" OnRowCommand="LstName_RowCommand" style="display:none;" AutoGenerateColumns="false"
                    runat="server">
                    <Columns>
                        <asp:TemplateField>
                            <HeaderTemplate>
                                <asp:LinkButton ID="LnkName1" CommandName="ClearFilter" runat="server">Clear</asp:LinkButton>
                                 <asp:LinkButton ID="LinkButton1" CommandName="sortAsc" CommandArgument="Title" runat="server"> Sort Asc</asp:LinkButton>
                                <asp:LinkButton ID="LinkButton2" CommandName="sortDesc" CommandArgument="Title" runat="server"> Sort Desc</asp:LinkButton>
                            </HeaderTemplate>
                            <ItemTemplate>
                                <asp:LinkButton ID="LnkName11" CommandName="Title" CommandArgument='<%# Eval("Title").ToString()+",Title" %>'
                                    runat="server"><%# Eval("Title")%></asp:LinkButton>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>
   </td>
   </tr>
   </table>
<asp:HiddenField ID="hdnfilter" runat="server" />

1 comment:

Creating Provider hosted app (sharepoint online) with local hosted IIS

The Pre-requires are as follows. 1. Office 365 Subscription 2. Visual Studio 2015 (Professional/Community/Enterprise Edition) With t...