I have RadGrid with automatic Insert/Update. Everything is working just fine, the problems start occurring, when I try to save html document using the textbox, giving me "server error". See below my asp markup and the doc I try to save.
<telerik:RadGrid ID="RadGrid2" runat="server" AllowAutomaticDeletes="True" AllowAutomaticInserts="True"
AllowAutomaticUpdates="True" AutoGenerateColumns="False" CellSpacing="0" DataSourceID="ServiceType"
GridLines="None" ShowStatusBar="True" AllowPaging="True">
<PagerStyle AlwaysVisible="true" Mode="NumericPages" />
<ClientSettings>
<DataBinding>
<DataService Type="OData" />
</DataBinding>
<Selecting AllowRowSelect="True" />
</ClientSettings>
<MasterTableView CommandItemDisplay="Top" DataKeyNames="ServiceTypeID"
DataSourceID="ServiceType" Width="100%" Name="ServiceType"
AllowPaging="False">
<DetailTables>
..................
<telerik:GridTemplateColumn DataField="MaterialDescription" FilterControlAltText="Filter MaterialDescription column"
HeaderText="Description" UniqueName="ChildMaterialDescription">
<EditItemTemplate>
<asp:TextBox ID="MaterialDescriptionTextBox" runat="server" Text='<%# Bind("MaterialDescription") %>'
Height="100px" TextMode="MultiLine" Width="300px" Wrap="True"></asp:TextBox>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="MaterialDescriptionLabel" runat="server" Text='<%# Eval("MaterialDescription") %>'></asp:Label>
</ItemTemplate>
.........................
<asp:SqlDataSource ID="ChildMaterialItems" runat="server" ConnectionString="<%$ ConnectionStrings:KPortal %>"
SelectCommand="SELECT Materials.ParentMaterialID, Materials.MaterialID, Materials.MaterialDescription, Materials.MaterialName, Materials.MaterialPictureID, MaterialPictures.PictureCategory + ' - ' + MaterialPictures.PictureDescription AS PictureDescription, Materials.PricedItem, Materials.MaterialCategoryID, Materials.OrderID, Materials.Value, Materials.UnitID, Materials.InternalCode, Materials.UnitType FROM Materials INNER JOIN MaterialPictures ON Materials.MaterialPictureID = MaterialPictures.MaterialPictureID WHERE (Materials.ParentMaterialID = @ParentMaterialID)
order by Materials.OrderID" DeleteCommand="Exec DeleteMaterials @MaterialID"
InsertCommand="Exec InsertMaterial
@MaterialDescription=@MaterialDescription,
@MaterialPictureID = @MaterialPictureID,
@ParentMaterialID = @ParentMaterialID,
@MaterialName = @MaterialName,
@PricedItem = @PricedItem,
@InternalCode = @InternalCode ,
@Value = @Value,
@UnitType = @UnitType,
@UnitID = @UnitID,
@OrderID = @OrderID"
UpdateCommand="
Update Materials
Set
MaterialDescription = @MaterialDescription,
MaterialPictureID = @MaterialPictureID,
MaterialName = @MaterialName,
PricedItem = @PricedItem,
InternalCode = @InternalCode,
Value = @Value,
UnitType = @UnitType,
UnitID = @UnitID,
OrderID = @OrderID
Where MaterialID =@MaterialID
">
<DeleteParameters>
<asp:Parameter Name="MaterialID" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="MaterialDescription" />
<asp:Parameter Name="MaterialPictureID" />
<asp:Parameter Name="ParentMaterialID" />
<asp:Parameter Name="MaterialName" />
<asp:Parameter Name="PricedItem" />
<asp:Parameter Name="InternalCode" />
<asp:Parameter Name="Value" />
<asp:Parameter Name="UnitType" />
<asp:Parameter Name="UnitID" />
<asp:Parameter Name="OrderID" />
</InsertParameters>
<SelectParameters>
<asp:ControlParameter ControlID="RadGrid2" Name="ParentMaterialID"
PropertyName="SelectedValue" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="MaterialDescription" />
<asp:Parameter Name="MaterialPictureID" />
<asp:Parameter Name="MaterialName" />
<asp:Parameter Name="PricedItem" />
<asp:Parameter Name="InternalCode" />
<asp:Parameter Name="Value" />
<asp:Parameter Name="UnitType" />
<asp:Parameter Name="UnitID" />
<asp:Parameter Name="OrderID" />
<asp:Parameter Name="MaterialID" />
</UpdateParameters>
</asp:SqlDataSource>