Search in Two Column

[Olivier]

Hello

I use an Object DataSource to load in my RadAutoCompleteBox.

My table has 3 columns  : ID , TEXT1 , TEXT2

I would like the user can search on the TEXT1 and also the TEXT2 ,

i search in the City table, we have Zip code and City name , and if we can search on the third column
it'll be great.

Have you an solution ?

Thanks
Olivier,

<SFWeb:WebBusinessBindingSource runat="server" ID="WbAffaires" BusinessObjectName="oAffairesBo"></SFWeb:WebBusinessBindingSource>

 <telerik:RadAutoCompleteBox runat="server" ID="RadAutoCompleteBox1" Width="340"  DataSourceID="WbAffaires" Filter="StartsWith" CssClass="RadAutoCompleteBox_Default"
                            DropDownWidth="300px" DataTextField="CityColumn" DataValueField="ZipCodeColumn" InputType="Token" Delimiter="," EmptyMessage="Ville, CP ou département.">
                            </telerik:RadAutoCompleteBox>

[Olivier]

Hello

Nobody has a answer ?

if it's possible or not ?

[Cat Cheshire]

You can implement the search in two colums with some custom logic in the SelectMethod of your ObjectDatasource:
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.objectdatasource.selectmethod.aspx

[Olivier]

Have an sample ?

If i have name and last name ?

john smith
eddy white

i want search "john" or "eddy" or "smith" or "white"

I make in my query  : select name+' '+lastname from MyTable , but my filter StartWidth and i don't search on "smith" or "White".

thanks
Olivier,

[Kalina]

Hi olivier,

Please take a look at this forum thread where your question has been already answered.


Best regards,
Kalina
the Telerik team

[Olivier]

Hello,

i write Twice cause i have no answer , i m sorry, but it's really important,
if you can help me in other post, i will be very happy !

thanks
Olivier,