NextResult()问题

Question

string strcnn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\vsio\\mydata.mdb";
string sql="select xuehao,score from score;select num,xuehao,name from student";
         OleDbConnection connection=new OleDbConnection(strcnn);
try
{
 connection.Open();
 Console.WriteLine("The Access data is {0}",connection.State);
 OleDbCommand command=connection.CreateCommand();
 command.CommandText=sql;
 OleDbDataReader reader=command.ExecuteReader();
 while(reader.Read())
 {
   Console.WriteLine("\t{0}\t{1}",reader["xuehao"],reader["score"]);
 }
Console.WriteLine("The data in \"student.mdb\" is read completely"); reader.NextResult();
int num=reader.FieldCount;
for(int i=0;i<num;i++)
{
  Console.WriteLine("\t{0}\t{1}",reader["xuehao"],reader["name"]);
}
  Console.WriteLine("The data in \"score.mdb\" is read completely");
reader.Close();
}
      
写上string sql="select xuehao,score from score;select num,xuehao,name from student";这句之后,就一个数据库的内容也显示不了了,但单写任何一个都没问题

Answer 1

reader.NextResult();
之后你还是要用
while(reader.Read())
{
}
来读取数据即
reader.NextResult();
int num=reader.FieldCount;
for(int i=0;i<num;i++)
{
           while(reader.Read())
          {
     Console.WriteLine("\t{0}\t{1}",reader["xuehao"],reader["name"]);
          }
}

Answer 2

好象不行啊,还是提示 "在 SQL 语句结尾之后找到字符"
应该不是读取的问题,而是reader.NextResult()的问题.