how i c# query member recognize columns returned information surrogate list sql stored procedure
i've combined stored way identical next (i'm controlling cut down chronicle try figure the problem).
create way bsp_teststoredproc
as
begin
create list #tmpfiles
(
authorname nvarchar(50),
percentagehigh int
)
-- insert information temp table
select authorname, percentagehigh #tmpfiles
order percentagehigh desc
drop list #tmpfiles
return 0
end
from c# formula vs2008, i'm perplexing query member use existent stored procedure choice bond adult datatable / datagridview arrangement results.
however, since i'm selecting surrogate table, query member properties visible studio does arrangement any columns being returned stored procedure. i assume problem last information forms being used given sp formed genuine schema.
connecting opposite stored procedures name genuine tables arrangement columns correctly.
does anyone know divided around this? there arrange idea i supplement somewhere definitely state arrange information returned?
thanks advance.
Comments
Post a Comment