<%@ Page language="C#"  ....
<%@ Register TagPrefix="Telerik" Namespace="Telerik.SharePoint.FieldEditor" Assembly="RadEditorSharePoint, Version=5.1.0.0, Culture=neutral, PublicKeyToken=1f131a624888eeed" %>

<asp:Content ContentPlaceholderID="PlaceHolderMain" runat="server">

 <Telerik:RadHtmlField FieldName="PublishingPageContent" runat="server" InputFieldLabel="Body" id="RichHtmlField"/>

</asp:Content>
<----------- PAGELAYOUT ----------->

When in displaymode it works fine, but when i go in edit mode I get the following exception:
 The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).
And the stack trace:

[HttpException (0x80004005): The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).]
   System.Web.UI.ControlCollection.Add(Control child) +11013946
   Telerik.Web.SkinRegistrar.RegisterCssReferences(ISkinnableControl _control) +1116
   Telerik.Web.UI.RadEditor.OnPreRender(EventArgs e) +16
   Telerik.SharePoint.MOSSRadEditor.OnPreRender(EventArgs e) +54
   System.Web.UI.Control.PreRenderRecursiveInternal() +108
...

The solution deployment and feature activation is done without errors. Any ideas on what can cause this behavior?

telerik:RadAjaxLoadingPanel ID="LoadingPanel1" runat="server" Transparency="30"

BackColor="#E0E0E0">

<asp:Image Style="margin-top: 10px" ID="Image1" runat="server" AlternateText="Loading..."

BorderWidth="0px" ImageUrl="~/images/loading.gif"></asp:Image>

</telerik:RadAjaxLoadingPanel>

<p class="caption">

<span>Search / List Contracts</span>

</p>

<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" LoadingPanelID="LoadingPanel1">

<

div class="boxbg aleft">

<p class="minicaption">

Search Criteria

</p>

<p class="note">

Enter Search Criteria and click Search button to list units. To list all units,

do not enter any search criteria.

</p>

<fieldset>

<%

-- ContractHolderName--%>

<label class="formlabel">

<span class="reqfld"></span>Contract Holder Name</label>

<telerik:RadComboBox ID="raddropdownlistContractHolder" runat="server" Width="300px"

Height="200px" Skin="Web20" DataTextField="Name" DataValueField="ID" AppendDataBoundItems="true"

EnableEmbeddedSkins="false" MarkFirstMatch="true">

</telerik:RadComboBox>

<br />

<%

-- Site Name--%>

<label class="formlabel">

<span class="reqfld"></span>Site Name</label>

<telerik:RadComboBox ID="raddropdownlistSiteName" runat="server" Width="300px" Height="200px"

Skin="Web20" DataTextField="Name" DataValueField="ID" AppendDataBoundItems="true"

EnableEmbeddedSkins="false" MarkFirstMatch="true">

</telerik:RadComboBox>

<br />

<%

--Specialty--%>

<label for="dropdownlistSpecialties" class="formlabel left">

Specialty

</label>

<telerik:RadComboBox ID="raddropdownlistSpecialties" runat="server" Width="300px"

Height="200px" Skin="Web20" DataTextField="DisplayName" DataValueField="DisplayID"

AppendDataBoundItems="true" EnableEmbeddedSkins="false" MarkFirstMatch="true">

</telerik:RadComboBox>

<br />

<%

--Skills--%>

<label for="dropdownlistSkills" class="formlabel left">

Skills

</label>

<telerik:RadComboBox ID="raddropdownlistSkills" runat="server" Width="300px" Height="200px"

Skin="Web20" DataTextField="DisplayName" DataValueField="DisplayID" AppendDataBoundItems="true"

EnableEmbeddedSkins="false" MarkFirstMatch="true">

</telerik:RadComboBox>

<%

--Report Type--%>

<label for="dropdownlistSkills" class="formlabel left">

Create Report as

</label>

<asp:RadioButtonList ID="radioReport" runat="server" CssClass="formlabel1" RepeatDirection="Horizontal">

<asp:ListItem Text="Adobe PDF" Value="pdf" Selected></asp:ListItem>

<asp:ListItem Text="Microsoft Excel" Value="xls"></asp:ListItem>

