public ArrayList SelectStu(int StuId)
{
ArrayList al = new ArrayList(); SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Connection"]);
con.Open(); string sql = "select * from StudentInfo where studentID="+StuId+"";
SqlCommand com = new SqlCommand(sql,con);
SqlDataReader dr = com.ExecuteReader();
while(dr.Read())
{
al.Add(dr["Name"].ToString());
al.Add(dr["Age"].ToString());
al.Add(dr["Sex"].ToString());
al.Add(dr["Address"].ToString());
al.Add(dr["Phone"].ToString());
al.Add(dr["ClassID"].ToString());
}
return al;
}
{
ArrayList al = new ArrayList(); SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["Connection"]);
con.Open(); string sql = "select * from StudentInfo where studentID="+StuId+"";
SqlCommand com = new SqlCommand(sql,con);
SqlDataReader dr = com.ExecuteReader();
while(dr.Read())
{
al.Add(dr["Name"].ToString());
al.Add(dr["Age"].ToString());
al.Add(dr["Sex"].ToString());
al.Add(dr["Address"].ToString());
al.Add(dr["Phone"].ToString());
al.Add(dr["ClassID"].ToString());
}
return al;
}
注意:这段代码并不完整需要关闭不然error