SqlDataReader.NextResult有关问题

SqlDataReader.NextResult问题

SQL code

select sum(MealNumber) as 'sum',MealName from #meal group by MealNameselect * from #meal  where persontype = 1 order by MealDate,MealNameselect * from #meal where personType = 2 order by MealDate,MealName

C# code

  string sql = @"select sum(MealNumber) as 'sum',MealName from #meal group by MealName                select * from #meal  where persontype = 1 order by MealDate,MealName                select * from #meal where personType = 2 order by MealDate,MealName";comm.commandText = sql;SqlDataReader dr = comm.ExecuteReader();