//SqlCommand对象可以不需建立两个！
SqlConnection conn = new SqlConnection("server=(local);uid=sa;pwd=sa;database=Northwind;");
SqlCommand cmd = new SqlCommand("Select top 10 * From Table1", conn);
conn.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
    SqlConnection conn2 = new SqlConnection("server=(local);uid=sa;pwd=sa;database=Northwind;");
    SqlCommand cmd2 = new SqlCommand("Select top 2 * From Table1 Where ID>" + Convert.ToString(sdr["id"]), conn2);
    conn2.Open();
    SqlDataReader sdr2 = cmd2.ExecuteReader();
    while (sdr2.Read())
    {
        Response.Write(sdr2["age"] + "<br/>");
    }
    sdr2.Close();
    conn2.Close();
}
sdr.Close();
conn.Close();