日期:2014-05-17 浏览次数:20875 次
ArrayList Hlist = new ArrayList();
while (sdr3.Read())
{
Hlist.Add(sdr3.GetInt32(0));
}
sdr3.Close();
con3.Close();
int[] num1 = new int[Hlist.Count];
Hlist.CopyTo(num1);
//
SqlConnection con2 = new SqlConnection(str2);
con2.Open();
string sql2 = "select Top 1 SNo from Student where SFirst='"+x+"' ORDER BY SScore ASC";
qlCommand cmd2 = new SqlCommand(sql2, con2);
SqlDataReader sdr2 = cmd2.ExecuteReader();
ArrayList Nlist = new ArrayList();
while (sdr2.Read())
{
Nlist.Add( sdr2.GetString(0));
}
sdr2.Close();
con2.Close();