Hi

I am evaluating the RadGrid control for an upcoming project and have been struggling with a particular scenario.

I need to filter a date column to include all rows in a certain range. I've worked out how to do that okay with the FilterExpression property as shown below:
 

 

 protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)
        {
            if (e.CommandName == RadGrid.FilterCommandName)
            {
                Pair filterPair = (Pair)e.CommandArgument;
         
                if (filterPair.First.ToString() == "EqualTo" && filterPair.Second.ToString() == "OrderDate")
                {
                    e.Canceled = true;
                    RadDatePicker filterBox = (e.Item as GridFilteringItem)[filterPair.Second.ToString()].Controls[0] as RadDatePicker;

                    string newFilter = String.Format("((it.[{0}] >= DATETIME'{1}') AND (it.[{0}] <= DATETIME'{2}'))", filterPair.Second, filterBox.SelectedDate.Value.ToString("yyyy-MM-dd" + " 00:00:00"), filterBox.SelectedDate.Value.ToString("yyyy-MM-dd") + " 23:59:59");
                  
                 
                    if (RadGrid1.MasterTableView.FilterExpression == "")
                    {
                        RadGrid1.MasterTableView.FilterExpression = newFilter;
                    }
                    else
                    {
                        RadGrid1.MasterTableView.FilterExpression = String.Format("(({0}) AND ({1}))", RadGrid1.MasterTableView.FilterExpression, newFilter);
                    }
                   
                    GridBoundColumn dateColumn = (GridBoundColumn)e.Item.OwnerTableView.GetColumnSafe("OrderDate");
                
                    dateColumn.CurrentFilterValue = filterBox.SelectedDate.Value.ToString();
                    dateColumn.CurrentFilterFunction = GridKnownFunction.EqualTo;

                }

                RadGrid1.Rebind();
          
            }
          
        }

 

 

 

 

However, the problem I have is this.

When I filter one columns date this works okay, however, if I filter another column the date filtered column is undone (it refers to trying to filter by the entries set in dateColumn.CurrentFilterValue .

Also, an additional problem I have with this code is, when I filter the date column twice, both filters are appended together. So if I filter by 03/04/2012 the first result set is correct, if I then filter by 04/04/2012 the second filterexpression is appended to the first (in essence where date = 03/04/012 AND date = 04/04/2012).

Could someone point me in the right direction as to how to filter multiple columns, one of which is filtered using a manual filter expression and also to take into account multiple attempts at the same filter. Should I be maintaining the filters in session or is there a cleaner way to achieve a solution?

Many thanks
Carl

I'm having a hard time getting a very simple instance of the scheduler into a webpart.  I tried following the instructions here: http://www.telerik.com/help/aspnet-ajax/moss-deploying-radcontrols.html, but step 3 is really confusing to me:

3. [Optional] In order to use RadScriptManager (instead of the standard ScriptManager control) or controls like RadBinaryImage, RadChart, RadUpload, etc., you need to register their handlers in the respective section in the web.config:       

What does that mean?  is RadScheduler one of the controls?  And if so, I dont understand what of the code I am supposed to actually add because it looks like examples for just the 3 listed.  Do I basically just replace RadUpload with RadScheduler everywhere I see it?

Please help - i'm really behind on a project.

Thanks!
Loren

Hi,

I have extended GridBoundColumn to create a column where filtering can be done by selecting a value in a RadComboBox in the filtering row.
The filtering is triggered in the combobox's index changed event handler:

private void combo_SelectedIndexChanged(object sender, RadComboBoxSelectedIndexChangedEventArgs e)
        {
            var combo = (RadComboBox)sender;
            
            GridKnownFunction currentFilterFunction = combo.SelectedItem != null && combo.SelectedValue != allValue ?
                                                    GridKnownFunction.Contains : GridKnownFunction.NoFilter;
            
            var filterItem = (GridFilteringItem)(combo.Parent.Parent);
            filterItem.FireCommandEvent(RadGrid.FilterCommandName, new Pair(currentFilterFunction.ToString(), this.UniqueName));
        }

 protected override string GetCurrentFilterValueFromControl(TableCell cell)
        {
            var combo = (RadComboBox)cell.Controls[0];
            return combo.SelectedItem != null ? combo.SelectedValue : combo.Text;
        }

The RadComboBox now supports multiple selections with its "Checkboxes" property. I would therefore like to implement this functionality to this filtering column as well.
The issue I am having is that I do not know how to filter on multiple values. 
In the above example, a filter command is fired containing the filter function and the column's uniquename. The 
GetCurrentFilterValueFromControl function then returns what filter value to use. How can I here return multiple values?
Or should I attack this issue in a whole different way perhaps? :)




