How to filtering multiple columns in SPGridView

Question

I have a webpart with SpGridView. I bind it with ObjectDataSource.

I want filtering multiple columns.

I set AllowFiltering for spgrid:

  grid.AllowFiltering = true;
  grid.FilterDataFields = ",Name,Region,Total Sales";
  grid.FilteredDataSourcePropertyName = "FilterExpression";
  grid.FilteredDataSourcePropertyFormat = "{1} = '{0}'";

and set ObjectDataSource

<asp:ObjectDataSource runat="server" ID="ds"  SelectMethod="GetTable"  ></asp:ObjectDataSource>

   ds.ObjectCreating += new ObjectDataSourceObjectEventHandler(ds_ObjectCreating);
  void ds_ObjectCreating(object sender, ObjectDataSourceEventArgs e)
    {
        myDataTable = new DataTableWrapper(sourceDataTable);

        e.ObjectInstance = myDataTable;
    }

     sourceDataTable = list.GetItems(quary).GetDataTable();
        myDataTable = new DataTableWrapper(sourceDataTable);
        Type t = myDataTable.GetType();
        ds.TypeName = t.AssemblyQualifiedName;

        grid.DataSourceID = "ds";
        grid.DataBind();

But when i click filter i get error

Answer 1

ObjectDatasource takes the TypeName of your data source, not the Qualified name. You need to modify this

Type t = myDataTable.GetType();
    ds.TypeName = t.AssemblyQualifiedName;

so you set the TypeName property to the type name for example "My.ObjectDataSource.NorthwindData" instead of "My.ObjectDataSource.NorthwindData, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e08"