Using filters values to query database

[Pether Wiklander]

Hi,

I've been trying to figure out if this is even possible. I have a application with high demands on performance and would like to use the gridview filters for filtering in SQL. I would like to do something like this....

	protected void RadGrid_NeedDataSource( object source, GridNeedDataSourceEventArgs e )
	{
	ObjectID statusID = null;
	IssueStatusDropDownList statusDropDownList = ((RadGridIssueStatusColumn)_radGrid.Columns.FindByUniqueName( "StatusColumn" )).FilterDropDownList;
	if( statusDropDownList != null )
	{
	if( statusDropDownList.SelectedValue != IssueStatusDropDownList.ALL_ISSUE_STATUSES )
	statusID = new ObjectID( statusDropDownList.SelectedValue );
	}
	List<Issue> issueList = Issue.GetList( statusID );
	_radGrid.DataSource = issueList;
	}

Is this possible?

[Yavor]

Hello Pether,

Indeed, such an approach is possible. Additionally, when resetting or changing the selection of the dropdown, you can rebind the grid, ensuring that the NeedDataSource event will be called again, allowing you to pass the new data. Additionally, you can set the filter expression for the control directly, as shown in the following article.
I hope this information helps.

Greetings,
Yavor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.