<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>
