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

Popular posts from this blog

list macos calm editors formula editors

how i practical urls indicate .aspx pages asp.net deployed an iis? (preferably but iis)

jaxb - xjc - reworking generated typesafe enum category members