Querying Multiple Resultsets Using DataReaders
You can use data readers to iterate through multiple resultsets, as shown in Listing 19.9.
Listing 19.9. Querying Multiple Resultsets
1: program multrsltset; 2: 3: {$APPTYPE CONSOLE} 4: 5: {%DotNetAssemblyCompiler 'C:\windows\microsoft.net\framework\v1.1.4322\System.Data.dll'} 6: 7: uses 8: SysUtils, 9: System.Data, 10: System.Data.SqlClient; 11: 12: const 13: c_cnstr = 'server=XWING;database=ddn_company;Trusted_Connection=Yes'; 14: c_select_company = 'select company_id, company_name from company;'+ 15: 'select state_abbr, state_name from lu_state;'; 16: var 17: sqlcon: SqlConnection; 18: cmd: SqlCommand; 19: rdr: SqlDataReader; 20: begin 21: sqlcon := SqlConnection.Create(c_cnstr); 22: cmd := SqlCommand.Create(c_select_company, ... |
Get Delphi for .NET Developer’s Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
