I have the  Person class with the following fields which reflects the table structure.
field               datatype
Id                   long
Name             string
Title               string
Supervisor     long


I want to build a self referencing grid. I keep getting the following error

System.Data.SyntaxErrorException: Syntax error in Lookup expression: Expecting keyword 'Supervisor' followed by a single column argument with possible relation qualifier: Supervisor[(<relation_name>)].<column_name>.


I have tried the various combinations of filterexpression in the Page_load event but none seem to work.

 RadGrid1.MasterTableView.FilterExpression = "Supervisor = 0";
 RadGrid1.MasterTableView.FilterExpression = "it.Supervisor = 0";

I am populating ICollection<Person> and setting it to the RadGrid1 datasource property.

I am not sure what is causing this error. I have looked through the forums but havent found any help in this matter.

Thanks

I need to apply filtering for a column in my RadGrid.  The column is an int column, and the user must be able to filter multiple selections.  I want to do something like this:  select * from <table> where num in (X,Y,Z).

protected void RadGrid1_ItemCommand(object source, GridCommandEventArgs e)

{

if (e.CommandName == RadGrid.FilterCommandName)

{

Pair filterPair = (Pair)e.CommandArgument;

switch (filterPair.Second.ToString())

{

case "vendNum":

TextBox tbPattern = (e.Item as GridFilteringItem)["vendNum"].Controls[0] as TextBox;

if (tbPattern.Text.Contains(","))

{

string[] values = tbPattern.Text.Split(',');

if (values.Length >= 2)

{

e.Canceled = true;

StringBuilder newFilter = new StringBuilder();

for (int i = 0; i < values.Length; i++)

{

if (i == values.Length - 1)

newFilter.Append("([vendNum]='" + values[i] + "')" );

else

newFilter.Append("([vendNum]='" + values[i] + "') OR ");

}

if (RadGrid1.MasterTableView.FilterExpression == "")

RadGrid1.MasterTableView.FilterExpression = newFilter.ToString();

else

RadGrid1.MasterTableView.FilterExpression = "((" + RadGrid1.MasterTableView.FilterExpression + ") AND (" + newFilter.ToString() + "))";

RadGrid1.Rebind();

}

}

break;

default:

break;

}

}

}

Hello All,

I have a fix situation here, i am loading one aspx page into another take example i am loading default2.apsx in default1.aspx using basic ajax xmlhttp request . thats working, but when i am using my rad controls in default2.aspx  , they do not work in default1.aspx what should be done? new to telerik totally so need a claer concept in solving this .


Thank you All
Varsha

Hi

How to do this with Rad Text Box:

1- Prevent Data duplication when insert a new record (something like user name) , so say if the user entered a user name which is already exist then he ll get an error message (i know i can do that back in the database by making the column unique but then on the client side the sql error message will appear which will look ugly.

2- is there any option to make all the inputs UPPER CASE regardless the user inputs.

Thanks

My company has a host of custom widgets that we would like to expose to our our clients to the RadEditor control.  In order to accomplish this, we would like to have a tag like:

<c:CustomPanel Title="Title on Widget" Content="Widget Content" />

When rendered in design view, we would like to prevent the user from typing into certain places.  ie:

<Table>
<Tr>
<Td class="leftSideTitle"></td>
<td>Title on Widget</td>
<td class="rightSideTitle"></td>
</tr>
<Tr>
<td class="leftSide"></td>
<td>Widget Content</td>
<td class="rightSide"></td>
</tr>


In this example, we would like to prevent the user from typing into those left and right cells and remove the dashed lines around them.

Is there some built in functionality that would help us to accomplish this ?

Thank you very much.

-D

I am using LoadOnDemand to populate TreeView nodes from a webservice.

We have this extra dead space on firefox broser. Attached screen explain the same.

Please suggest a solution.

Thanks,
Shubod

I've noticed that when you create your own custom ContextMenu commands for the Editor and set ShowIcon="false" that the text is not aligned correctly. The text is shown over the "dark-gray" section reserved for images.

Hello All,

I am trying to understand what is happening and I need a lifecycle explanation. 

I have an RadAjaxPanel where on page load, I dynamically creat and populate three comboboxes.  Combobox 1 drives the data in combobox 2 and combobox 3.  I have set the autopostback to true on these controls.  Combobox 1 defaults to Item A, Combobox 2 defaults to Item M, Combobox 3 defaults to Item X.

If I change Combobox 1 to Item B, this change is not see during the page load event because the control is being created.  Therefore, combobox 2 and combobox 3 are filled with the items that correspond to Item A in combobox 1.  Since "viewstate" has not been applied at this time, the combobox 1 thinks its value is Item A.

During the SelectedItem event, the viewstate has loaded and the combobox now has item B.  I assume that at this point I can clear out and re-load combobox 2 and 3 to have their data on the page updated.

Just for fun, I decided to fill combobox 2 with different data on the page load event if the page was in a postback.  Imagine my surprise when the combobox 2 showed the original data that was loaded the first time in the page and not the "New" data I forced in during the postback.  Why is this?  Is the viewstate holding all of the valid data items for this control and resetting it after the page load event?