<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False"
DataSourceID="sqlCategories" GridLines="None">
<
MasterTableView DataKeyNames="Main_Category_ID,Sub_Category_ID"
DataSourceID="sqlCategories">
<
RowIndicatorColumn>
<
HeaderStyle Width="20px"></HeaderStyle>
</
RowIndicatorColumn>
<
ExpandCollapseColumn>
<
HeaderStyle Width="20px"></HeaderStyle>
</
ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="Main_Category"
SortExpression="Main_Category" UniqueName="Main_Category" Visible="False">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Sub_Category" HeaderText="Sub_Category"
SortExpression="Sub_Category" UniqueName="Sub_Category">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Sub_Category_Desc"
HeaderText="Sub_Category_Desc" SortExpression="Sub_Category_Desc"
UniqueName="Sub_Category_Desc">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Main_Category_ID" DataType="System.Int32"
HeaderText="Main_Category_ID" ReadOnly="True" SortExpression="Main_Category_ID"
UniqueName="Main_Category_ID">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="Sub_Category_ID" DataType="System.Int32"
HeaderText="Sub_Category_ID" ReadOnly="True" SortExpression="Sub_Category_ID"
UniqueName="Sub_Category_ID">
</telerik:GridBoundColumn>
</Columns>
<GroupByExpressions>
<telerik:GridGroupByExpression>
<SelectFields>
<telerik:GridGroupByField FieldAlias="Main_Category" FieldName="Main_Category" FormatString="{0}"></telerik:GridGroupByField>
</SelectFields>
<GroupByFields>
<telerik:GridGroupByField FieldName="Main_Category" SortOrder="Descending"></telerik:GridGroupByField>
</GroupByFields>
</telerik:GridGroupByExpression>
</GroupByExpressions>
</
MasterTableView>
</telerik:RadGrid>
<div style="width: 98%; overflow: auto; overflow-y: hidden"> <telerik:RadGrid ID="gvPjtMnt" runat="server" Height="600px" AutoGenerateColumns="false" BorderWidth="2px" BorderStyle="Solid" BackColor="White" AllowPaging="True" PagerStyle-AlwaysVisible="true" PageSize="20" AllowSorting="True" AllowFilteringByColumn="true" OnNeedDataSource="gvPjtMnt_OnNeedDataSource" OnItemCommand="gvPjtMnt_ItemCommand" OnItemCreated="gvPjtMnt_ItemCreated" EnableViewState="true"> <HeaderStyle Height="20px" BackColor="#004000" Font-Size="8pt" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" BorderColor="White" BorderWidth="1px" /> <AlternatingItemStyle Font-Size="8pt" BackColor="#F5F5E9" HorizontalAlign="Center" BorderWidth="1px" BorderColor="White" /> <ItemStyle HorizontalAlign="Center" /> <MasterTableView GridLines="None" CommandItemDisplay="Top" DataKeyNames="ProjectId" HorizontalAlign="Center" AllowFilteringByColumn="true"> <CommandItemTemplate> <table style="width: 100%"> <tr> <td align="right" style="width: 80%"> <asp:LinkButton ID="lnkshwFilter" Text="ShowFilter" Font-Underline="true" ForeColor="MidnightBlue" runat="server" OnClientClick="return showFilterItem()" /> <asp:LinkButton ID="lnkhdFilter" Text="HideFilter" Font-Underline="true" ForeColor="MidnightBlue" runat="server" OnClientClick="return hideFilterItem()" /> </td> <td align="right" style="height: 10px;"> Total Records found: <asp:Label ID="lblTotRecCount" runat="server" Font-Bold="True" Font-Size="10pt" ForeColor="Black" Text="0"></asp:Label> </td> <td align="right" style="width: 5%"> <asp:ImageButton ID="ExportToExcelButton" runat="server" ImageUrl="~/images/ExportToExcel.gif" ToolTip="Export to Excel" OnClick="ExportExcel_Click" /> </td> </tr> </table> </CommandItemTemplate> <Columns> ........ some columns here....... </Columns> <ItemStyle ForeColor="#3C5F22" Font-Size="8pt" BackColor="White" BorderWidth="0px" BorderColor="White" /> <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true" /> </MasterTableView> <ClientSettings AllowColumnsReorder="true"> <ClientEvents OnGridCreated="GridCreated" /> <Scrolling AllowScroll="true" UseStaticHeaders="true" /> <Resizing AllowColumnResize="true" /> </ClientSettings> </telerik:RadGrid> </div>function showFilterItem() { $find('<%=gvPjtMnt.ClientID %>').get_masterTableView().showFilterItem(); document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkhdFilter').style.display = 'block'; document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkshwFilter').style.display = 'none'; return false;}function hideFilterItem() { document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkhdFilter').style.display = 'none'; document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkshwFilter').style.display = 'block'; $find('<%=gvPjtMnt.ClientID %>').get_masterTableView().hideFilterItem(); return false;}function GridCreated(sender, args) { sender.get_masterTableView().hideFilterItem();}protected void gvPjtMnt_ItemCreated(object sender, GridItemEventArgs e) { try { if (e.Item is GridCommandItem) { LinkButton st = (LinkButton)e.Item.FindControl("lnkhdFilter"); st.Style["display"] = "none"; } } catch (Exception ex) { } }
function showFilterItem() { $find('<%=gvPjtMnt.ClientID %>').get_masterTableView().showFilterItem(); document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkhdFilter').style.display = 'block'; document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkshwFilter').style.display = 'none'; return false;}function hideFilterItem() { document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkhdFilter').style.display = 'none'; document.getElementById('ctl00_PagePlaceholder_gvPjtMnt_ctl00_ctl02_ctl00_lnkshwFilter').style.display = 'block'; $find('<%=gvPjtMnt.ClientID %>').get_masterTableView().hideFilterItem(); return false;}function GridCreated(sender, args) { sender.get_masterTableView().hideFilterItem();}<div style="width: 98%; overflow: auto; overflow-y: hidden"> <telerik:RadGrid ID="gvPjtMnt" runat="server" Height="600px" AutoGenerateColumns="false" BorderWidth="2px" BorderStyle="Solid" BackColor="White" AllowPaging="True" PagerStyle-AlwaysVisible="true" PageSize="20" AllowSorting="True" AllowFilteringByColumn="true" OnNeedDataSource="gvPjtMnt_OnNeedDataSource" OnItemCommand="gvPjtMnt_ItemCommand" OnItemCreated="gvPjtMnt_ItemCreated" EnableViewState="true"> <HeaderStyle Height="20px" BackColor="#004000" Font-Size="8pt" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" BorderColor="White" BorderWidth="1px" /> <AlternatingItemStyle Font-Size="8pt" BackColor="#F5F5E9" HorizontalAlign="Center" BorderWidth="1px" BorderColor="White" /> <ItemStyle HorizontalAlign="Center" /> <MasterTableView GridLines="None" CommandItemDisplay="Top" DataKeyNames="ProjectId" HorizontalAlign="Center" AllowFilteringByColumn="true"> <CommandItemTemplate> <table style="width: 100%"> <tr> <td align="right" style="width: 80%"> <asp:LinkButton ID="lnkshwFilter" Text="ShowFilter" Font-Underline="true" ForeColor="MidnightBlue" runat="server" OnClientClick="return showFilterItem()" /> <asp:LinkButton ID="lnkhdFilter" Text="HideFilter" Font-Underline="true" ForeColor="MidnightBlue" runat="server" OnClientClick="return hideFilterItem()" /> </td> <td align="right" style="height: 10px;"> Total Records found: <asp:Label ID="lblTotRecCount" runat="server" Font-Bold="True" Font-Size="10pt" ForeColor="Black" Text="0"></asp:Label> </td> <td align="right" style="width: 5%"> <asp:ImageButton ID="ExportToExcelButton" runat="server" ImageUrl="~/images/ExportToExcel.gif" ToolTip="Export to Excel" OnClick="ExportExcel_Click" /> </td> </tr> </table> </CommandItemTemplate> <Columns> <telerik:GridBoundColumn DataField="ProjectId" UniqueName="ProjectId" Visible="false"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="LOB" DataField="LOB" UniqueName="LOB"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Division Name" DataField="Division" UniqueName="Division"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Region Name" DataField="MarketName" UniqueName="MarketName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Project Name" DataField="ProjectName" UniqueName="ProjectName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Project Manager Name" DataField="ProjectMgrName" UniqueName="ProjectMgrName"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Number Of Sites Received" DataField="NumSitesReceived" UniqueName="NumSitesReceived"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Accept Service Order Date" DataField="AcceptServiceOrderTaskCompleteDate" UniqueName="AcceptServiceOrderTaskCompleteDate" DataFormatString="{0:MM/dd/yyyy}"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="PTD" DataField="PTD" UniqueName="PTD" DataFormatString="{0:MM/dd/yyyy}"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Health Reason" DataField="HealthReason" UniqueName="HealthReason"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Project Health" DataField="ProjectHealth" UniqueName="ProjectHealth"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Customer Signed Date" DataField="CustomerSignedDate" UniqueName="CustomerSignedDate" DataFormatString="{0:MM/dd/yyyy}"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="OA Complete Date" DataField="OACompleteDate" UniqueName="OACompleteDate" DataFormatString="{0:MM/dd/yyyy}"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Customer Requested Due Date" DataField="CustomerRequestedDueDate" UniqueName="CustomerRequestedDueDate" DataFormatString="{0:MM/dd/yyyy}"> </telerik:GridBoundColumn> <telerik:GridBoundColumn HeaderText="Last Note Added" DataField="LastNoteAdded" UniqueName="LastNoteAdded"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn UniqueName="EditRows" HeaderStyle-Width="3%" ItemStyle-Width="3%" AllowFiltering="false"> <ItemTemplate> <asp:ImageButton runat="server" ID="EditPMTsk" CommandName="EditRow" ImageUrl="Images/edit-icon.png" ImageAlign="Middle" ToolTip="Edit Task" /> </ItemTemplate> </telerik:GridTemplateColumn> </Columns> <ItemStyle ForeColor="#3C5F22" Font-Size="8pt" BackColor="White" BorderWidth="0px" BorderColor="White" /> <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true" /> </MasterTableView> <ClientSettings AllowColumnsReorder="true"> <ClientEvents OnGridCreated="GridCreated" /> <Scrolling AllowScroll="true" UseStaticHeaders="true" /> <Resizing AllowColumnResize="true" /> </ClientSettings> </telerik:RadGrid> </div>protected void gvPjtMnt_ItemCreated(object sender, GridItemEventArgs e){ try { if (e.Item is GridCommandItem) { LinkButton st = (LinkButton)e.Item.FindControl("lnkhdFilter"); st.Style["display"] = "none"; } } catch (Exception ex) { }}
<telerik:RadScheduler runat="server" ID="radSchAppointments" Width="1100px" Height="700px" DayStartTime="08:00:00" DayEndTime="20:00:00" TimeZoneOffset="03:00:00" DataKeyField="ID" DataSubjectField="Subject" DataStartField="Start" DataEndField="End" DataRecurrenceField="RecurrenceRule" DataRecurrenceParentKeyField="RecurrenceParentId" DataSourceID="edsAppointments" SelectedView="MonthView"> <AdvancedForm Modal="true" /> <TimelineView UserSelectable="false" /> <TimeSlotContextMenuSettings EnableDefault="true" /> <AppointmentContextMenuSettings EnableDefault="true" /> </telerik:RadScheduler> <asp:EntityDataSource ID="edsAppointments" runat="server" ConnectionString="name=StoneFalconEntities" DefaultContainerName="StoneFalconEntities" EnableDelete="True" EnableInsert="True" EnableUpdate="True" EntitySetName="Appointments"> </asp:EntityDataSource>CREATE TABLE [dbo].[Appointments]( [ID] [int] IDENTITY(1,1) NOT NULL, [Subject] [nvarchar](200) NULL, [Start] [datetime] NULL, [End] [datetime] NULL, [RoomID] [int] NULL, [UserID] [int] NULL, [RecurrenceRule] [nvarchar](50) NULL, [RecurrenceParentID] [int] NULL, CONSTRAINT [PK_Appointments] PRIMARY KEY CLUSTERED