RadAutoCompleteBox within InsertItemTemplate in a RadGrid with DataSourceID set

[Harald]

I use a RadAutoCompleteBox with DataScouceID set inside an InsertItemTemplate of a RadGrid. When clicking on add-record button i got a 'DataSource not set' exception. I have to use the OnDataSourceSelect function to manually control the amount of data. It seems that the databounding has to be earlier. I tried to set the DataSource in the ItemCreate event on the RadGrid, and do not use the DataScouceID property. But in this case, I got an ReadOnlyDataSource in the OnDataSourceSelect event passed and the solution provided below does not work any more. 

Could you please tell me what to do in order to keep the function txtSciMapUser_DataSourceSelect as it is?

Thanks a lot.

 

protected void txtSciMapUser_DataSourceSelect(object sender, AutoCompleteBoxDataSourceSelectEventArgs e)
{
    SqlDataSource source = (SqlDataSource)e.DataSource;
    RadAutoCompleteBox autoCompleteBox = (RadAutoCompleteBox)sender;

    string filterString = e.FilterString;
    string likeCondition = string.Format("'{0}{1}%'", autoCompleteBox.Filter == RadAutoCompleteFilter.Contains ? "%" : "", filterString);

    source.SelectCommand = "SELECT TOP 100 * FROM sm_user WHERE [" + autoCompleteBox.DataTextField + "] LIKE " + likeCondition;
}

[Marin Bratanov]

Hello Harald,

Could you try moving the declarative data source out of the grid so it is directly on the page?

Also, if performance is an issue, I'd suggest you consider fetching the data from a web service (or, of course, a WCF web service). This will reduce the number of requests made for the current page and thus reduce the load on the server and is likely to work faster for the end user as well.

Regards,
Marin Bratanov
Progress Telerik