</asp:RadioButtonList>

</fieldset>

</div>

<div class="btnpnl">

<asp:ImageButton ID="buttonReport" runat="server" CausesValidation="false" OnClick="buttonReport_Click"

AlternateText="Report" ImageUrl="~/Images/report_btn.gif" OnClientClick="Javascript:Auto() ;" />

</div>

</telerik:RadAjaxPanel>

protected void buttonReport_Click(object sender, EventArgs e)

{

try

{

// this.FillBusinessObjects();

//IList<ClinicalUnit> clinicalUnits = ReportController.RetrieveUnitReportForSearchData();

// radgridUnits.DataSource = clinicalUnits;

// radgridUnits.DataBind();

DataSet dataSetUnit = new DataSet();

DataTable dataTableUnit = ConstructDataTableUnit();

this.FillBusinessObjects();

IList<ClinicalUnit> clinicalUnits = ReportController.RetrieveUnitReportForSearchData();

//radgridUnits.DataSource = clinicalUnits;

//radgridUnits.DataBind();

if (clinicalUnits.Count > 0)

{

for (int i = 0; i < clinicalUnits.Count; i++)

{

DataRow dataRowUnit = dataTableUnit.NewRow();

dataRowUnit[

"UnitID"] = clinicalUnits[i].ID.ToString();

dataRowUnit[

"UnitName"] = clinicalUnits[i].Name.ToString();

dataRowUnit[

"SiteName"] = clinicalUnits[i].Site.Name.ToString();

dataRowUnit[

"Status"] = clinicalUnits[i].StatusText.ToString();

dataRowUnit[

"Specialty"] = clinicalUnits[i].Specialty.Name.ToString();

dataRowUnit[

"Skills"] = clinicalUnits[i].Skill.Name.ToString();

dataRowUnit[

"Population"] = clinicalUnits[i].Population.Name.ToString();

dataRowUnit[

"AcceptGrad"] = clinicalUnits[i].IsGraduationText.ToString();

dataRowUnit[

"AcceptUnderGraduation"] = clinicalUnits[i].IsUnderGraduationText.ToString();

dataRowUnit[

"ServiceLearning"] = clinicalUnits[i].IsServiceLearningText.ToString();

dataRowUnit[

"NoOfStudents"] = clinicalUnits[i].NoOfStudent.ToString();

dataRowUnit[

"UnitContactName"] = clinicalUnits[i].ContactFirstName.ToString();

dataRowUnit[

"UnitContactPhone"] = clinicalUnits[i].ContactPhone.ToString();

dataRowUnit[

"UnitContactEmail"] = clinicalUnits[i].ContactEMail.ToString();

dataTableUnit.Rows.Add(dataRowUnit);

}

dataSetUnit.Tables.Add(dataTableUnit);

ExportReport(dataSetUnit);

}

else

ClientScript.RegisterStartupScript(

this.GetType(), "onclick", "<script language='javascript'>alert('No Records Found');</script>");

}

catch (SofturaException softuraException)

{

// throw softuraException;

}

catch (Exception exception)

{

// throw exception;

}

}

private DataTable ConstructDataTableUnit()

{

DataTable dtUnit = new DataTable("dataTableUnit");

dtUnit.Columns.Add(

"UnitID");

dtUnit.Columns.Add(

"UnitName");

dtUnit.Columns.Add(

"SiteName");

dtUnit.Columns.Add(

"Status");

dtUnit.Columns.Add(

"Specialty");

dtUnit.Columns.Add(

"Skills");

dtUnit.Columns.Add(

"Population");

dtUnit.Columns.Add(

"AcceptGrad");

dtUnit.Columns.Add(

"AcceptUnderGraduation");

dtUnit.Columns.Add(

"ServiceLearning");

dtUnit.Columns.Add(

"NoOfStudents");

dtUnit.Columns.Add(

"UnitContactName");

dtUnit.Columns.Add(

"UnitContactPhone");

dtUnit.Columns.Add(

"UnitContactEmail");

return dtUnit;

}

private void ExportReport(DataSet dataSetUnit)

