This is a migrated thread and some comments may be shown as answers.

Kendo MVC Grid through Stored procedure returning Dynamically created Columns

1 Answer 96 Views
Grid
This is a migrated thread and some comments may be shown as answers.
himanshu
Top achievements
Rank 1
himanshu asked on 26 Jan 2014, 11:48 AM
Am trying to use Linq (VB.net) to populate grid with data returning from MS SQL Stored procedure. 
1) Every thing works fine if SP returns fixed numbers of colums ex - 

Create procedure testp1 as 
begin 
select * from tab_a
end

2) How ever things dont work if SP returns dynamically created column names ex - 

Create procedure testp2 as 
begin
select 'T'+ltrim(str(day(getdate()-2),2)),'T'+ltrim(str(day(getdate()-1),2)),'T'+ltrim(str(day(getdate()),2))
end

Is there a way to populate data grid for SP like second one given above?

1 Answer, 1 is accepted

Sort by
0
Petur Subev
Telerik team
answered on 29 Jan 2014, 08:08 AM
Hello Himanshu,

I posted a reply in the support ticket that you opened on the same subject. Feel free to continue our conversation here or in the support thread.

Kind Regards,
Petur Subev
Telerik
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
Tags
Grid
Asked by
himanshu
Top achievements
Rank 1
Answers by
Petur Subev
Telerik team
Share this question
or