怎么复制一个SqlDataReader

2025-03-04 04:53:21
推荐回答(1个)
回答1:

string cnn = ConfigurationManager.ConnectionStrings["ReportDataService"].ConnectionString;
using (SqlConnection cn = new SqlConnection())
{
cn.ConnectionString = cnn;
cn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = cn;
cmd.CommandText = "p_OrderDetailExecute";
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SupplierID", SupplierID);
using (var reader = cmd.ExecuteReader())