UI层
volleyBll bll = new volleyBll();
        private void xiangxibifen_Load(object sender, EventArgs e)
        {
            dataGridView1.DataSource= bll.selectxiangxidefen();
            DataTable dt = bll.selectxiangxidefen();
            for (int i = 0; i <dt.Rows.Count;i++) 
            {    int j=0;
                 
                if (dt.Rows[i][2] == DBNull.Value)
                { continue;  }
                else
                {
                     j= Convert.ToInt32(dt.Rows[i][2]);
                }
                
               
               dataGridView1.Rows[i].Cells[0].Value = http://www.mamicode.com/bll.selecxuanshou(j, 1);
              
            }
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                int k = 0;
                if (dt.Rows[i][4] == DBNull.Value)
                { continue; }
                else
                {
                    k = Convert.ToInt32(dt.Rows[i][4]);
                }
                dataGridView1.Rows[i].Cells[1].Value = http://www.mamicode.com/bll.selecxuanshou(k, 7);
            }
        }

BLL
  public DataTable selectxiangxidefen()
        {
            return dal.Selectxiangxidefen();
        }
        public string selecxuanshou(int serialnum, int team)
        {
            return dal.selecxuanshou(serialnum,team);
        }

Dal
 public DataTable Selectxiangxidefen()
        {
            string sql = "select * from score";
            DataTable dt = SqlHelper.ExecuteDataTable(sql);
            return dt;
        }
        public string selecxuanshou(int serialnum, int team)
        {
            string duiyuan = "";
            string sql = "select  name ,dute from team where serialnum=@serialnum and teamnum=@team ";
            SqlParameter[] pms ={
                 new SqlParameter("@serialnum",serialnum),
           new SqlParameter("@team",team)
           
           };
            SqlDataReader reader = SqlHelper.ExecuteReader(sql, pms);
            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    duiyuan = reader[0].ToString() + reader[1].ToString();

                }
               
            }
            return duiyuan;
        }