Binding data to GridView dashboard component in a dashboard extender business rule

[mkalluri]

I was looking for a  way to bind a .net list object to a gridview instead of using DataAdapters. Any examples in this direction are appreciated.

[Cosimo · Accepted solution]

mkalluri,

The grid will need a datatable so all you will need to do is convert your list to a datatable. The data adapter that you define for the grid will be of type Method and Method Type = Business Rule. You then create a Dashboard Data Set rule (commonly called Helper Queries) that returns the intended DataTable object.