ADO.NET查询多张表的结果集

使用DataAdapter查询

            #region//使用DataAdapter方式
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataSet set = new DataSet();
            adapter.Fill(set);
            if (button4.Text=="查课程")
            {
                button4.Text = "查老师";
                textBox3.Text = "";
                for (int i = 0; i < set.Tables[0].Rows.Count; i++)
                {
                    textBox3.Text += set.Tables[0].Rows[i]["SUBID"].ToString() + set.Tables[0].Rows[i]["SUBName"].ToString()+"\r\n";
                }
            }
            else if (button4.Text=="查老师")
            {
                button4.Text = "查课程";
                textBox3.Text = "";
                for (int i = 0; i < set.Tables[1].Rows.Count; i++)
                {
                    textBox3.Text += set.Tables[1].Rows[i]["工号"].ToString() + set.Tables[1].Rows[i]["姓名"].ToString() + "\r\n";
                }
            }
            #endregion

使用DataReader查询

 #region//使用DataReader方式
            SqlDataReader reader=cmd.ExecuteReader();
            while (reader.Read())
            {
                textBox3.Text += reader["SUBID"].ToString() + reader["SUBName"].ToString() + "\r\n";
            }
            if (reader.NextResult())
            {
                while (reader.Read())
                {
                    textBox3.Text += reader["工号"].ToString() + reader["姓名"].ToString() + "\r\n";
                }
            }
            reader.Close();
            #endregion