or
<telerik:RadGrid ID="RadGrid1" DataSourceID="SqlDataSource1" runat="server" OnUpdateCommand="RadGrid1_UpdateCommand" ShowStatusBar="true" AutoGenerateColumns="False" AllowSorting="True" AllowMultiRowSelection="False" AllowPaging="False" AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" OnItemUpdated="RadGrid1_ItemUpdated" OnItemDeleted="RadGrid1_ItemDeleted" OnItemInserted="RadGrid1_ItemInserted" OnInsertCommand="RadGrid1_InsertCommand" OnItemDataBound="RadGrid1_ItemDataBound" OnItemCreated="RadGrid1_ItemCreated" Width="950"> <MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="ID" AllowMultiColumnSorting="True" Width="100%" CommandItemDisplay="Top" Name="Questions"> <DetailTables> <telerik:GridTableView DataKeyNames="ID" DataSourceID="SqlDataSource2" Width="100%" runat="server" CommandItemDisplay="Top" Name="Answers"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="QuestionID" MasterKeyField="ID"></telerik:GridRelationFields> </ParentTableRelation> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn1"> <HeaderStyle Width="20px"></HeaderStyle> <ItemStyle CssClass="MyImageButton"></ItemStyle> </telerik:GridEditCommandColumn> <telerik:GridBoundColumn SortExpression="QuestionID" HeaderText="Question" HeaderButtonType="TextButton" DataField="QuestionID" UniqueName="QuestionID" ReadOnly="true"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="AnswerText" HeaderText="Answer Text" HeaderButtonType="TextButton" DataField="AnswerText" UniqueName="AnswerText"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="PanelAmount" HeaderText="Panel Amount" HeaderButtonType="TextButton" DataField="PanelAmount" UniqueName="PanelAmount"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn SortExpression="IsEnd" HeaderText="Is End" HeaderButtonType="TextButton" DataField="IsEnd" UniqueName="IsEnd"> <ItemTemplate> <asp:Label ID="LabelIsEnd" runat="server"><%# DataBinder.Eval(Container.DataItem, "IsEnd")%></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:CheckBox ID="CheckBoxIsEnd" runat="server" Checked='<%#Eval("IsEnd") %>' /> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn SortExpression="JumpToQuestion" HeaderText="Jump To Question" HeaderButtonType="TextButton" DataField="JumpToQuestion" UniqueName="JumpToQuestion"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn SortExpression="StartSurvey" HeaderText="Start Survey" HeaderButtonType="TextButton" DataField="StartSurvey" UniqueName="StartSurvey"> <ItemTemplate> <asp:Label ID="LabelStartSurvey" runat="server"><%# DataBinder.Eval(Container.DataItem, "StartSurvey")%></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:CheckBox ID="CheckBoxStartSurvey" runat="server" Checked='<%#Eval("StartSurvey") %>' /> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="DeleteColumnAnswer"> </telerik:GridButtonColumn> </Columns> </telerik:GridTableView> </DetailTables> <Columns> <telerik:GridEditCommandColumn ButtonType="ImageButton" UniqueName="EditCommandColumn1"> <HeaderStyle Width="20px"></HeaderStyle> <ItemStyle CssClass="MyImageButton"></ItemStyle> </telerik:GridEditCommandColumn> <telerik:GridBoundColumn SortExpression="ID" HeaderText="ID" HeaderButtonType="TextButton" DataField="ID" UniqueName="ID" ReadOnly="true"> </telerik:GridBoundColumn> <telerik:GridBoundColumn SortExpression="QuestionText" HeaderText="Question Text" HeaderButtonType="TextButton" DataField="QuestionText" UniqueName="QuestionText"> </telerik:GridBoundColumn> <telerik:GridTemplateColumn SortExpression="QuestionType" HeaderText="Question Type" HeaderButtonType="TextButton" DataField="QuestionType" UniqueName="QuestionType"> <ItemTemplate> <asp:Label ID="LabelQuestionType" runat="server"><%# DataBinder.Eval(Container.DataItem, "QuestionType")%></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:DropDownList ID="DropDownListQUestionType" runat="server"></asp:DropDownList> <%--<asp:DropDownList ID="DropDownListQUestionType" runat="server" SelectedValue='<%#Eval("QuestionType") %>'></asp:DropDownList>--%> </EditItemTemplate> </telerik:GridTemplateColumn> <telerik:GridBoundColumn SortExpression="QuestionPosition" HeaderText="Question Position" HeaderButtonType="TextButton" DataField="QuestionPosition" UniqueName="QuestionPosition"> </telerik:GridBoundColumn> <telerik:GridButtonColumn CommandName="Delete" Text="Delete" UniqueName="DeleteColumnQuestion"> </telerik:GridButtonColumn> </Columns> </MasterTableView> </telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Local_TypingTool_NewConnectionString %>"
UpdateCommand="UPDATE [Screener_Questions] SET [QuestionText] = @QuestionText, [QuestionType] = @QuestionType, [QuestionPosition] = @QuestionPosition WHERE [ID] = @ID"
SelectCommand="SELECT [ID], [QuestionText], [QuestionType], [QuestionPosition] FROM Screener_Questions WHERE [Survey_ID] = @Survey_ID"
InsertCommand="INSERT INTO [Screener_Questions] ([Survey_ID], [QuestionText], [QuestionType], [QuestionPosition]) VALUES (@Survey_ID, @QuestionText, @QuestionType, @QuestionPosition)"
DeleteCommand="DELETE FROM [Screener_Questions] WHERE [ID] = @ID">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="Survey_ID" Type="Int32" />
<asp:Parameter Name="QuestionText" Type="String" />
<asp:Parameter Name="QuestionType" Type="Int32" />
<asp:Parameter Name="QuestionPosition" Type="Int32" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="QuestionText" Type="String" />
<asp:Parameter Name="QuestionType" Type="Int32" />
<asp:Parameter Name="QuestionPosition" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:Parameter Name="Survey_ID" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
protected void RadGrid1_UpdateCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { GridEditableItem editedItem = e.Item as GridEditableItem; DropDownList list = editedItem.FindControl("DropDownListQUestionType") as DropDownList; Session["updatedValueQUestionType"] = list.SelectedValue; }
<telerik:RadGrid ID="RadGridEmployeeCost" runat="server" AllowSorting="True" AllowPaging="true" AllowFilteringByColumn="true" CellSpacing="0" GridLines="None" HeaderStyle-Font-Bold="true" Skin="Web20" OnNeedDataSource="RadGridEmployeeCost_NeedDataSource" ShowGroupPanel="true" OnColumnCreated="RadGridEmployeeCost_ColumnCreated"> <ClientSettings AllowDragToGroup="True" /></telerik:RadGrid>protected void RadGridEmployeeCost_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { ObjCon.Open(); SqlCommand ObjCmd = new SqlCommand("SELECT name,address,TelPhone,EmailId,Qualification FROM WorkSummary", ObjCon); ObjCmd.ExecuteNonQuery(); SqlDataAdapter ObjDa = new SqlDataAdapter(ObjCmd); DataSet ds = new DataSet(); ObjDa.Fill(ds); RadGridEmployeeCost.DataSource = ds; } } protected void RadGridEmployeeCost_ColumnCreated(object sender, GridColumnCreatedEventArgs e) { if ((e.Column is GridBoundColumn && e.Column.UniqueName == "TelPhone" || e.Column.UniqueName == "EmailId" || e.Column.UniqueName == "Qualification")) { GridBoundColumn column = e.Column as GridBoundColumn; column.AllowFiltering = false; } }Private Sub SetFilters(ByVal grid As RadGrid) grid.MasterTableView.AllowFilteringByColumn = gridConfiguration.EnableHeaderFiltering If gridConfiguration.EnableHeaderFiltering Then grid.MasterTableView.CommandItemTemplate = New RadGridCommandItemFilterTemplate End IfEnd SubFriend Class RadGridCommandItemFilterTemplate Implements ITemplate Public showHideFilter As RadButton Public Sub New() MyBase.New() End Sub Public Sub InstantiateIn(ByVal container As Control) Implements ITemplate.InstantiateIn showHideFilter = New RadButton With {.ID = "showHideFilter", .Text = "Show / Hide Filters", .CommandName = "ShowHideFilters", .OnClientCheckedChanged = "showHideFilters()"} container.Controls.Add(showHideFilter) End SubEnd Class <telerik:RadScriptManager ID="ScriptManager" runat="server"> </telerik:RadScriptManager> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="ConfigureGrid"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="ConfigureGrid" LoadingPanelID="AjaxLoadingPanel" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager> <telerik:RadGrid runat="server" ID ="ConfigureGrid" GridLines="None" AutoGenerateColumns="false" Skin="WebBlue"/> <telerik:RadAjaxLoadingPanel ID="AjaxLoadingPanel" runat="server"/> <asp:SqlDataSource ID="PrimaryDataSource" runat="server"/></form><script type="text/javascript"> function showFilterItem() { var grid = $find("<%=ConfigureGrid.ClientID%>"); if (grid) { grid.get_masterTableView().showFilterItem(); } } function hideFilterItem() { var grid = $find("<%=ConfigureGrid.ClientID%>"); if (grid) { grid.get_masterTableView().hideFilterItem(); } } function showHideFilters() { var radButton = document.getElementById("showHideFilter"); if (radButton) { if (radButton.checked) { showFilterItem(); } else { hideFilterItem(); } } }</script><telerik:PivotGridAggregateField DataField="StatusText" Aggregate="Count" Caption="Counts" UniqueName="Counts" IsHidden="false"></telerik:PivotGridAggregateField><telerik:RadPivotGrid ID="RadPivotGrid_DataView" runat="server" ConfigurationPanelSettings-DefaultDeferedLayoutUpdate="false" Height="100%" AggregatesPosition="Rows" AllowSorting="True" OnItemCommand="RadPivotGrid_DataView_ItemCommand" OnCellCreated="RadPivotGrid_DataView_CellCreated" DataSourceID="Sql_Contract_Details" EnableToolTips="True" EnableZoneContextMenu="True" EnableConfigurationPanel="True" OnFieldCreated="RadPivotGrid_DataView_FieldCreated" Skin="Metro" OnCellDataBound="RadPivotGrid_DataView_CellDataBound" Culture="en-GB" OnItemNeedCalculation="RadPivotGrid_DataView_ItemNeedCalculation" AllowPaging="True" PageSize="30"> <PagerStyle ChangePageSizeButtonToolTip="Change Page Size" PageSizeControlType="RadComboBox" AlwaysVisible="True" /> <Fields>...</Fields> <ClientSettings EnableFieldsDragDrop="True"> <Scrolling AllowVerticalScroll="True"></Scrolling> </ClientSettings> <ConfigurationPanelSettings EnableOlapTreeViewLoadOnDemand="True" DefaultDeferedLayoutUpdate="True" LayoutType="OneByFour"></ConfigurationPanelSettings> </telerik:RadPivotGrid>
<ClientSettings AllowColumnsReorder="True" ReorderColumnsOnClient="True" EnableRowHoverStyle="True" AllowColumnHide="False">
<Selecting AllowRowSelect="False" />
<Resizing AllowColumnResize="True" AllowResizeToFit="True" ResizeGridOnColumnResize="False" />
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
<ClientMessages DragToGroupOrReorder="Click the Header to Sort; Drag to Reorder; Right Click for Context Menu" />
</ClientSettings>
...
<ColumnGroups> <telerik:GridColumnGroup HeaderText="MHO Portal Access" Name="User" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup> <telerik:GridColumnGroup HeaderText="Census Tract Exclusions" Name="CT" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup> <telerik:GridColumnGroup HeaderText="Rental Listings" Name="Rental" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup> <telerik:GridColumnGroup HeaderText="Real Estate Professionals" Name="REP" HeaderStyle-HorizontalAlign="Center"></telerik:GridColumnGroup></ColumnGroups><Columns> <telerik:GridBoundColumn DataField="MHA" HeaderText="MHA" SortExpression="MHA" UniqueName="MHA" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" FilterControlWidth="75px"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MHA_MHO_ID" HeaderText="MHA_MHO_ID" SortExpression="MHA_MHO_ID" UniqueName="MHA_MHO_ID" Visible="false"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Service_Name" FilterControlAltText="Filter Service_Name column" HeaderTooltip="Service" HeaderText="Service" SortExpression="Service_Name" UniqueName="Service_Name" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" FilterControlWidth="75px"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Is_Primary" FilterControlAltText="Filter Is_Primary column" HeaderTooltip="Role" HeaderText="Role" SortExpression="Is_Primary" UniqueName="Is_Primary" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" FilterControlWidth="75px"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MHO_Name" FilterControlAltText="Filter MHO_Name column" HeaderTooltip="MHO Name" HeaderText="MHO Name" SortExpression="MHO_Name" UniqueName="MHO_Name" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" FilterControlWidth="75px"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="POC" HeaderText="POC" SortExpression="POC" UniqueName="POC" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" Display="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Title" HeaderText="Title" SortExpression="Title" UniqueName="Title" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" Display="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Phone_Number" HeaderText="Phone" SortExpression="Phone_Number" UniqueName="Phone_Number" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" Display="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Email" HeaderText="Email" SortExpression="Email" UniqueName="Email" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False" Display="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="First_Login" HeaderText="First Login" ColumnGroupName="User" SortExpression="First_Login" UniqueName="First_Login" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Last_Login" HeaderText="Last Login" ColumnGroupName="User" SortExpression="Last_Login" UniqueName="Last_Login" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Submission" HeaderText="Submit" ColumnGroupName="CT" SortExpression="CT_Submission" UniqueName="CT_Submission" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Total" HeaderText="Total" ColumnGroupName="CT" SortExpression="CT_Total" UniqueName="CT_Total" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Included" HeaderText="In." ColumnGroupName="CT" SortExpression="CT_Included" UniqueName="CT_Included" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Excluded" HeaderText="Ex." ColumnGroupName="CT" SortExpression="CT_Excluded" UniqueName="CT_Excluded" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Neutral" HeaderText="NA" ColumnGroupName="CT" SortExpression="CT_Neutral" UniqueName="CT_Neutral" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Percent_Excluded" HeaderText="% Ex" ColumnGroupName="CT" SortExpression="CT_Percent_Excluded" UniqueName="CT_Percent_Excluded" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="CT_Percent_Updated" HeaderText="% Updated" ColumnGroupName="CT" SortExpression="CT_Percent_Updated" UniqueName="CT_Percent_Updated" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Rental_Submission" HeaderText="Submit" ColumnGroupName="Rental" SortExpression="Rental_Submission" UniqueName="Rental_Submission" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Rental_Total" HeaderText="Total" ColumnGroupName="Rental" SortExpression="Rental_Total" UniqueName="Rental_Total" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="Rental_Current" HeaderText="Current" ColumnGroupName="Rental" SortExpression="Rental_Current" UniqueName="Rental_Current" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="REP_Submission" HeaderText="Submit" ColumnGroupName="REP" SortExpression="REP_Submission" UniqueName="REP_Submission" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="REP_Total" HeaderText="Total" ColumnGroupName="REP" SortExpression="REP_Total" UniqueName="REP_Total" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="REP_Current" HeaderText="Current" ColumnGroupName="REP" SortExpression="REP_Current" UniqueName="REP_Current" Visible="True" FilterControlWidth="75px" AutoPostBackOnFilter="true" CurrentFilterFunction="Contains" ShowFilterIcon="False"></telerik:GridBoundColumn></Columns>