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) 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?