I'm thankful for any help!

Hi ,

I want hide the rows server side depending on some conditions 
for that I am using following code 

 protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
  if (e.Item is GridDataItem)  {
 if (//Condition)
                        e.Item.Attributes["style"] = "display:none";  
}
}

However it works perfectly,but I dont want to this, because it renders the row.
I tried 
e.Item.Visible=false; 
but it wont work, can you please provide me alternate solution.

Thanks

Hi, 
I have developped my project on VisualStudio 2010. It works well on it with ASP 4.0. 

Finally I finished my project and I tried to move it on live server IIS. Then It doesn't work. Server send following error When I click my login or captha refresh button.

I attached my Chrome screenshot

And this is my web.config

Hi all,
I have a user control that contains a RadAjaxManagerProxy configured thus:

I have a repeater that is to be refreshed when a record is edited via RadWindow, which in turn triggers a postback OnClientClose against a hidden linkbutton: (refreshPage is the function I've assigned to OnClientClose, and it does get called and passes the correct argument to refreshBrandingOptions)...

If the OnClientClose function is called and triggers the postback, the whole page refreshes.
If I add some dummy text to the linkbutton, stop the OnClientClose event from firing and then manually click the linkbutton, the repeater updates via ajax as it should.

The linkbutton and repeater code:

Can anyone shed some light on what's going on here?

Cheers
Rich

Hi,

I am using Rad window which i am navigating other .aspx page on button click. There is a save functionality in the window, after closing. Calling this function in RadWindowManager.

function closeRadWindow() {
            $find("<%= RadAjaxManager1.ClientID %>").ajaxRequest();
        }

the grids will be rebind. Working good with this code which mentioned below.  

Issue : grd1 and grd2 will be in one panel1 and grd3 is in another panel2. Condition is when Panel1 only visible (Panel2 is visible false ) then getting error : 

Microsoft JScript runtime error: Sys.InvalidOperationException: Could not find UpdatePanel with ID 'ctl00_cphContent_ctl00_cphContent_wizPageInfo_grd3Panel'. If it is being updated dynamically then it must be inside another UpdatePanel.

Here is my code which i am using:

<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" OnAjaxRequest="RadAjaxManager1_AjaxRequest">
        <AjaxSettings>
            <telerik:AjaxSetting AjaxControlID="RadAjaxManager1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="grd1" UpdatePanelRenderMode="Inline" />
                    <telerik:AjaxUpdatedControl ControlID="grd2" UpdatePanelRenderMode="Inline" />
                </UpdatedControls>
            </telerik:AjaxSetting>
            <telerik:AjaxSetting AjaxControlID="RadAjaxManager1">
                <UpdatedControls>
                    <telerik:AjaxUpdatedControl ControlID="grd3" UpdatePanelRenderMode="Inline" />
                </UpdatedControls>
            </telerik:AjaxSetting>
        </AjaxSettings>
    </telerik:RadAjaxManager>

Code Behind:

  protected void RadAjaxManager1_AjaxRequest(object sender, AjaxRequestEventArgs e)
        {
            grd1.Rebind();
            grd2.Rebind();
            grd3.Rebind();
        }

I use radCaptcha  with audio code in my site.

 I use it in localhost it works fine and I can replace another .wav files with default audio files .but when i use it on server, it reads audio files from WebResource not from address I set and I can't replace this audio files.

even I delete this audio files from RadCaptcha folder,it reads audio files from webResource.
my question is how can i replace my custom audio files in RadCapcha in server not in localhost 

Hi,

I have a Grid with items and a TreeView. I can drag and drop items from the Grid to the TreeView and it works fine. Right now dragging and dropping an item from the Grid to the Tree is like making a copy of that item from one node in the tree to another. However I need to extend the functionality and offer the user an option to select what he/she actully needs to do (Copy/Move/Make a Reference).

I need something like: onRowDropping (js event of the TreeVire) to show a pop-up with 3 options and when the user selects one of the options to actually be able to pass it the the server side event NodeDrop of the TreeView.

Is this possible with the Telerik controls?

Regards,
Kamen

Hi, 

I was wondering how to rebind/refresh only single row in the radgrid using ajax. The idea is that I have serverside function that changes property of an radgrid item (its image) and by clicking a button I want to show the changes.

Thanks, Ivan.