{

string sReportType = radioReport.SelectedValue;

UnitReportXSD objUnits = new UnitReportXSD();

objUnits.Merge(dataSetUnit);

ReportDocument rdUnits = new ReportDocument();

rdUnits.Load(Server.MapPath(

"UnitReport.rpt"));

ExportOptions expOpt = new ExportOptions();

DiskFileDestinationOptions dskOpt = new DiskFileDestinationOptions();

rdUnits.SetDataSource(objUnits);

string sBaseURL = Request.PhysicalApplicationPath.ToString() + ConfigurationSettings.AppSettings["UnitReportPath"].ToString();

//FileInfo fileInfo = new FileInfo(sBaseURL + "UnitReport.xls");

FileInfo fileInfo = new FileInfo(sBaseURL + "UnitReport." + sReportType);

fileInfo.IsReadOnly =

false;

//dskOpt.DiskFileName = sBaseURL + "UnitReport.xls";

dskOpt.DiskFileName = sBaseURL +

"UnitReport." + sReportType;

expOpt = rdUnits.ExportOptions;

expOpt.ExportDestinationOptions = dskOpt;

expOpt.ExportDestinationType =

ExportDestinationType.DiskFile;

if (sReportType.ToUpper().Equals("PDF"))

expOpt.ExportFormatType =

ExportFormatType.PortableDocFormat;

else

expOpt.ExportFormatType =

ExportFormatType.Excel;

rdUnits.Export();

DownloadReport(sReportType);

}

private void DownloadReport(string sReportType)

