GridView Custom Binding with DataTable

[DevExpress Support Team: This comment was created from a creator's answer]
Thank you for your answer. I looked these examples, but there is no answer to my question.
I need to support large volumes of data. Therefore, sorting, filtering and paging must be performed on the server side .In addition, I work with XML data type, so I can't use Entity Framework.
I can't use the "dataTable" variable as the e.Data because e.Data required IEnumerable (dataTable can't cast to IEnumerable)
I tried to pass there List<DataRow>, List<NameValueCollection>, List<Dictionary<string,string>> but it does not work.
Could you please send me how a line should look like
//e.Data=???
Thank you.

Hello,
You can use a solution from this thread to convert the DataTable to the IEnumerable object.
However, this scenario is not quite correct for this task.
The "binding with large data source" / "custom binding" option is used when it is necessary to:
- Operate a huge number of data records;
- Retrieve a portion of data records from the datasource level and bring it to the web server level.
Since you already have the DataTable object populated, I assume that you have already retrieved all the records from the underlying datasource and brought the data to the web server.
As a result, the advantages of partial data loading are lost. In this case, it is possible to use regular data binding (i.e., the Bind method).
P.S. I have moved your updates to the Comments section.
If you want to post a new update to a ticket, please create a corresponding Comment (not a Solution):
SC2 FAQ

I can't use this solution because (as I wrote above) the set of columns for the query is generated dynamically, so I do not have a typed container class to wrap the result.
dataTable.AsEnumerable() assigned to e.Data but GridView is not filled with data. GridView can fill with data by List<dynamic>, but to initialize a dynamic object need to know the list of columns at compile time(therefore not suitable).
P.S. Sql query generated dynamically according to the filters and paging in GridView so retrieved only portion of data records from the datasource.

I i think i have the same issue; what I need is load the gridview values without a model class… how could do that?

Hello,
Thank you for your reply. We need some additional time to review this scenario to provide you with a precise answer.
We appreciate your patience while we are working on finding a solution to your inquiry.

Last answer solved my problem of loading data without a model. I've downloaded the sample and that was more or less what I needed, in that solution it loads the data into a data set (from a local database), and loads the grid through that data set. (I dont load the data set from a local data base, but from a xml file with linq, and it works)
http://www.devexpress.com/Support/Center/Question/Details/Q470777

@Miguel: If you need further assistance with this subject, please create a separate ticket in our Support Center and describe your situation in greater detail.
@Pavel: We are researching this scenario and will reply as soon as any results are available. Your time and patience are greatly appreciated.

Hello Pavel,
To get data from the DataTable class as an IEnumerable interface use dynamic types such as the ExpandoObject class. With this class, you can dynamically add required properties and set their values. I have prepared an extension method that implements the task:

C#
public static IEnumerable GetData(this DataTable dataTable) {  
   foreach (DataRow data in dataTable.AsEnumerable()) {  
      yield return GetElement(data, dataTable.Columns);  
   }  
}  
static object GetElement(DataRow dataRow, DataColumnCollection columns) {  
   var element = (IDictionary<string, object>)new ExpandoObject();  
   foreach (DataColumn column in columns){  
      element.Add(column.ColumnName, dataRow[column.ColumnName]);  
   }  
   return element;  
}  

Thank you, This is exactly what I need!

I used this in my mvc gridview and it worked perfectly when there is data in all rows. But I am getting an error "Object cannot be cast from DBNull" on sorting a column which has empty values.