<
ItemTemplate
>
<
telerik:RadComboBox
ID
=
"cboCoverSectionImageType"
Width
=
"230px"
runat
=
"server"
SelectedValue='<%# Eval("IMAGE_TYPE_ID") %>'
DataSourceID="ObjectDSPropertyImageTypes" DataTextField="Image_Type_Name" DataValueField="Image_Type_ID"
EmptyMessage="Click here & select page">
</
telerik:RadComboBox
>
</
ItemTemplate
>
ImageMasterInfo objNewImageInfo =
new
ImageMasterInfo();
objNewImageInfo.IMAGE_ID = 0;
objNewImageInfo.IMAGE_PROPERTY_ID =
this
.PropertyID;
objNewImageInfo.IMAGE_TYPE_ID = -1;
objNewImageInfo.IMAGE_PATH =
string
.Empty;
objNewImageInfo.IMAGE_THUMB_PATH =
string
.Empty;
lstSectionCoverImages.Add(objNewImageInfo);
RadGridCoverSectionImages.DataSource = lstSectionCoverImages;
RadGridCoverSectionImages.DataBind();
I'd like to use autocomplete boxes set to text and limit to single entry. I have achieved this but I'm now trying to detect if the text entered is new. i.e. it is not an item that already exists in the database that populates the list.
In my case the select statement is against a table with less than 100 records. New values are permitted. The user types and the dropdown is filtered. The user can then select from a value or carry-on typing.
Can the control indicate
1. If the value has been selected or typed.
2. If typed then is this a new entry or an value that exists but was not selected.... sometimes our user will paste a value in directly which actually already exists in the list.
I need to be able to differentiate so that new values are added to a table when the form is saved.
Thanks
<
telerik:RadGrid
AutoGenerateColumns
=
"False"
ID
=
"RadGrid4"
AllowFilteringByColumn
=
"True"
AllowSorting
=
"True"
runat
=
"server"
OnItemCommand
=
"RadGrid4_ItemCommand"
OnItemCreated
=
"RadGrid4_ItemCreated"
EnableLinqExpressions
=
"false"
HtmlEncode
=
"true"
OnNeedDataSource
=
"RadGrid4_NeedDataSource"
GroupingSettings-RetainGroupFootersVisibility
=
"true"
ShowGroupPanel
=
"True"
CellSpacing
=
"-1"
GridLines
=
"Both"
Skin
=
"Office2010Silver"
EnableViewState
=
"true"
Width
=
"100%"
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
/>
<
GroupingSettings
CaseSensitive
=
"false"
/>
<
ClientSettings
AllowKeyboardNavigation
=
"true"
>
</
ClientSettings
>
<
ExportSettings
OpenInNewWindow
=
"true"
FileName
=
"i-Dispatch Job Part Used Report"
ExportOnlyData
=
"true"
>
<
Pdf
PageHeight
=
"210mm"
PageWidth
=
"297mm"
DefaultFontFamily
=
"Arial Unicode MS"
PageTopMargin
=
"45mm"
BorderStyle
=
"Medium"
BorderColor
=
"#666666"
PaperSize
=
"A4"
>
</
Pdf
>
</
ExportSettings
>
<
MasterTableView
Width
=
"100%"
DataKeyNames
=
"JobID"
HierarchyLoadMode
=
"ServerOnDemand"
ShowGroupFooter
=
"true"
AllowMultiColumnSorting
=
"true"
>
<
Columns
>
<
telerik:GridMaskedColumn
DataField
=
"JobID"
HeaderText
=
"JobID#"
FilterControlWidth
=
"50px"
AutoPostBackOnFilter
=
"false"
CurrentFilterFunction
=
"EqualTo"
FilterDelay
=
"2000"
ShowFilterIcon
=
"false"
Mask
=
"#####"
GroupByExpression
=
"JobID Group By JobID"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
></
ModelErrorMessage
>
</
ColumnValidationSettings
>
</
telerik:GridMaskedColumn
>
<
telerik:GridBoundColumn
DataField
=
"JobTitle"
FilterControlAltText
=
"Filter JobTitle column"
HeaderText
=
"Job Title"
SortExpression
=
"JobTitle"
UniqueName
=
"JobTitle"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridDateTimeColumn
DataField
=
"JobBookedDate"
PickerType
=
"DatePicker"
EnableTimeIndependentFiltering
=
"true"
DataFormatString
=
"{0:dd/MM/yyyy HH:mm }"
DataType
=
"System.DateTime"
FilterControlAltText
=
"Filter JobBookedDate column"
HeaderText
=
"Job Booked Date"
SortExpression
=
"JobBookedDate"
UniqueName
=
"JobBookedDate"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridDateTimeColumn
>
<
telerik:GridTemplateColumn
DataField
=
"AssignedStaffID"
HeaderText
=
"Mobile Staff"
UniqueName
=
"AssignedStaffID"
HeaderStyle-Width
=
"200px"
SortExpression
=
"AssignedStaffID"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"comboStaff"
DataTextField
=
"StaffName"
DataValueField
=
"StaffID"
Height
=
"100px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("AssignedStaffID").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="StaffIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock10"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function StaffIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("AssignedStaffID", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemTemplate
>
<%# Eval("Staff") %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridTemplateColumn
DataField
=
"CreatedBy"
HeaderText
=
"Added By"
UniqueName
=
"CreatedBy"
HeaderStyle-Width
=
"200px"
SortExpression
=
"CreatedBy"
>
<
FilterTemplate
>
<
telerik:RadComboBox
ID
=
"comboAdded"
DataTextField
=
"StaffName"
DataValueField
=
"StaffID"
Height
=
"100px"
AppendDataBoundItems
=
"true"
SelectedValue='<%# ((GridItem)Container).OwnerTableView.GetColumn("CreatedBy").CurrentFilterValue %>'
runat="server" OnClientSelectedIndexChanged="AddedByIndexChanged">
<
Items
>
<
telerik:RadComboBoxItem
Text
=
"All"
/>
</
Items
>
</
telerik:RadComboBox
>
<
telerik:RadScriptBlock
ID
=
"RadScriptBlock11"
runat
=
"server"
>
<
script
type
=
"text/javascript"
>
function AddedByIndexChanged(sender, args) {
var tableView = $find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
tableView.filter("CreatedBy", args.get_item().get_value(), "EqualTo");
}
</
script
>
</
telerik:RadScriptBlock
>
</
FilterTemplate
>
<
ItemTemplate
>
<%# Eval("AddedBy") %>
</
ItemTemplate
>
</
telerik:GridTemplateColumn
>
<
telerik:GridBoundColumn
DataField
=
"PartCode"
FilterControlAltText
=
"Filter PartCode column"
HeaderText
=
"Part Code"
SortExpression
=
"PartCode"
UniqueName
=
"PartCode"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"PartName"
FilterControlAltText
=
"Filter PartName column"
HeaderText
=
"Part Name"
SortExpression
=
"PartName"
UniqueName
=
"PartName"
>
<
ColumnValidationSettings
>
<
ModelErrorMessage
Text
=
""
/>
</
ColumnValidationSettings
>
</
telerik:GridBoundColumn
>
<
telerik:GridNumericColumn
DataFormatString
=
"{0:$###,##0.00}"
DataField
=
"PartPurchasePrice"
DataType
=
"System.Double"
NumericType
=
"Currency"
HeaderText
=
"PurchasePrice"
SortExpression
=
"PartPurchasePrice"
UniqueName
=
"PartPurchasePrice"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:C}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataFormatString
=
"{0:$###,##0.00}"
DataField
=
"PartSalePrice"
DataType
=
"System.Double"
NumericType
=
"Currency"
HeaderText
=
"SalePrice"
SortExpression
=
"PartSalePrice"
UniqueName
=
"PartSalePrice"
FooterText
=
"Total:"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:C}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataFormatString
=
"{0:$###,##0.00}"
DataField
=
"JobPartUnitPrice"
DataType
=
"System.Double"
NumericType
=
"Currency"
HeaderText
=
"Unit Price"
SortExpression
=
"JobPartUnitPrice"
UniqueName
=
"JobPartUnitPrice"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:C}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataField
=
"JobPartQuantity"
DataType
=
"System.Double"
HeaderText
=
"Quantity"
SortExpression
=
"JobPartQuantity"
UniqueName
=
"JobPartQuantity"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:n}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataFormatString
=
"{0:$###,##0.00}"
DataField
=
"JobPartGST"
DataType
=
"System.Double"
NumericType
=
"Currency"
HeaderText
=
"JobPartGST"
SortExpression
=
"JobPartGST"
UniqueName
=
"JobPartGST"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:C}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
<
telerik:GridNumericColumn
DataFormatString
=
"{0:$###,##0.00}"
DataField
=
"JobPartTotal"
DataType
=
"System.Double"
NumericType
=
"Currency"
HeaderText
=
"JobPartTotal"
SortExpression
=
"JobPartTotal"
UniqueName
=
"JobPartTotal"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:C}"
>
<
FooterStyle
Font-Bold
=
"true"
></
FooterStyle
>
</
telerik:GridNumericColumn
>
</
Columns
>
<
GroupByExpressions
>
<
telerik:GridGroupByExpression
>
<
GroupByFields
>
<
telerik:GridGroupByField
FieldName
=
"JobID"
></
telerik:GridGroupByField
>
</
GroupByFields
>
<
SelectFields
>
<
telerik:GridGroupByField
FieldName
=
"JobID"
HeaderText
=
"JobID#"
></
telerik:GridGroupByField
>
</
SelectFields
>
</
telerik:GridGroupByExpression
>
</
GroupByExpressions
>
</
MasterTableView
>
<
ClientSettings
AllowDragToGroup
=
"true"
>
<
Scrolling
AllowScroll
=
"True"
UseStaticHeaders
=
"True"
/>
</
ClientSettings
>
</
telerik:RadGrid
>