Question

C#SqlDataReader怎么用

Answer 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())
{
return reader.Cast<IDataRecord>().Select(p => new OrderDetailExecuteData
{
SID = reader.GetInt64(0),
SupplierName = reader.GetString(1),
BillNO=reader.GetString(2),
ProductName = reader.GetString(3),
Spec = reader.GetString(4),
Material = reader.GetString(5),
MadeIn = reader.GetString(6),
Standard =reader.GetString(7),
Unit = reader.GetString(8),
Nums=reader.GetDecimal(9),
Remark = reader.GetString(10),
Price = reader.GetDecimal(11),
SubTotalPrice = reader.GetDecimal(12),
DeliveryDate = reader.GetDateTime(13),

PayPrices = reader.GetDecimal(14),
UnPayPrice = reader.GetDecimal(15),
OrderRemark=reader.GetString(16),
ContractFile = reader.GetString(17),

}).ToList().AsQueryable();
}
}
}