Questions on UI for ASP.NET AJAX Forum

1 answer

130 views

How to detect if text typed in not a value from list

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

AutoCompleteBox

answered on 01 Apr 2015

3 answers

158 views

Grouping Footer Total

Hi there,

I am trying to get the total items onto the footer at the bottom, however, I cannot make it when I do grouping based on a jobID.
I've attached my grid's look. It has got the each item's total, however, I want to have the last total at the bottom.
thank you

html code:

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