Csharp/CSharp Tutorial/ADO.Net/Combined Queries
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>