Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Handle Multiple Results

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();             }          }     }