protected void RadGridQuestions_ItemCreated(object sender, GridItemEventArgs e) { if ((e.Item is GridEditFormItem || e.Item is GridEditFormInsertItem) && e.Item.IsInEditMode) { if (e.Item.OwnerTableView.Columns.FindByUniqueNameSafe("Test_Type_Id") == null) return; RadComboBox ddlTestType = (e.Item as GridEditableItem)["Test_Type_Id"].Controls[0] as RadComboBox; // Attach SelectedIndexChanged event for the dropdownlist control ddlTestType.AutoPostBack = true; ddlTestType.SelectedIndexChanged += new RadComboBoxSelectedIndexChangedEventHandler(TestTypeOfQuestion_SelectedIndexChanged); TestTypeOfQuestion_SelectedIndexChanged(ddlSubObjective, null); ddlTestType.PreRender += new EventHandler(ddlTestType_PreRender); } } private void ddlTestType_PreRender(object sender, EventArgs e) { TestTypeOfQuestion_SelectedIndexChanged(sender, null); } /// <summary> /// Changed test type so update objective and sub objective only relevant for that exam type /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void TestTypeOfQuestion_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e) { // First reference the edited grid item through the NamingContainer attribute GridEditableItem editedItem = (sender as RadComboBox).NamingContainer as GridEditableItem; // The dropdown list will be the first control in the Controls collection of the corresponding cell string strTestTypeId = (editedItem["Test_Type_Id"].Controls[0] as RadComboBox).SelectedValue; if (string.IsNullOrEmpty(strTestTypeId)) return; RadComboBox ddlKeyElement = editedItem["Question_Category_Id"].Controls[0] as RadComboBox; SqlDataSourceQuestionCatLookupEdit.SelectParameters["Test_Type_Id"].DefaultValue = strTestTypeId; ddlKeyElement.ClearSelection(); ddlKeyElement.DataSource = SqlDataSourceQuestionCatLookupEdit; ddlKeyElement.DataBind(); RadComboBox ddlObjective = editedItem["Objective_Id"].Controls[0] as RadComboBox; SqlDataSourceObjectiveLookupEdit.SelectParameters["Test_Type_Id"].DefaultValue = strTestTypeId; ddlObjective.ClearSelection(); ddlObjective.DataSource = SqlDataSourceObjectiveLookupEdit; ddlObjective.DataBind(); RadComboBox ddlSubObjective = editedItem["Sub_Objective_Id"].Controls[0] as RadComboBox; SqlDataSourceSubObjectiveLookupEdit.SelectParameters["Test_Type_Id"].DefaultValue = strTestTypeId; ddlSubObjective.ClearSelection(); ddlSubObjective.DataSource = SqlDataSourceSubObjectiveLookupEdit; ddlSubObjective.DataBind(); }<div class="rsContentScrollArea" style="position: relative; overflow-y: scroll; width: 1529px; height: 700px; overflow: auto;" _events="[object Object]" sizcache="25" sizset="0">I keep getting the dredded "Conversion from type 'DBNull' to type 'Boolean' is not valid." error and cannot seem to get around it.
I was getting it when I clicked on Add new record and worked around that by adding default values in code behind:
If (e.CommandName = Telerik.Web.UI.RadGrid.InitInsertCommandName) Then 'cancel the default operation e.Canceled = True 'Prepare an IDictionary with the predefined values Dim newValues As System.Collections.Specialized.ListDictionary = New System.Collections.Specialized.ListDictionary() 'set default checked state for checkbox inside the EditItemTemplate newValues("Is_Admin") = False newValues("Is_Disabled") = False 'Insert the item and rebind e.Item.OwnerTableView.InsertItem(newValues) End If<div id="ParentDivElement" style="height: 100%;">
<table cellpadding="0" cellspacing="0" class="style1">
<tr>
<td>
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
hello</td>
</tr>
<tr>
<td>
<telerik:RadSplitter ID="RadSplitter1" LiveResize="true" VisibleDuringInit="false" runat="server" Height="100%"
Width="100%">
<telerik:RadPane ID="navigationPane" runat="server" Height="100%" Width="150">
<telerik:RadPanelBar ID="RadPanelBar1" Runat="server"
ExpandMode="FullExpandedItem" Height="100%"
Skin="Office2007">
<Items>
<telerik:RadPanelItem runat="server" Text="Application">
<Items>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 1">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 2">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 3">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 4">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 5">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 6">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 7">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 8">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 9">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 10">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 11">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 12">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 13">
</telerik:RadPanelItem>
<telerik:RadPanelItem runat="server" Text="Child RadPanelItem 14">
</telerik:RadPanelItem>
</Items>
</telerik:RadPanelItem>
</Items>
</telerik:RadPanelBar>
</telerik:RadPane>
<telerik:RadSplitBar ID="RadSplitbar1" runat="server" LiveResize="true"
CollapseMode="Forward" Height="100%" />
<telerik:RadPane ID="contentPane" runat="server" Scrolling="Y">
<asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">
</asp:ContentPlaceHolder>
</telerik:RadPane>
</telerik:RadSplitter>
</td>
</tr>
<tr>
<td>
</td>
</tr>
</table>
</div>
</form>
[assembly: WebResource("TelerikCustomSkins.TabStripTelerik.css", "text/css")] [assembly: WebResource("TelerikCustomSkins.TabStrip_Images.TabStripStates.png", "image/png")] [assembly: WebResource("TelerikCustomSkins.TabStrip_Images.TabStripStates_rtl.png", "image/png")] [assembly: WebResource("TelerikCustomSkins.TabStrip_Images.TabStripVStates.png", "image/png")]<telerik:RadTabStrip ID="RadTabStrip1" runat="server" CausesValidation="False" SelectedIndex="0" Skin="Telerik" EnableEmbeddedSkins="False"> <Tabs> <telerik:RadTab Text="Item 1"></telerik:RadTab> <telerik:RadTab Text="Item 2"></telerik:RadTab> <telerik:RadTab Text="Item 3"></telerik:RadTab> <telerik:RadTab Text="Item 4"></telerik:RadTab> <telerik:RadTab Text="Item 5"></telerik:RadTab> <telerik:RadTab Text="Item 6"></telerik:RadTab> </Tabs> </telerik:RadTabStrip>.RadTabStrip_Telerik .rtsLI, .RadTabStrip_Telerik .rtsLink { color: white; font: 12px/26px Arial, sans-serif; font-weight: bold; } .RadTabStripLeft_Telerik .rtsSeparator, .RadTabStripRight_Telerik .rtsSeparator { background: #828282; } /* <disabled tabs> */ .RadTabStrip_Telerik .rtsDisabled { color: #aaa; } /* </disabled tabs> */ /* <scrolling arrows> */ .RadTabStrip_Telerik .rtsNextArrow, .RadTabStrip_Telerik .rtsPrevArrow, .RadTabStrip_Telerik .rtsPrevArrowDisabled, .RadTabStrip_Telerik .rtsNextArrowDisabled { background-image: url('<%=WebResource("TelerikCustomSkins.TabStrip_Images.TabStripTabStripStates.png")%>'); } /* </scrolling arrows> */ /* <tab backgrounds> */ .RadTabStripTop_Telerik .rtsLevel { background-color: transparent; } .RadTabStripTop_Telerik .rtsLevel .rtsLink, .RadTabStripTop_Telerik .rtsLevel .rtsOut, .RadTabStripBottom_Telerik .rtsLevel .rtsLink, .RadTabStripBottom_Telerik .rtsLevel .rtsOut, .RadTabStripTop_Telerik_Baseline .rtsLevel, .RadTabStripBottom_Telerik_Baseline .rtsLevel { background-image: url('<%=WebResource("TelerikCustomSkins.TabStrip_Images.TabStripTabStripStates.png")%>'); } .RadTabStripLeft_Telerik .rtsLink, .RadTabStripRight_Telerik .rtsLink { background-image: url('<%=WebResource("TelerikCustomSkins.TabStrip_Images.TabStripTabStripVStates.png")%>'); } .RadTabStripLeft_Telerik .rtsLast .rtsLink, .RadTabStripRight_Telerik .rtsLast .rtsLink { border-bottom: 1px solid #898C95; } /* </tab backgrounds> */ /* <background positioning: overlapping tabs> */ /* <orientation: top> */ .RadTabStripTop_Telerik .rtsLink { background-position: 0 -52px; color: #96b3da; } .RadTabStripTop_Telerik .rtsFirst .rtsLink { background-position: 0 0; color: #96b3da; } .RadTabStripTop_Telerik .rtsOut { background-position: 100% -52px; } .RadTabStripTop_Telerik .rtsLast .rtsOut { background-position: 100% 0; } .RadTabStripTop_Telerik .rtsLI .rtsSelected { background-position: 0 -26px;color:white; } .RadTabStripTop_Telerik .rtsSelected .rtsOut { background-position: 100% -78px; } .RadTabStripTop_Telerik .rtsLI .rtsAfter { background-position: 0 -78px; } .RadTabStripTop_Telerik .rtsLast .rtsSelected .rtsOut { background-position: 100% -26px; } .RadTabStripTop_Telerik_Baseline .rtsLevel { background-position: 0 100%; background-repeat: repeat-x; } /* </orientation: top> */ /* <orientation: bottom> */ .RadTabStripBottom_Telerik .rtsLevel .rtsLink { background-position: 0 -130px; } .RadTabStripBottom_Telerik .rtsLevel .rtsFirst .rtsLink { background-position: 0 -182px; } .RadTabStripBottom_Telerik .rtsLevel .rtsOut { background-position: 100% -130px; } .RadTabStripBottom_Telerik .rtsLevel .rtsLast .rtsOut { background-position: 100% -182px; } .RadTabStripBottom_Telerik .rtsLevel .rtsLI .rtsSelected { background-position: 0 -156px; } .RadTabStripBottom_Telerik .rtsLevel .rtsSelected .rtsOut { background-position: 100% -104px; } .RadTabStripBottom_Telerik .rtsLevel .rtsLI .rtsAfter { background-position: 0 -104px; } .RadTabStripBottom_Telerik .rtsLevel .rtsLast .rtsSelected .rtsOut { background-position: 100% -156px; } .RadTabStripBottom_Telerik_Baseline .rtsLevel { background-position: 0 -599px; background-repeat: repeat-x; } /* </orientation: bottom> */ /* <orientation: right> */ .RadTabStripRight_Telerik .rtsUL .rtsLink, .RadTabStripRight_Telerik .rtsUL .rtsLI .rtsDisabled:hover { background-position: 100% 0; text-align: left; } .RadTabStripRight_Telerik .rtsUL .rtsLink:hover { background-position: 100% -200px; } .RadTabStripRight_Telerik .rtsUL .rtsSelected, .RadTabStripRight_Telerik .rtsUL .rtsSelected:hover { background-position: 100% -400px; } /* </orientation: right> */ /* <orientation: top (RTL)> */ .RadTabStripTop_Telerik_rtl .rtsLevel .rtsLink { padding-left: 0; padding-right: 9px; } .RadTabStripTop_Telerik_rtl .rtsLevel .rtsOut { padding-left: 9px; padding-right: 0; } .RadTabStripTop_Telerik_rtl .rtsLevel .rtsLink, .RadTabStripTop_Telerik_rtl .rtsLevel .rtsOut { background-image: url('<%=WebResource("TelerikCustomSkins.TabStrip_Images.TabStripTabStripStates_rtl.png")%>'); } .RadTabStripTop_Telerik_rtl .rtsLevel .rtsLink { background-position: 100% -52px; } .RadTabStripTop_Telerik_rtl .rtsLevel .rtsFirst .rtsLink { background-position: 100% 0; } .RadTabStripTop_Telerik_rtl .rtsLevel .rtsOut { background-position: 0 -52px; } .RadTabStripTop_Telerik_rtl .rtsLevel .rtsLast .rtsOut { background-position: 0 0; } .RadTabStripTop_Telerik_rtl .rtsLevel .rtsLI .rtsSelected { background-position: 100% -26px; } .RadTabStripTop_Telerik_rtl .rtsLevel .rtsSelected .rtsOut { background-position: 0 -78px; } .RadTabStripTop_Telerik_rtl .rtsLevel .rtsLI .rtsAfter { background-position: 100% -78px; } .RadTabStripTop_Telerik_rtl .rtsLevel .rtsLast .rtsSelected .rtsOut { background-position: 0 -26px; } /* </orientation: top (RTL)> */ /* </background positioning: overlapping tabs> */ /* <simplistic sub-item styles> */ .RadTabStrip_Telerik_SimpleSubItems .rtsLevel2, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel3, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel4 { background: #fff; } .RadTabStrip_Telerik_SimpleSubItems .rtsLevel2 .rtsSelected, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel3 .rtsSelected, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel4 .rtsSelected { text-decoration: underline; } .RadTabStrip_Telerik_SimpleSubItems .rtsLevel2 .rtsLink, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel2 .rtsOut, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel2 .rtsIn, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel3 .rtsLink, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel3 .rtsOut, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel3 .rtsIn, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel4 .rtsLink, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel4 .rtsOut, .RadTabStrip_Telerik_SimpleSubItems .rtsLevel4 .rtsIn { background: none; } /* </simplistic sub-item styles> */