ADO.NET2.0批量数据操作和多动态结果集

string connstr = " server=(local);database=northwind;integrated security=true;async=true " ;
// Fill up a DataSet
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(connstr);
SqlDataAdapter dadp = new SqlDataAdapter( " select * from customers " , conn);
dadp.Fill(ds);
// Copy the Data to SqlServer
SqlBulkCopy bcp = new SqlBulkCopy(connstr);
bcp.DestinationTableName = " customers1 " ;
bcp.WriteToServer(ds.Tables[ 0 ]);

string connstr = " server=(local);database=northwind;integrated security=true;async=true " ;
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
SqlCommand cmd1 = new SqlCommand( " select * from customers " , conn);
SqlCommand cmd2 = new SqlCommand( " select * from orders " , conn);
SqlDataReader rdr1 = cmd1.ExecuteReader();
// next statement causes an error prior to SQL Server 2005
SqlDataReader rdr2 = cmd2.ExecuteReader();
// now you can reader from rdr1 and rdr2 at the same time.