Hi,
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.
Thanks,
Yuriy
I am trying to save in the column above the following text:
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.
Thanks,
Yuriy
<
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
>
I am trying to save in the column above the following text:
<
html
xmlns
=
"http://www.w3.org/1999/xhtml"
>
<
body
>
<
p
style
=
"text-align: left"
>
<
img
alt
=
"Priceology"
src
=
"{WebSiteAddress}/Pics/Pricology640.jpg"
/></
p
>
<
div
>
Dear {CompanyUserName},<
br
/>
<
br
/>
Please be advised that there is an update to {Service} project that you are
working on.<
br
/>
<
br
/>
The status of the <
b
>"{ProjectName}"</
b
> project have been updated to
<
b
>"{ProjectStatus}"</
b
>.
<
br
/>
<
br
/>
Please visit the link below to see the details:e the details:<
br
/>
<
br
/>
<
a
href
=
"{ManufacturerProjectLink}"
>Priceolgy projects</
a
><
br
/>
<
br
/>
Regards,<
br
/>
Priceology Team</
div
>
</
body
>
</
html
>