or
<style type="text/css">
.RadInput
{
display: none;
}
</style>
Protected Sub rgTimeslips_ItemCommand(ByVal source As Object, ByVal e As GridCommandEventArgs) Handles rgTimeslips.ItemCommand LogID = e.Item.OwnerTableView.DataKeyValues(e.Item.ItemIndex)("KeyID") DocID = e.Item.OwnerTableView.DataKeyValues(e.Item.ItemIndex)("SONumber") Label7.Text = LogID & "," & DocID pnlForm.Visible = True pnlLogGrid.Visible = False 'set values of Time Entry user control Dim u As UserControl = TryCast(FindControl("TimeEntry2"), UserControl) Dim ddlso As DropDownList = TryCast(u.FindControl("ddlSO"), DropDownList) ddlso.SelectedValue = DocID Dim SOLogKeyID As HiddenField = TryCast(u.FindControl("SOLogKeyID"), HiddenField) Dim TimeSlipKeyID As HiddenField = TryCast(u.FindControl("TimeSlipKeyID"), HiddenField) If DocID = 0 Then SOLogKeyID.Value = "0" TimeSlipKeyID.Value = LogID Else SOLogKeyID.Value = LogID TimeSlipKeyID.Value = "0" End If ddlso.Enabled = False End Sub<telerik:RadGrid ID="rgDepartaments" runat="server" AllowPaging="true" AllowSorting="true" AllowFilteringByColumn="true" PageSize="10" AllowMultiRowEdit="true" OnItemCreated="rgDepartaments_ItemCreated"> <MasterTableView DataKeyNames="IdDepartament" ClientDataKeyNames="IdDepartament" CommandItemDisplay="Bottom"> <Columns> <telerik:GridBoundColumn UniqueName="Departament" DataField="Departamento" DataType="System.String"> </telerik:GridBoundColumn> <telerik:GridDateTimeColumn UniqueName="UpdateDate" DataField="UpdateDate" DataType="System.DateTime" DataFormatString="{0:dd/MM/yyyy HH:mm}" HeaderStyle-Width="150px"> </telerik:GridDateTimeColumn> </Columns> </MasterTableView> <ClientSettings> <DataBinding Location="~/DesktopModules/Comun/Services/DepartmentSvc.svc" SelectCountMethod="TotalDepartments"> <DataService TableName="Departament" /> </DataBinding> </ClientSettings></telerik:RadGrid>[WebGet]public int TotalDepartments(string where){ return String.IsNullOrEmpty(where) ? this.CurrentDataSource.Department.Count() : this.CurrentDataSource.Department.Where(where).Count();}TotalDepartments is executed with a where condition having a UpdateDate filter I get the following error: Edm.DateTime and Edm.String are not compatible types. UpdateDate (21/07/2011 --> 21st July 2011). When I try to filter through UpdateDate width 16/07/2011 and "major than" I get no record (all records must have been returned). By if I filter with 16/07/2001 and "less than" I get all the records (no record must have been returned).Dim exp As String = "(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])[- /.](19|20)\d\d"Dim sql As String = ""Dim DATE_EXP As System.Text.RegularExpressions.Match = System.Text.RegularExpressions.Regex.Match(e.Text, exp)sql = "SELECT NAMECOLUMNS from TABLE " If DATE_EXP .Success Then sql += " where CONVERT(VARCHAR(12),DATE_COLUMN,103) = CONVERT(VARCHAR(12), '" & e.Text & "', 103) " Else sql += " WHERE OTHERCOLUMN LIKE '%" + e.Text + "%'" End If SessionDataSource1.SelectCommand = sql <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> </telerik:RadScriptManager><% System.Collections.Generic.List<RadComboBoxItem> choices = new System.Collections.Generic.List<RadComboBoxItem>(); for(int i=1; i <= 10; i++) { choices.Add(new RadComboBoxItem("" + i + "- Complex Display Detail", "" + i)); } RadComboBox1.DataSource = choices; RadComboBox1.DataBind();%><telerik:RadComboBox ID="RadComboBox1" runat="server" AllowCustomText="true" DataTextField="Value" DataValueField="Value" Width="333px" CheckBoxes="false"> <ItemTemplate> <asp:Label runat="server"><%# Eval("Text") %></asp:Label> </ItemTemplate></telerik:RadComboBox><telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server"> </telerik:RadAjaxLoadingPanel> <telerik:RadAjaxManager ID="rad1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="rgTest"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="rgTest" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager><telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Default"> </telerik:RadAjaxLoadingPanel> <telerik:RadAjaxManager ID="rad1" runat="server"> <AjaxSettings> <telerik:AjaxSetting AjaxControlID="rgTest"> <UpdatedControls> <telerik:AjaxUpdatedControl ControlID="rgTest" LoadingPanelID="RadAjaxLoadingPanel1" /> </UpdatedControls> </telerik:AjaxSetting> </AjaxSettings> </telerik:RadAjaxManager>