like operator in entitydatasource

Question

I'm using an EntityDataSource in an asp .net form and a Gridview is bound to it. A where clause is used in the entityDataSource:

Where="it.Name like '%@Name%'

@Name is a parameter:

<WhereParameters>
<asp:ControlParameter ControlID="TextBox1" Name="Name" PropertyName="Text" Type="String"  />
</WhereParameters>

But it doesn't work. When I change @Name with a fixed string it works properly, like this:

Where="it.Name like '%ppp%'"

score 7 · Accepted Answer · edited Mar 03 '12 at 09:09

7

Where="it.Name like '%' + @Name+ '%'"

edited Mar 03 '12 at 09:09

answered Feb 28 '12 at 13:15

Adrian Iftode

2

Simple and beautiful - Thanks. Comment from @fubo is also great – Scott Moniz Jul 18 '17 at 17:37

fubo · Answer 2 · 2017-10-18T05:45:08.713

2

A empty TextBox should force the EntityDataSource to show all elements

Where="it.Name like '%' + @Name + '%' OR @Name IS NULL"

edited Oct 18 '17 at 05:45

answered Mar 18 '14 at 08:43

fubo

Down to requirements but yes, in my case this is exactly what i needed! – Scott Moniz Jul 18 '17 at 17:37

2 Answers2