UI层

namespace MySchool.UI
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private bool flag = false;
        private void Form1_Load(object sender, EventArgs e)
        {
           
            GetGrade();
            flag = true;
            this.dataGridView1.DataSource = studentBll.GetStudentName();
      
        }

        SubjectBLL subjectBll = new SubjectBLL();
        private StudentBLL studentBll = new StudentBLL();
        //获取年级
        public void GetGrade()
        {
            GradeBLL grade = new GradeBLL();
            this.cmbGrade.DataSource = grade.GetGradeEx();
            this.cmbGrade.ValueMember = "GradeId";
            this.cmbGrade.DisplayMember = "GradeName";

        }

        private void btnSelect_Click(object sender, EventArgs e)
        {
           
        }

        private void cmbGrade_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (flag)
            {
                int gradeid = Convert.ToInt32(this.cmbGrade.SelectedValue);
                //MessageBox.Show(this.cmbGrade.SelectedValue.ToString());
                this.cmbSubject.DataSource = subjectBll.GetSubjectEx(gradeid);
              
                this.cmbSubject.ValueMember = "subjectid";
                this.cmbSubject.DisplayMember = "subjectname";

            }
          
        }

        public void SetStuNameAndGradeName()
        {
            //遍历列中的cell的值
            foreach (DataGridViewRow row in this.dataGridView1.Rows )
            {
                int id = (int) (row.Cells["subjectid"].Value);
                row.Cells["subjectname"].Value = subjectBll.GetSubjectEx(id);
                int stuno = (int) (row.Cells["studentno"].Value);
                row.Cells["studentname"].Value=
                this.dataGridView1.Columns["subjectid"].Visible = false;
                this.dataGridView1.Columns["studentno"].Visible = false;
            }
        }
    }
}

namespace MySchool.UI
{
    public partial class FrmAllStudent : Form
    {
        public FrmAllStudent()
        {
            InitializeComponent();
        }

         StudentBLL studetdal = new StudentBLL();
        private void btnSelect_Click(object sender, EventArgs e)
        {
            int totalnum;
            int myreturn;
            string name = this.textBox1.Text;
            DataTable table = studetdal.GetAllStudentByProcedureOutput(name, 1, out totalnum, out myreturn);
            dataGridView1.DataSource = table;
            this.textBox2.Text = totalnum.ToString();
            this.textBox3.Text = myreturn.ToString();
        }

        private void FrmAllStudent_Load(object sender, EventArgs e)
        {

        }

      
    }
}