欢迎大家关注我的日志,今天讲讲ArrayList和迭代器IEnumerator的用法:
1.ArrayList
//引用命名空间
using System.Collections;
//创建ArrayList对象
ArrayList list2 = new ArrayList();
public ArrayList select()
{
//连接数据库
SqlConnection con = new SqlConnection("server=.;database=student;Trusted_Connection=SSPI");
//打开数据库
con.Open();
//多表连接
string sql = "select users.name,score.naumber,score.objects from score inner join users on
users.name=score.name; ";
//创建SqlCommand对象
SqlCommand b = new SqlCommand(sql, con);
SqlDataReader reader = b.ExecuteReader();
while (reader.Read())
{
//创建Users对象调用Users对象中的Name()方法
Users u = new Users();
u.Name = (string)reader.GetValue(0);
corse e = new corse();
e.Naumber = (int)reader.GetValue(1);
corse e1 = new corse();
e1.Objects = (string)reader.GetValue(2);
list2.Add(u);
list2.Add(e);
}
return list2;
}
2.ArrayList和迭代器IEnumerator:
public void show() {ArrayList list2 = new ArrayList();
list2 = new Users().select();
IEnumerator it = list2.GetEnumerator();
while (it.MoveNext () ){
Users u2 = (Users)it.Current;
it.MoveNext();
corse e2 = (corse)it.Current;
Console.WriteLine(u2.Name +""+e2.Naumber );