Mega Code Archive

 

Categories / C# / ADO Database

 

Deal with Multiple Results

using System; using System.Data; using System.Data.SqlClient;    class MultipleResults {       static void Main(string[] args) {          string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";          string sql1 = @"select FirstName from Employee;";          string sql2 = @"select FirstName, LastName from Employee;";          string sql = sql1 + sql2;          SqlConnection conn = new SqlConnection(connString);          try          {             conn.Open();             SqlCommand cmd = new SqlCommand(sql, conn);             SqlDataReader reader = cmd.ExecuteReader();             do{                 while(reader.Read()) {                    Console.WriteLine("{0} : {1}", reader[0], reader[0]);                 }                 Console.WriteLine("".PadLeft(60, '='));             } while(reader.NextResult());             reader.Close();          } catch(Exception e) {             Console.WriteLine("Error Occurred: " + e);          } finally {             conn.Close();          }       }      }