sql - The data source does not support sorting -

i have dynamic data linq sql asp.net website in vb.net, , having little trouble sorting of gridview , search routine have implemented. on page_load, gridview sorted field (departments.department) in asc order. however, when perform search using code below, error

the data source not support sorting.

i'm assuming problem comes when page_load event tries sort data after search made, because of datasource/id.

dim button = directcast(sender, button) if button.id = btnmulticolumnsearchclear.id     txbmulticolumnsearch.text = [string].empty else     using data new wcphonesdatacontext()         dim employeenamestring string = txbmulticolumnsearch.text         dim searchresults = data.employees.where(function(employees) employees.employee.contains(employeenamestring))          gridview1.datasourceid = ""         gridview1.datasource = searchresults         gridview1.databind()     end using end if 

solved, have new problem, here code used solve issue...

    dim button = directcast(sender, button)     if button.id = btnmulticolumnsearchclear.id         txbmulticolumnsearch.text = [string].empty     else         using data new wcphonesdatacontext()             dim employeenamestring string = txbmulticolumnsearch.text             dim searchresults = data.employees.where(function(employees) employees.employee.contains(employeenamestring))              gridview1.sort("", sortdirection.ascending)             gridview1.datasourceid = ""             gridview1.datasource = searchresults             gridview1.databind()          end using     end if 

i have created new error though. occurs if perform second search without going employees table.

'gridview1' fired event sorting wasn't handled.

if use sqldatasource , connect gridview data source datasourceid, sorting done magically. don't have support it.

but if set datasource object have created in code, sorting not magically happen you. when user clicks on column head, fires onsorting event. have write code handle event. typically mean regenerating data in desired order, or regenerating data , sorting it.

for example, if generate data sql query, create function runs sql query , returns dataset. function takes sort field parameter, pastes sql query. initial display call function passing in default sort order, , onsorting call function passing in desired sort field.