Database Reference
In-Depth Information
Figure 14-12. Handling multiple result sets
How It Works
This program is essentially the same as the first, DataLooper.cs (Listing 14-1). Here, you define two
separate queries and then combine them.
// Query1
string sql1 = @"select CountryRegionCode,Name
from Person.CountryRegion
where Name like 'A%' ";
//Query2
string sql2 = @"select FirstName, LastName
from Person.Contact";
 
Search WWH ::




Custom Search