多结果集的访问

Using (SqlConnection conn = new Sqlconnection(Connectstring))

{

String Cmdtext = "Select top 10 from customers;Select lastname,firstname from employees";

Sqlcommand cmd = new SqlCommand(Cmdtext,conn);

cmd.connection.open();

sqlDataReader reader = cmd.ExecuteReader();

do {

while (reader.read)

sb.AppendFormat{"{0},{1}<br/>",reader[0],reader[1];

}

while (reader.NextResult());

}

response.write(sb.tostring);