I have embed the spreadsheet for MVC in my mvc application.I am loading data from database into a dataset and I want to bind the dataset to my spreadsheet. I am not using Entity Framework as my database and column retrieved dynamic and changes each time. Hence i wont be able to create a model for my values.
Below is my code for loading data to dataset
public ActionResult Products_Load([DataSourceRequest]DataSourceRequest request)
DataSet ds = HandlerFunctions.GetDynamicSheetData(1, 2);
var das = ds.Tables.AsEnumerable().AsQueryable();
DataSourceResult result = das.ToDataSourceResult(request);
I am struck on how to map this dataset to my spreadsheet in the cshtml using @(Html.Kendo().Spreadsheet()
Can anyone help me in how to bind the dataset to spreadsheet control in razor view?