[Solved] Filter expression LIKE operator

[Prabhu]

Hi,

            Im having Gird, Textbox and a search button in the form. User has to enter the value into the textbox and upon clicking the button, ive to show the records that matches the text from textbox in Radgrid. I've used the following code to accomplish the task.

protected

 

void imgSearch_Click(object sender, EventArgs e)

 

{

    Grd1.EnableLinqExpressions =

false;

 

 

    string l_filer = string.Empty;

 

 

    if (!String.IsNullOrEmpty(txtName.Text.Trim()))

 

        l_filer =

"name LIKE '" + txtName.Text.Trim() + "'";

 

 

    else

 

        l_filer =

"1 = 1 ";

 

    GrdUDF.MasterTableView.FilterExpression =

"(" + l_filer + ")";

 

    GrdUDF.Rebind();

}

Here the problem is, when I give the exact word in the textbox, it will give me the result. but I want to search the records using "Contains". say for example, If I'm giving "D" in textbox, it should show the list of records, that contains "D". if nothing I there, then I've to show all the records in the grid.

I dont know, where I slipped. any help????
thanks in advance,
Prabhu KS

[Prabhu]

 

Hai,
    I solved above issue. its pretty simple. I found help from one of the forum. now, I want to do same search in hierarchical grid. if the text in the texbox matches with any of the detail table record, then we have to show parent records. on expanding the parent item, i will fetch the detail values from DB(HierarchyLoadMode="ServerBind"). Is that possible???


any help appreciated,
Thanks in advance,
Prabhu KS

[Prabhu]

Hi,

    I face a new problem; I want to search the records using FilterExpression; but it searches records with case sensitive. for example, if I give 'd', it will give list of records that contains 'd' (small) not 'D'(Caps). But I want that too... When the user gives that letter or word, it should search the records in all the cases

Thanks
Prabhu KS 

[Casey]

Prabhu,

It makes sense that the LIKE would only return values when they matched exactly because there were no wildcard characters, so it was searching for the exact value entered. I'm not sure if adding wildcard characters around the following is how the issue was solved or not, but I'd be interested to find out how you were able to resolve it.

l_filer = "name LIKE '%" + txtName.Text.Trim() + "%'"; // not sure if % is the wildcard for RadGrid.

Casey

[Casey]

Hi Prabhu,

To make the filter be case insensitive in a RadGrid change the CaseSensitive property from "True" to "False" in the GroupSettings area.

Casey

<

 

GroupingSettings CaseSensitive="False" />

 

[Prabhu]

Casey,

    By using <GroupingSettings CaseSensitive="False" />, I've solved that issue. Thanks a lot... I want to do same search in hierarchical grid. if the text in the texbox matches with any of the detail table record, then we have to show parent records. on expanding the parent item, i will fetch the detail values from DB (HierarchyLoadMode="ServerBind"). Is that possible???

FYI, I got solution from here...
http://www.telerik.com/community/forums/aspnet-ajax/grid/filtertemplate-filter-value-remains-quot-all-quot.aspx