Read resultset from a combined queries : Combined Queries : ADO.Net C# Examples

    
using  System;
using  System.Data;
using  System.Data.SqlClient;

class  MultipleResults
{
      static  void  Main(string[]  args)
      {
            string  connString  =  @"server  =  .\sqlexpress;integrated  security  =  true;database  =  northwind";

            string  sql1  =  @"select  companyname,contactname  from  customers  where  companyname  like  'A%'";

            string  sql2  =  @"select  firstname,lastname  from  employees";

            string  sql  =  sql1  +  sql2;

            SqlConnection  conn  =  new  SqlConnection(connString);

            try
            {
                  conn.Open();
                  SqlCommand  cmd  =  new  SqlCommand(sql,  conn);
                  SqlDataReader  rdr  =  cmd.ExecuteReader();
                  do
                  {
                        while  (rdr.Read())
                        {
                              Console.WriteLine("{0}  :  {1}",  rdr[0],  rdr[1]);
                        }
                        Console.WriteLine("".PadLeft(60,  '='));
                  }
                  while  (rdr.NextResult());

                  rdr.Close();
            }
            catch(Exception  e)  
            {
                  Console.WriteLine("Error  Occurred:  "  +  e);
            }
            finally
            {
                  conn.Close();
            }
      }
}