SqlConnection scon = new SqlConnection(……);
SqlCommand scom = new SqlCommand(scon,"select * from Student where Class = '计算机班' and Grender = 1");
scon.Open();
SqlDataAdapter ada=new SqlDataAdapter(conn,comm);
DataTable dt=new DataTable();
ada.fill(dt);
//得到dt,想显示哪个循环输出就可以了