SqlDataReader无法读取无列名字段值?

[shuangfeiyan]

SqlDataReader sdr = cmd.ExecuteReader();
string name="", age="",col_name="",mc="";
while (sdr.Read())
{
name = sdr["name"].ToString();
age = sdr["age"].ToString();
col_name = sdr.GetString(3);
mc = sdr.GetString(4);
}

cmd为执行一存储过程,获得如下临时表:

name age (无列名) (无列名)
karl 20 ssss dddd

提示数组索引越界,我将GetString(3)和GetString(4)改为GetString(2)没错误提示.但我现在要用到第三列和第四列中的值,怎么办?有哪位大哥指点一下.在线等待.

[wzl_1008]

执行查询获得结果集的时候给他一个字段名好了

[shuangfeiyan]

create proc proc_get_table
@name varchar(80),
@ppid varchar(30) output,
@mc varchar(80) output
with encryption
as
if exists(select * from XX where XXMC=@name)
begin
set @ppid='XXDM'
set @mc='XXMC'
select name,XXDM,@ppid,@MC from sysobjects,XY where name='XY'and XXMC=@name
return
end
else if exists(select * from XY where XXMC=@name)
begin
set @ppid='XXDM'
set @mc='YXSMC'
select name,XXDM,@ppid,@MC from sysobjects,XY where name='XB'AND XXMC=@name
return
end
else if exists(select * from XB where YXSMC=@name)
begin
set @ppid='YXSH'
set @mc='ZYMC'
select name,YXSH,@ppid,@MC from sysobjects,XB where name='ZY'and YXSMC=@name
return
end
else if exists(select * from ZY where ZYMC=@name)
begin
set @ppid='ZYDM'
set @mc='BJMC'
select name,ZYDM,@ppid,@MC from Sysobjects,ZY where name='BJ' and ZYMC=@name
return
end

怎么才能给定那两个无列名字段的字段名?

[YouTuBe]

不错

[shuangfeiyan]

哦,知道怎么搞了,谢谢了!
select name,ZYDM,p=@ppid,m=@MC from Sysobjects,ZY where name='BJ' and ZYMC=@name