{

try

{

string sBaseURL = Request.PhysicalApplicationPath.ToString() + "Units\\UnitReport." + sReportType;

Response.ClearHeaders();

Response.AddHeader(

"content-disposition", "attachment; filename=UnitReport." + sReportType);

if (sReportType.ToUpper().Equals("PDF"))

Response.ContentType =

"application/force-download";

else

Response.ContentType =

"application/vnd.ms-excel";

Response.WriteFile(sBaseURL);

Response.End();

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

}

Folks,

I have a nested GridTableView (DataSourceId: SqlDataSource2) in my RadGrid. In GridTableView I have a RadComboBox (SqlDatasourceId: SqlDataSource3). I would like to check for Duplicates if that Location is already exists for that person (i.e. Do not allow Duplicate entries for Update/Inserts). Below is my complete code as well as SqlDataSource2_Updating event (Is there any other event that can do the same also?).

Any Help will be appreciated. Thanks

GC_0620

_________________
<telerik:RadGrid ID="RadGrid1" runat="server" AllowAutomaticDeletes="True"

        AllowAutomaticInserts="True" AllowAutomaticUpdates="True"

        AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True"

        AutoGenerateColumns="False"  DataSourceID="SqlDataSource1" GridLines="None"

                Skin="Office2007" PageSize="8" EnableLinqExpressions="False"

                 OnInsertCommand="RadGrid1_InsertCommand"  OnUpdateCommand = "RadGrid1_UpdateCommand"

                >

<MasterTableView datakeynames="UserTablePrimaryKey" datasourceid="SqlDataSource1"  AllowFilteringByColumn = "true" CommandItemDisplay="TopAndBottom">

<DetailTables>

        <telerik:GridTableView runat="server" DataSourceID="SqlDataSource2" DataKeyNames="UserLocationsPrimaryKey"

                Width="100%" Skin="WebBlue"  CommandItemDisplay="Top" Name = "JobPerson"   AllowAutomaticDeletes="true" AllowAutomaticInserts="true" AllowAutomaticUpdates="true">

                <ParentTableRelation>

                <telerik:GridRelationFields DetailKeyField="UserTableForeignKey" MasterKeyField="UserTablePrimaryKey" />

                 </ParentTableRelation>

            <RowIndicatorColumn>

                <HeaderStyle Width="20px" />

            </RowIndicatorColumn>

            <ExpandCollapseColumn>

                <HeaderStyle Width="20px" />

            </ExpandCollapseColumn>

            <CommandItemTemplate>

                   <div style="padding: 5px 5px;">

                        Custom command item template&nbsp;&nbsp;&nbsp;&nbsp;

                        <asp:LinkButton ID="btnEditSelected" runat="server" CommandName="EditSelected" Visible='<%# RadGrid1.EditIndexes.Count == 0 %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/Edit.gif" /> Edit selected</asp:LinkButton>&nbsp;&nbsp;

                        <asp:LinkButton ID="btnUpdateEdited" runat="server" CommandName="UpdateEdited" Visible='<%# RadGrid1.EditIndexes.Count > 0 %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/Update.gif" /> Update</asp:LinkButton>&nbsp;&nbsp;

                        <asp:LinkButton ID="btnCancel" runat="server" CommandName="CancelAll" Visible='<%# RadGrid1.EditIndexes.Count > 0 || RadGrid1.MasterTableView.IsItemInserted %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/Cancel.gif" /> Cancel editing</asp:LinkButton>&nbsp;&nbsp;

                        <asp:LinkButton ID="LinkButton2" runat="server" CommandName="InitInsert" Visible='<%# !RadGrid1.MasterTableView.IsItemInserted %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/AddRecord.gif" /> Add new</asp:LinkButton>&nbsp;&nbsp;

                        <asp:LinkButton ID="LinkButton3" runat="server" CommandName="PerformInsert" Visible='<%# RadGrid1.MasterTableView.IsItemInserted %>'><img style="border:0px;vertical-align:middle;" alt="" src="Images/Insert.gif" /> Add this Location</asp:LinkButton>&nbsp;&nbsp;

<asp:LinkButton ID="LinkButton1" OnClientClick="javascript:return confirm('Delete all selected Person?')"

runat="server" CommandName="DeleteSelected"><img style="border:0px;vertical-align:middle;" alt="" src="Images/Delete.gif" /> Delete selected Location</asp:LinkButton>&nbsp;&nbsp;

                        <asp:LinkButton ID="LinkButton4" runat="server" CommandName="RebindGrid"><img style="border:0px;vertical-align:middle;" alt="" src="Images/Refresh.gif" /> Refresh list</asp:LinkButton>

                    </div>

                   </CommandItemTemplate>

            <Columns>

        <telerik:GridBoundColumn DataField="UserLocationsPrimaryKey"

            DataType="System.Int32" HeaderText="UserLocationsPrimaryKey" ReadOnly="True"

            SortExpression="UserLocationsPrimaryKey" UniqueName="UserLocationsPrimaryKey"

                    Visible="False">

        </telerik:GridBoundColumn>

                <telerik:GridTemplateColumn DataField="Location" DataType="System.Double"

                    HeaderText="Location" SortExpression="Location" UniqueName="Location">

                    <ItemTemplate>

                        <asp:Label ID="LocationLabel" runat="server" Text='<%# Eval("Location") %>'></asp:Label>

                    </ItemTemplate>

                </telerik:GridTemplateColumn>

                        <telerik:GridBoundColumn DataField="Program" HeaderText="Program"

            SortExpression="Program" UniqueName="Program" >

        </telerik:GridBoundColumn>

        <telerik:GridBoundColumn DataField="UserTableForeignKey"

            DataType="System.Int32" HeaderText="UserTableForeignKey"

            SortExpression="UserTableForeignKey" UniqueName="UserTableForeignKey"

                    Display="False" ReadOnly="True" Visible="False">

        </telerik:GridBoundColumn>

    </Columns>

   <EditFormSettings EditFormType="Template">

    <FormTemplate>

    <table id="Table1a" cellspacing="2" cellpadding="1" width="100%" border="0" rules="none"

                            style="border-collapse: collapse; background: white;">

                            <tr class="EditFormHeader">

                                <td colspan="2" style="font-size:small;  z-index:0;  font-family:Bookman Old Style; color:#669999">

                                  <b>User Location</b></td>

                            </tr>

                           <tr>

                         <td></td>

                           </tr> <tr>

                                <td>

                                </td>

                                <tr>

                                    <td>

                                        Location</td>

                                    <td>

                                        <telerik:RadComboBox ID="RadComboBoxLocation" runat="server"

                                            DataSourceID="SqlDataSource3" DataTextField="Program" DataValueField="Location"

                                            DropDownWidth="369px" Height="150px" HighlightTemplatedItems="true"

                                            MarkFirstMatch="true"

                                           SelectedValue='<%#Bind("Location") %>' Skin="Office2007" Width="320px"

                                            >

                                            <HeaderTemplate>

                                                <table cellpadding="0" cellspacing="0" style="width: 345px">

                                                    <tr>

                                                        <td style="width: 245px;">

                                                            Program</td>

                                                        <td style="width: 55px;">

                                                            Location</td>

                                                    </tr>

                                                </table>

                                            </HeaderTemplate>

                                            <ItemTemplate>

                                                <table cellpadding="0" cellspacing="0" style="width: 345px">

                                                    <tr>

                                                        <td style="width: 245px;">

                                                            <%# DataBinder.Eval(Container.DataItem, "Program") %>

                                                        </td>

                                                        <td style="width: 55px;">

                                                            <%# DataBinder.Eval(Container.DataItem, "Location") %>

                                                        </td>

                                                    </tr>

                                                </table>

                                            </ItemTemplate>

                                        </telerik:RadComboBox>

                                        <asp:RequiredFieldValidator ID="RadComboBoxLocationRequiredFieldValidator"

                                            runat="server" ControlToValidate="RadComboBoxLocation"

                                            ErrorMessage="! Required">

                                </asp:RequiredFieldValidator>

                                    </td>

                                    <td>

                                        Program</td>

                                    <td>

                                        <asp:TextBox ID="TxtProgram" runat="server" TabIndex="2"  ReadOnly="true"

                                            Text='<%# Eval( "Program") %>' Width="250px">

                                                </asp:TextBox>

                                    </td>

                                                                        </tr>

                                <tr>

                                    <td>

                                    </td>

                                    <td>

                                    </td>

                                    <td>

                                    </td>

                                    <td align="right" colspan="2">

                                        <asp:Button ID="btnUpdate" runat="server"

                                            CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'

                                            Text='<%# (Container is GridEditFormInsertItem) ? "Insert" : "Update" %>'

                                           />

                                        &nbsp;

                                        <asp:Button ID="btnCancel" runat="server" CausesValidation="False"

                                            CommandName="Cancel" Text="Cancel" />

                                    </td>

                                </tr>

                           </tr>

                        </table>

    </FormTemplate>

    </EditFormSettings>

        </telerik:GridTableView>

    </DetailTables>       

<!-- Rest of Master Table Continues -->

<Columns>

 '

 '

    </Columns>

<EditFormSettings EditFormType="Template">

    <FormTemplate>

    '

    '

    </FormTemplate>

    </EditFormSettings>

</MasterTableView>

    <ClientSettings>

          '

          '

        </ClientSettings>

    </telerik:RadGrid>

<asp:Label ID="Msglabel" runat="server" Text="Label4"></asp:Label>

 <asp:SqlDataSource ID="SqlDataSource2" runat="server"

                 ConnectionString="<%$ ConnectionStrings:HR_Payroll_AuthorizationConnectionString %>"

                 DeleteCommand="DELETE FROM [UserLocations] WHERE [UserLocationsPrimaryKey] = @UserLocationsPrimaryKey"

                 InsertCommand="INSERT INTO [UserLocations] ([Location], [Program], [UserTableForeignKey]) VALUES (@Location, @Program, @UserTableForeignKey)"

                 SelectCommand="SELECT [UserLocationsPrimaryKey], [Location], [Program], [UserTableForeignKey] FROM [UserLocations] WHERE ([UserTableForeignKey] = @UserTableForeignKey) ORDER BY [Program]"

                 UpdateCommand="UPDATE [UserLocations] SET [Location] = @Location, [Program] = @Program, [UserTableForeignKey] = @UserTableForeignKey WHERE [UserLocationsPrimaryKey] = @UserLocationsPrimaryKey" onupdating="SqlDataSource2_Updating"

               >

                 <SelectParameters>

                <asp:Parameter Name="UserTableForeignKey" Type="Int32" />

                 </SelectParameters>

                 <DeleteParameters>

                     <asp:Parameter Name="UserLocationsPrimaryKey" Type="Int32" />

                 </DeleteParameters>

                 <UpdateParameters>

                     <asp:Parameter Name="Location" Type="Double" />

                     <asp:Parameter Name="Program" Type="String" />

                     <asp:Parameter Name="UserTableForeignKey" Type="Int32" />

                     <asp:Parameter Name="UserLocationsPrimaryKey" Type="Int32" />

                 </UpdateParameters>

                 <InsertParameters>

                     <asp:Parameter Name="Location" Type="Double" />

                     <asp:Parameter Name="Program" Type="String" />

                     <asp:Parameter Name="UserTableForeignKey" Type="Int32" />

                 </InsertParameters>

             </asp:SqlDataSource>

             <asp:SqlDataSource ID="SqlDataSource3" runat="server"

                 ConnectionString="<%$ ConnectionStrings:HR_Payroll_AuthorizationConnectionString %>"

                 SelectCommand="SELECT * FROM [CCNS_All_Location_Codes] WHERE ([Location] IS NOT NULL) ORDER BY [Program]">

             </asp:SqlDataSource>

________________________________________________________　

So Far I came up with this for Duplicate Checking but is not working. Any help will be appreciated..

 protected void SqlDataSource2_Updating(object sender, SqlDataSourceCommandEventArgs e)

    {

       RadComboBox combo = (RadComboBox)RadGrid1.MasterTableView.FindControl("RadComboBoxLocation");

       //RadComboBox combo1 = (RadComboBox)RadGrid1.MasterTableView.Items[0].FindControl("RadComboBoxLocation");

  //string strSelectedItem = combo1.SelectedItem.Text.ToString();

         SqlConnection conLocation = new SqlConnection(ConfigurationManager.

                 ConnectionStrings["HR_Payroll_AuthorizationConnectionString"].ToString());

            SqlCommand cmd = new SqlCommand("SELECT Count(*) FROM UserLocations  " +

                   "WHERE ([Location] = '" + combo.SelectedValue.ToString() + "'", conLocation);

               conLocation.Open();

             Object result = cmd.ExecuteScalar();

             if (result != null)

               {

                   Msglabel.Visible = true;

                   Msglabel.Text = "Duplicate Location for this Person - Can't proceed.."

                   e.Cancel = true;

               }

               conLocation.Close();

    }

telerik:RadSplitter ID="RadSplitter1" runat="server" Orientation="Horizontal"

Width="1000px" BorderSize="0" Skin="WebBlue">

<telerik:RadPane ID="RadPane1" Runat="server" Width="1000px" Height="37px"><asp:Table ID="Table2" runat="server" Width="995px" CellPadding="0" CellSpacing="0" Height="37px">

<asp:TableRow >

<asp:TableCell Font-Names="Freestyle Script" Font-Size="XX-Large" ForeColor="#3F3F3F" Width="3%"></asp:TableCell>

<asp:TableCell Font-Names="Freestyle Script" Font-Size="XX-Large" ForeColor="#666666" Width="72%">(Portal)</asp:TableCell>

<asp:TableCell Font-Names="Arial" Font-Overline="False" Font-Size="Small" ForeColor="#24E6D6" Font-Underline="True" Width="10%">Welcome:</asp:TableCell>

<asp:TableCell ForeColor="#2A7CC1" Font-Names="Arial" Font-Size="Small" Width="15%"></asp:TableCell>

</asp:TableRow>

</asp:Table>

</telerik:RadPane>

<telerik:RadSplitBar ID="RadSplitBar1" runat="server" CollapseMode="Forward" />

<telerik:RadPane ID="RadPane2" runat="server" Width="1000px" Height="493px">

<telerik:RadSplitter ID="RadSplitter2" runat="server" Height="100%"

Width="100%">

<telerik:RadPane ID="RadPane3" runat="server">

</telerik:RadPane>

<telerik:RadSplitBar ID="RadSplitBar2" runat="server" />

<telerik:RadPane ID="RadPane4" runat="server">

</telerik:RadPane>

</telerik:RadSplitter>

</telerik:RadPane>

</telerik:RadSplitter>

with this setup I get scrollbars on the right and botom of what I think is the bottom horizontal panel of the first splitter. I would like a clean join onto the side of the splitter border.

I hope this is a quick one, Thanks in advance for your time and help

mike