dal 數(shù)據(jù)訪問層代碼：
------------------------------------------------------------
//綁定idlist,顯示所有人員列表
  public dataset selectidlistall()
  {
       string str = "select p_number,p_name from t_people";
       dataset ds = new dataset();

       mycon = new sqlconnection(dal.dalconfig.connectionstring);
       try
       {
        sqldataadapter mycomm = new sqldataadapter(str,mycon);
        mycomm.fill(ds,"t_people");   
               
        return ds;
       }
       catch(exception exc)
       {
        throw exc;
       }
  }

bll業(yè)務(wù)層代碼：
----------------------------------------------------------------
//綁定idlist,顯示所有人員列表
  public arraylist  selectidlistall()
  {
       dal.tpeopledao peopledao = new tpeopledao();
       dataset ds = new dataset();
       ds = peopledao.selectidlistall();

       // creates and initializes a new arraylist.
       arraylist myal = new arraylist();
       for(int i=0;i<ds.tables[0].rows.count;i++)
       {
        myal.add(ds.tables[0].rows[i][0].tostring() + " " +ds.tables[0].rows[i][1].tostring() );           
       }
       return myal;
  }

頁面層代碼：
-----------------------------------------------------------------
//綁定idlist,顯示所有人員列表
  private void selectidlistall()
  {
       lab.bll.tpeoplebiz peoplebiz = new tpeoplebiz();
       arraylist myal = peoplebiz.selectidlistall();
       this.p_idlist.items.clear();

       for(int i = 0 ;i<myal.count;i++)
       {
        this.p_idlist.items.add(myal[i]);
       }

  }