[Solved] Grid binding to DateSet/DataTable support

[Jason]

I noticed a closed (Resolved) ticket on this issue stating it will be in 2010 Q1 +SP, but even in Q2 I do not see this functionality.

Am I missing documentation, is there a work around, should I continue searching the forums?

-Jason

[Atanas Korchev]

Hello Jason,

I am sending you a sample project showing binding to DataTable. However there are a few important limitations:

1. Editing is not supported in this mode as there is no way to set the data keys (they need strongly typed expressions)
2. Filtering does not work (perhaps we would implement DataTable filtering support in the future)
3. Only server binding is supported because of the inability of the JavaScriptSerializer object to serialize a DataTable as JSON.

Regards,
Atanas Korchev
the Telerik team

[Jason]

Thank you, I appreciate it. =)

-Jason

[Jason]

One last question. Normal column binding will not work in my case as we have very dynamic data (fiscal reporting) where the months / years / etc changes with each report. I thought I could get around this issue with...

<%= Html.Telerik().Grid<System.Data.DataRow>(Model.ReportModel.Data.Rows.Cast<System.Data.DataRow>())
       .Name("Grid")
         .Columns(columns =>
         {
           foreach (System.Data.DataColumn temp in Model.ReportModel.Data.Columns)
           {
             columns.Bound(temp.DataType, temp.ColumnName);
           }
         })
       .Pageable()
       .Sortable()
       .Scrollable()
       .Groupable()
%>

But I get

Templates can be used only with field access, property access, single-dimension array index, or single-parameter custom indexer expressions.

The table is made up of only strings.

-Jason

[Jason]

Would like to bump for a solution.

With the code you sent me earlier

<%= Html.Telerik().Grid<System.Data.DataRow>(Model.Rows.Cast<System.Data.DataRow>())
    .Name("Grid")
   .Pageable()
   .Sortable()
   .Scrollable()
   .Groupable()

I would get a grid that is empty with header columns "Row Error", "Row State", and "Has Error" (which is not reflective of my data). Thus I tried modifying the code to what I had in the previous post but got that error.

Any word yet on what might be going on, do you need more information?

-Jason

Edit: I have a Json version of my dataset if this would be easier to databind to given I'm doing ajax post backs.

[Atanas Korchev]

Hi Jason,

 I have modified the sample project to generate the columns on the fly. Check it out.

All the best,
Atanas Korchev
the Telerik team

[Rickard]

This example does not work when you add .Filterable()

I can’t find any documentation about the DataTable feature in the Grid. Is it fully supported in MVC Q2 2010?

[Rosen]

Hello Rickard,

Indeed, as mentioned in the original post by my colleague Atanas, the provided sample does not work when filtering is enabled. 

However, I'm happy to inform you that we are working on few improvements (such as support for filtering and ajax binding) when binding to a DataTable. They will be available with the Q3 2010 release of Telerik Extensions for ASP.NET MVC. 

Greetings,
Rosen
the Telerik team

[Alex]

Hello, I did discover a way to get ajax binding to work on a dynamic datatable. I send the model an empty datatable so the grid can get the columns. I then converted the datatable into a dictionary object, then I use custom paging to retrurn the data.

I have a sample application on my site http://alexrogan.com/?p=13

[ajmal]

Hello Alex/All Expert,

Is there any work around for client side binding "onDataBinding"?

i'm looking for the client binding ?

Thanks,
Ajmal

[Simon]

@Alex: Please mark your post as obsolete because it is possible to use a normal datatable and pass it via GridModel to the client, no need to transform it in an Enumerable. I found this because I tried to implement sorting and filtering in your solution. I attached a sample project to prove this!

Regards
Simon

[Irwin]

Does this solution also work with Editing now or is that still unsupported?  I tried to add editing using

.Editable(editing => editing.Mode(

 

GridEditMode.InLine))

 

But that caused an error.

Is there a solution to dynamicly add columns, and also allow editing?

thanks,
Irwin

[Michael]

Hi,

I'm using the latest sample code in this thread to bind my DataTable.  When I have a space in my column names, I get this error:
"Microsoft JScript compilation error: Expected ';'"

Anyone else experience the same issue?