Csharp/CSharp Tutorial/ADO.Net/Combined Queries

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

Read resultset from a combined queries

<source lang="csharp">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();
     }
  }

}</source>