我有一个存储过程 存储过程中有insert into exec 这种语句，在数据库中执行的话，完全没有问题，但是用ado.net调用的话，总报列名无效。实在不明白是什么原因。

存储过程的作用是获取用户针对某表的记录权限  ado.net 中说此句代码 exec p_get_roles_with_user @userid 有错 说roleid无效

create proc [dbo].[p_get_rows_with_user_table]
@userid varchar(50),
@table varchar(50)
as
begin
set nocount on;
set xact_abort on;

/*
* exec p_get_rows_with_user_table '016327','common_menu'
*/

declare @tableid int;
select @tableid=ct.id from content_table ct where ct.name=@table

create table #role
(
id int,
name varchar(50),
[version] binary(8)
)

--角色
insert into #role(id,name,[version])
exec p_get_roles_with_user @userid


--角色组
select rrg.* into #rolegroup
from rbca_rolegroup rrg
where rrg.id in (select distinct rolegroupid from rbca_role_rolegroup where roleid in (select distinct id from #role))

--角色直接拥有的内容权限
select contentid into #content
from rbca_role_content where tableid=@tableid and roleid in (select id from #role)

--角色组直接拥有的内容权限
insert into #content (contentid)
select contentid from rbca_rolegroup_content where tableid=@tableid and rolegroupid in (select id from #rolegroup)

--用户直接拥有的内容权限
insert into #content (contentid)
select contentid from rbca_user_content where tableid=@tableid and userid = @userid

--用户组直接拥有的内容权限
insert into #content (contentid)
select contentid from rbca_usergroup_content where tableid=@tableid and usergroupid in
(select usergroupid from rbca_user_usergroup where userid = @userid )

declare @filtersql nvarchar(max)
set @filtersql = ''
exec p_get_filtersql_with_user_table @userid,@table,@filtersql output;

if rtrim(ltrim(@filtersql)) <> ''
begin
insert into #content exec sp_executesql @filtersql;
end

declare @sql nvarchar(max)
set @sql = 'select * from ' + @table +' t where cast(t.id as varchar(50)) in (select contentid from #content)'
exec sp_executesql @sql;

end

create proc [dbo].[p_get_roles_with_user]
@userid varchar(50)
as
begin
/*
* exec p_get_roles_with_user '016327'
* 根据用户的角色，包括用户的角色、用户所在用户组的角色、前两者继承的角色得到用户最终拥有的角色
*/
set nocount on;
set xact_abort on;

--获取用户的角色
--用户的角色
select r.* into #role
from (
select rur.roleid
from rbca_user_role rur
where rur.userid = @userid
union
--用户所在用户组的角色
select rugr.roleid
from rbca_user_usergroup ruu
join rbca_usergroup_role rugr
on ruu.usergroupid = rugr.usergroupid
where ruu.userid = @userid
) r

--获取用户的角色继承的角色
;with ihrole as
(
select rri.inheritedroleid roleid
from rbca_roleinherit rri
join #role r
on rri.roleid = r.roleid
union all
select rri.inheritedroleid roleid
from rbca_roleinherit rri
join ihrole ihr
on rri.roleid = ihr.roleid
)
select r.*
from rbca_role r
where r.id in (select distinct roleid
from #role
union
select distinct roleid
from ihrole)
end