用dataset返回值问题
代码是这样的
default2.aspx代码
         id = Request.QueryString["id"].ToString();
         DAL.DisciplineInfo da = new DAL.DisciplineInfo();
         DataSet ds = da.GetAll(id, "selectid");
         Name = ds.Tables[0].Rows[0][1].ToString();
         Type = ds.Tables[0].Rows[0][2].ToString();
         Grade = ds.Tables[0].Rows[0][3].ToString();
         ContructGrade =Convert.ToByte(ds.Tables[0].Rows[0][4].ToString());
          Field = ds.Tables[0].Rows[0][5].ToString();
         LeaderNO = ds.Tables[0].Rows[0][6].ToString();
         Intro = ds.Tables[0].Rows[0][7].ToString();
DisciplineInfo.cs 代码
   public DataSet GetAll(string id,string zx)
         {
             SqlParameter[] para ={                  
                new SqlParameter("@zx",zx),
                new SqlParameter("@Id",id),               
                            };
             return SqlHelper.GetList("DisciplineInfo1", para);
SqlHelper.cs代码
  SqlDataAdapter sda = new SqlDataAdapter();
             sda.SelectCommand = BuildCommand(storeProcName, para);
             DataSet ds = new DataSet();
             sda.Fill(ds);
             Closecon();
             return ds;
存储过程是
ALTER proc [dbo].[DisciplineInfo1] @zx varchar(6),@id varchar(6)=null,@DisciplineName varchar(40)=null,@DisciplineType char(6)=null,@DisciplineGrade char(8)=null,@ContructGrade tinyint=null,@ToDisciplineField varchar(10)=null,@AcademicLeaderNO varchar(8)=null,@DisciplineIntro text=null
as
if @zx='insert'
        insert DisciplineInfo values(@id,@DisciplineName,@DisciplineType,@DisciplineGrade,@ContructGrade,@ToDisciplineField,@AcademicLeaderNO,@DisciplineIntro);
if @zx='update'
update DisciplineInfo set  
DisciplineName=@DisciplineName,DisciplineType=@DisciplineType,DisciplineGrade=@DisciplineGrade,ContructGrade=@ContructGrade,ToDisciplineField=@ToDisciplineField,AcademicLeaderNO=@AcademicLeaderNO,DisciplineIntro=@DisciplineIntro
           where Id=@id;
if @zx='delete'
  DELETE FROM DisciplineInfo WHERE Id=@id;
if @zx='select'
select * from DisciplineInfo;
if @zx='selectid'
select * from DisciplineInfo where Id=@id;  
为什么总是返回首行首列的,不能返回指定编号的数据啊
------解决方案--------------------
那取决于你的id值是多少,你看看id值变没变,从id入手查问题
------解决方案--------------------
在datalist中使用模板列,通过ID查询值
或使用model,使用实体类为属性,显示NAME