I am looking to use the filter control as a tool to let my clients easily generate there own SQL where conditions.  Please realize though that I am using this control alone and do not have/want it tied to a grid or any other control. However I have some conditions that at the moment doesn't seem to work to well with the control.  

1) I already store in a SQL table all the Fields and Operators a client can select upon.  However the radFilter does not appear to let you define the operators for a specific field on the server side.  So for example I would be adding all my fields on PageLoad or PreInit and maybe I don't want a specific field like "Last Name" to have "IsNull" as a filter option but another field may allow it.
* Doing this only in the client side like all suggestions seem to direct you is really a hack and leads to unclean code especially when your not blanket-ally removing an operator across all fields.

2) I would like to make my own field but am wondering if the filter control can handle it.  Say for example someone wanted to query for "Transaction Amount" > 100 and "Transaction Date" between 1/1/2012 and 3/3/2012.  To handle this properly you would have to make a unique operator(s) that would let you set the fields shown.  You may also want to do something like "Transaction Amount" between 100 and 1000 and "Transaction Date" between 1/1/2012 and 3/3/2012.  Then there would be possibility of 4 values and 2 operator conditions.
* Please realize that what I am saying is different then 2 different filter items.  Because I am specifically saying i want to find people with a transaction amount greater then 100 between the specific dates.  If you used what the Sqlprovider gives you actually end up with people who have some transaction > 100 unrelated to the provided supplied date range.  I realize that this requires parsing on my part and wouldn't rely on the SqlProvider for anything.

3) There appears to be no built in method to get a simple representation of the filters other then radFilter.RootGroup.Expressions but you have to parse all the fields out yourself?
* Has telerik given any thought to a XmlProvider so that you can get a representation of the filter fields, operators, and values as XML?  This would allow others to take that XML and interpret it how they choose.

4) Similar to number 3 the Save/Load functionality should support an xml string versus base64 encoded string.  This would allow you to interpret the xml how you choose and possibly review created selects directly in sql.

Hi guys.I am creating tree view from some of my class object dynamically.
What i need to do is drag(just drag not remove) the leaf node into the rich text editor text.



I have tried to create the nodetemplate but not succcessful( other wise just add the node template in the leaf node with label)
Following is the code of making the treeview node.

TreeView1.Nodes.Clear();

            DocumentTemaplateCompiledDto obj = DocumentTemaplateCompiledBll.GetInstance.GetDocumentTemaplateCompiledByTemplateId(Int32.Parse(ddlTemplates.SelectedValue));

if (obj.LstSections != null && obj.LstSections.Count > 0)

            {

                foreach (var objSection in obj.LstSections)

                {

                    var tNode = new RadTreeNode(objSection.SectionName);                  

 

                    if (obj.LstSimpleFields != null && obj.LstSimpleFields.Any(h => h.FkDocumentTemplateSectionId == objSection.DocumentTemplateSectionId))

                    {

                        var tNodeChildSimpleFields = new RadTreeNode("Simple_fields_Control");

 

                        foreach (var objSimplefield in obj.LstSimpleFields.FindAll(h => h.FkDocumentTemplateSectionId == objSection.DocumentTemplateSectionId))

                        {

                            var tNodeChildGridTextEntry = new RadTreeNode(objSimplefield.FieldName);

                            tNodeChildGridTextEntry.Nodes.Add(new RadTreeNode

                            {

                                Text = objSimplefield.FieldCode,//these are the leaf node

                                AllowEdit = true,//this I have done as a last possible option

                                AllowDrop = true,//this I have done as a last possible option

                                AllowDrag = true//this I have done as a last possible option

                            });

                            tNodeChildSimpleFields.Nodes.Add(tNodeChildGridTextEntry);

                        }

                        tNode.Nodes.Add(tNodeChildSimpleFields);

                    }

                    TreeView1.Nodes.Add(tNode);

                }

            }

             

            

Please suggest me how can i achieve my desired reuslt.
Any help guys?

Hi,

can anyone please help, I am in the process of converting one of our working basic repeaters into a RadListView.

On the OnItemDataBound event I want to fire some code to format items in the itemtemplate using one of our business objects "tblVehicle" with the following code:

However, at the line

tblVehicle item = ((tblVehicle)e.Item).DataItem;
I'm getting the following error: Cannot convert type 'Telerik.Web.UI.RadListViewItem' to 'tblVehicle'
I'm sure there is a simple answer to this as everything worked fine under a straightforward repeater control.
Any help would be greatly appreciated.

Regards
Dale

Hello Everyone,

i want to create one drop-down menu like shown in image on all row of RadGrid where i can click on individual link to perform task like edit,delete etc,


can anyone have idea about this?

Thanks

I have a grid that works great.

When I edit it I fill a combo box with data.  Everything works great until I change EditMode to InPlace.  When I do that the combo box has the DataTextField in its SelectedValue field.

Here is how I load the data into the RadComboBox.


When I read the data I do this.

If I have EditMode="InPlace" in my MasterTableView tag then the .SelectedValue equals the Description instead of the ID.

If I remove EditMode="InPlace" then .SelectedValue equals the ID.

i want to Display  InvalidStyle and ErrorMessage inside RadInput,but only display style, the errorMessage not display
code like this

Hi, 

In RadAutoCompleteBox, when we add tokens, each one has a button to remove it from the list.
The tooltip for the button has text 'remove token'.
 Is it possible to change the text on the tooltip for this button to something other than 'remove token'.

I've seen a similar question for changing the remove icon image but not sure how to go about it for tooltip.

Thanks

Hi,

        I used the textbox in edit template for update the values in gridview. But I got the problem(Collection was modified; enumeration operation may not execute.) .Please give me the solution.

My Code behind code:

 protected void RadGrid1_UpdateCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
        {
            GridDataItem id = (e.Item as GridDataItem);
            string Empid = id.OwnerTableView.DataKeyValues[id.ItemIndex]["EmpId"].ToString();
            foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
            {
                TextBox txtleavetaken = (TextBox)item.FindControl("txttakenleave");
                TextBox txtleaveremain = (TextBox)item.FindControl("txtleavecount");
                TextBox txttotalworkdays = (TextBox)item.FindControl("txttotalworkdays");
                TextBox txtadvance = (TextBox)item.FindControl("txtadvance");
                TextBox txtbonus = (TextBox)item.FindControl("txtbonus");
                TextBox txtothers = (TextBox)item.FindControl("txtothers");
                TextBox txttotalsalary = (TextBox)item.FindControl("txttotalsalary");
                objpl.empname = Empid.ToString();
                objpl.takenleave = txtleavetaken.Text;
                objpl.leave = txtleaveremain.Text;
                objpl.totalworkdays = txttotalworkdays.Text;
                objpl.empadvance = txtadvance.Text;
                objpl.bonus = txtbonus.Text;
                objpl.empothers = txtothers.Text;
                objpl.totalsalary = txttotalsalary.Text;
                objbl.updatesalarydetail(objpl);
                fullviewstaff();
            }



Thanks,
Arun.

Hello,

How to add legend in Pie chart dynamically.

like diff. data with diff. label

I need to do an insert of a details record but I need to obtain the master record ID.  During the InsertCommand event, I have the GridDataInsertItem and I then create a GridTableView of the master table using this:

Dim parenttable As GridTableView = inserteditem.OwnerTableView.ParentItem.OwnerTableView


I used this article thinking it would work as it mentions the GridTableView but I've come up blank.  How can I obtain the value?