Hi, I'm using a RadDataFilter to filter data on a RaGridView.

For datetime columns I've noticed some problems.

First, in the control the date is displayed in english format (see first attached image). When I try to change the value a datetimepicker appears and in this case the date is in italian format (according to my pc settings).

Second, I've noticed when the radDataFilter.Expression is generated the date is in english format, including time, and it is inside a couple of #, i.e the expression generated is like:

[myDate] >= #11/20/2023 14:55:07# 

I would like to have only the date without time, is it possible?
And  how can manage this expression to generate the SQL expression, cause the # is not accepted.

Thank you in advance for any help.

I have a customer that when adding new records to my data grid doesn't want the records to disappear until the grid is refreshed.

For example, in the screen shot, the user has filtered the rows to State Program = "AK FFS" and NDC = "42543-003-01".  The user want to see the existing values while creating the new record i.e.,  NDC 42543-003-02.  When the user enters all the fields and the record gets added it disappears because of the current filters applied.  Is there a way to by-pass the filters on the newly added rows?

Appreciate any advise.

Hi Everyone,

I use a RadTreeView control on my form. I have a client table and a project table. Both tables have a DeletionStatus boolean field/property.

This is how I set the control up:

this.tvProjectClient.DataSource = clientBindingSource;
this.tvProjectClient.DisplayMember = "FullName";
this.tvProjectClient.ValueMember = "ClientId";
this.tvProjectClient.RadContextMenu = this.rcmProject;

this.tvProjectClient.RelationBindings.Clear();
this.tvProjectClient.RelationBindings.Add(new RelationBinding(this.projectBindingSource, "Name", "ClientId", "ClientId", "ProjectId"));
 

Now i want to create a FilterDescriptor to filter DeletionStatus to false on the Client table to be like:

      FilterDescriptor filterDescriptor = new FilterDescriptor();

      filterDescriptor.Value = "False";
      filterDescriptor.Operator = FilterOperator.IsEqualTo;
      filterDescriptor.PropertyName = "DeletionStatus";

My question is, how to I change the property name to reference the client (or project) table for DeletionStatus? I have tried Client.DeletionStatus and ClientRow.DeletionStatus but the control does not register it.

Any ideas? I do not want to change field names if possible.

Many thanks, JB

hello guys,

I am using Radscheduler to develop employee Timesheet program, I use codeless data binding (link below)

Codeless data binding - WinForms Scheduler Control - Telerik UI for WinForms

I am face with a data filter problem. Each employee is from different location (Employee Table have their own ID(primary key) ,location ID, StartTime, EndTime), so for each location when they use this app, I want they only can view their own timesheet.

So into my

private void Form_Load(object sender, EventArgs e)
        {
            this.tS_TimeSheetTableAdapter.Fill(this.XXX_XXDataSet.TS_TimeSheet);

       }

How should I filter data by location ID before it fill the tableadapter?

Plz help me out.

Thanks,

Mike

I would like to remove the Group option from the DataFilterAddNodeElement dropdown list when I'm adding to an existing group. Basically I only want to allow adding expressions to groups and prevent nested groups from being created. However, I still want to allow adding groups to the root node, just not to other groups. Is there a way to hide or disable the Group option in this scenario?

Thanks

When user manually types the filter value (only date) in RadDateTimeEditor adds current time, so the filter value becomes -  %data %current time.

And filtering gives the empty table, because of values in datetime columns have 00:00:00 time.

How to set time to 00:00:00 instead of using current?

P.S. If user chooses value with DateTimePicker then filter value is %data 00:00:00 and filtering works fine.

I am attempting to filter results in a RadGrid.

What I am looking for is the programmatic equivalent of selecting the all but (blanks) or not (blanks) option from the filtering area.

I will apply filters of " " and "" but still will get results of "   " or varying amounts of whitespace that I don't want in the results. I cannot do this with a composite filter as I cannot capture all of cases of whitespace, but removing (blanks) achieves the correct results.

Thanks

Is there any easy way to convert RadDataFilter.Expression to FilterDescriptorCollection, so ill be able add it do CompositeFilterDescriptor of the RadGridView.FilterDescriptors.

RadGridView.FilterDescriptors.Add(new CompositeFilterDescriptor() { FilterDescriptors = RadDataFilter.Expression? });