学习Unity3D之VS中的多表查询操作。

欢迎来到unity学习、unity培训、unity企业培训教育专区，这里有很多U3D资源、U3D培训视频、U3D教程、U3D常见问题、U3D项目源码，我们致力于打造业内unity3d培训、学习第一品牌。

 

首先在引入命名空间:            
       using System.Data;
       using System.Date.Sqlclient;
       using System.Collections;
然后建立类方法：
       ArrayList list=new ArrayList();
       public ArrayList Show(){
           Sqlconnection con=new    Sqlconnection("server=.;database=class;Trusted_connection=SSPI");
           con.Open();
           string sql = "select  S.id,S.name,G.score from student as S left join grade as G on S.id=G.sid";
           SqlCommand com = new SqlCommand(sql, con);
           SqlDataReader reader = com.ExecuteReader();
           while (reader.Read())
           {
               Student s1 = new Student();
               s1.Id = (int)reader.GetValue(0);
               Student s2 = new Student();
               s2.Name = (string)reader.GetValue(1);
               Grade g = new Grade();
               g.Score = (int)reader.GetValue(2);
               list.Add(s1);
               list.Add(s2);
               list.Add(g);
           }
           reader.Close();
           con.Close();
           return list;
       }
再建立一个迭代器类方法：
       public void Show() {
            ArrayList list = new Grade().Show();
            IEnumerator it = list.GetEnumerator();
            while (it.MoveNext())
            {
                Student s1 = (Student)it.Current;
                it.MoveNext();
                Student s2 = (Student)it.Current;
                it.MoveNext();
                Grade g = (Grade)it.Current;
                Console.WriteLine(s1.Id+"   "+s2.Name + "   " + g.Score);
            }
        }
最后引用迭代器的类方法就可以了：
       case "4":
           Show();
           break;