or
I need to enhance the application and the table structure cannot be amend.
Table structure:
ID StaffID Type========================1 1 12 1 2 3 1 34 2 25 2 36 3 1
I want to group same StaffID into one gridview row and then databind the checkbox (Type 1, Type 2, Type3) based on the value of "Type" column.
Proposed Gridview :
StaffID StaffName Type 1 Type 2 Type 3==============================================1 Amy [X] [X] [X]2 John [ ] [X] [X]3 Chris [X] [ ] [ ] Moreover, How can i insert/delete record if user check/uncheck the checkbox in gridview ?
Thanks.
<telerik:RadTabStrip runat="server" ID="RadTabStrip3" MultiPageID="RadMultiPage2" Orientation="VerticalLeft" Skin="Windows7" Width="200px" SelectedIndex="0" Align="Left" > <Tabs> <telerik:RadTab Height="30px" Text="Funding Opportunity Announcements" ></telerik:RadTab> <telerik:RadTab Height="30px" Text="Application Requirements" ></telerik:RadTab> <telerik:RadTab Height="60px" Text="Objective Review of Grant Applications, Selections, and Award" ></telerik:RadTab> </Tabs></telerik:RadTabStrip>Protected Sub gridJourneys_ExcelMLExportStylesCreated(ByVal source As Object, ByVal e As Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLStyleCreatedArgs) Handles gridJourneys.ExcelMLExportStylesCreated For Each style As Telerik.Web.UI.GridExcelBuilder.StyleElement In e.Styles If style.Id = "headerStyle" Then style.FontStyle.Bold = True style.FontStyle.Color = System.Drawing.Color.Gainsboro style.InteriorStyle.Color = System.Drawing.Color.Wheat style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid ElseIf style.Id = "itemStyle" Then style.InteriorStyle.Color = System.Drawing.Color.WhiteSmoke style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid ElseIf style.Id = "alternatingItemStyle" Then style.InteriorStyle.Color = System.Drawing.Color.LightGray style.InteriorStyle.Pattern = Telerik.Web.UI.GridExcelBuilder.InteriorPatternType.Solid End If Next End SubProtected Sub gridJourneys_ExcelExportCellFormatting(ByVal source As Object, ByVal e As Telerik.Web.UI.ExcelExportCellFormattingEventArgs) Handles gridJourneys.ExcelExportCellFormatting If e.FormattedColumn.UniqueName = "StartLocation" Then e.Cell.Style("color") = "red" End If If e.FormattedColumn.UniqueName = "ExpandColumn" Then e.Cell.Controls.Clear() End If End Sub